Sizing tools for TrueSight Server Automation - Data Warehouse

Sizing tools help you to systematically determine the approximate size requirements for your data warehouse before you begin the installation. The sizing tools determine the database size by projecting the amount of data that you will have for a specified number of days in the future. This enables you to determine your database size requirements for any required time period. 
The sizing worksheets and scripts are included in the TSSA-DW<version>-external-files.zip file on the TrueSight Server Automation - Data Warehouse BMC Electronic Product Distribution (EPD) location.

Impact of TrueSight Server Automation use cases on database size

The data warehouse size and performance depends on the amount of historical data that you transfer from the TrueSight Server Automation databases. The data warehouse has an indefinite data retention policy unless you set up archiving. 

The database sizing depends on the following factors:

  • The number of TrueSight Server Automation databases, sites, from which data is transferred to the data warehouse.
    Transferring data from additional sites can result in increase in the data warehouse volume. So, ensure that you carefully plan the number of sites included in the initial data transfer and your subsequent site additions for data transfer. 

  • The number of target servers for which you collect data.
    The data volume resulting from a TrueSight Server Automation job is impacted by the number of servers for which data is collected. Also, the volume resulting from a job run depends on the type of job. For example, Snapshot, Audit, and Compliance Jobs generate more data than other jobs. 

    For a large numbers of servers, the data generated in the job runs and then transferred to the reports data warehouse during each ETL run can be several GB in size.

  • The frequency at which you run jobs.

The following table lists the domain-specific use cases that can also influence database sizing.


Sizing for new TrueSight Server Automation and TrueSight Server Automation - Data Warehouse installations

This sizing method estimates the data warehouse sizing requirements based on a set of parameter values.

If you are installing TrueSight Server Automation and TrueSight Server Automation - Data Warehouse for the first time, do the following:

  1. Download the product files from the TrueSight Server Automation - Data Warehouse BMC Electronic Product Distribution location.
  2. Extract the TSSA-DW<version>-external-files.zip file to a temporary directory.
  3. Depending on your operating system, navigate to the Oracle or Sqlserver directory.
  4. Open the sizing spreadsheet:
    • (Oracle) Database_Sizing_Worksheet_Oracle.xls 
    • (SQL Server) Database_Sizing_Worksheet_Sqlserver.xls
  5. Open the Instructions tab, and follow the instructions in the worksheet.
  6. Open the Survey - New Customer tab, and provide the required values.
  7. Open the DB_SIZE tab and review the following sizing information:
    • (Oracle)
      • Recommended initial disk space, in GB, required by each tablespace in next six months and next year
      • Recommended initial disk space, in GB, required for the archived data considering a retention period of 3 months
    • (SQL Server)
      • Recommended initial disk space, in GB, required by the data file and log file in the reports data warehouse
      • Recommended initial disk space, in GB, required for the archived data considering a retention period of 3 months. Retention period indicates the period of time for which data is retained. Data that is older than the retention period is archived.

Sizing for new TrueSight Server Automation - Data Warehouse and existing TrueSight Server Automation installations

This sizing method estimates the data warehouse sizing requirements by counting the data volume from the TrueSight Server Automation database.

If you are using an existing TrueSight Server Automation and preparing to install and use TrueSight Server Automation - Data Warehouse for the first time, do the following:

  1. Download the product files from the TrueSight Server Automation - Data Warehouse BMC Electronic Product Distribution location.
  2. Extract the TSSA-DW<version>-external-files.zip file to a temporary directory.
  3. Depending on your operating system, navigate to the Oracle or Sqlserver directory.
  4. As a TrueSight Server Automation database user, log in to the TrueSight Server Automation database server and run the following script.

    • Oracle:

      sqlplus <TrueSight_Server_Automation_Database_User>/<TrueSight_Server_Automation_Database_User_Password>@<Database_TNS_ENTRY> @dbsizing_for_new_oracle.sql dbsizing_for_new_oracle.html

    • SQL Server:

      sqlcmd -S <TrueSight_Server_Automation_Database_Server>\<TrueSight_Server_Automation_Database_Instance> -d <TrueSight_Server_Automation_Database_Name> -U <TrueSight_Server_Automation_Database_User> -P <TrueSight_Server_Automation_Database_User_Password> -i dbsizing_for_new_sqlserver.sql -o dbsizing_for_new_sqlserver.html -h-1

  5. Check that the script generates the following file in the directory from where you executed the script:
    • (Oracle) dbsizing_for_new_oracle.html 
    • (SQL Server) dbsizing_for_new_sqlserver.html
  6. Ensure that the HTML file provides the following information:
    • (Oracle)


      • Number of TrueSight Server Automation sites considered for calculation
      • Number of managed servers in the existing environment
      • Number of days for which data was available for calculation
      • Number of days in the past for which server growth is considered for projecting the requirements in the next six months and one year
      • Recommended initial disk space, in GB, required by each tablespace in the reports data warehouse
      • Projected disk space, in GB, required by each tablespace in next six months and one year
      • Recommended initial disk space, in GB, required for the archived data considering a retention period of 3 months
    • (SQL Server)
      • Number of managed servers in the existing environment
      • Number of days for which data was available for calculation
      • Number of days in the past for which server growth is considered for projecting the requirements in the next six months and one year
      • Recommended initial disk space, in GB, required by the data file and log file in the reports data warehouse
      • Projected disk space, in GB, required by the data file and log file in next six months and one year
      • Recommended initial disk space, in GB, required for the archived data considering a retention period of 3 months. Retention period indicates the period of time for which data is retained. Data that is older than the retention period is archived.

Sizing for existing TrueSight Server Automation - Data Warehouse and TrueSight Server Automation installations

This sizing method estimates size requirements for the data warehouse and archived data by counting the data volume from the TrueSight Server Automation database and the data warehouse.

If you are using an existing TrueSight Server Automation and TrueSight Server Automation - Data Warehouse setup, do the following:

  1. Download the product files from the TrueSight Server Automation - Data Warehouse BMC Electronic Product Distribution location.
  2. Extract the TSSA-DW<version>-external-files.zip file to a temporary directory.
  3. Depending on your operating system, navigate to the Oracle or Sqlserver directory.
  4. As a data warehouse database user, log in to the data warehouse database and run the following script.

    • Oracle:

      sqlplus <Data_Warehouse_Database_User>/<Data_Warehouse_Database_User_Password>@<database_TNS_ENTRY> @dbsizing_for_existing_oracle.sql dbsizing_for_existing_oracle.html

    • Microsoft SQL Server:

      sqlcmd -S <Data_Warehouse_Database_Server>\<Data_Warehouse_Database_Instance> -d <Data_Warehouse_Database_Name> -U <Data_Warehouse_Database_User> -P <Data_Warehouse_Database_User_Password> -i dbsizing_for_existing_sqlserver.sql -o dbsizing_for_existing_sqlserver.html -h-1

  5. Check that the script generates the following file in the directory from where you executed the script:
    • (Oracle) dbsizing_for_existing_oracle.html 
    • (SQL Server) dbsizing_for_existing_sqlserver.html
  1. Ensure that the HTML file provides the following information:
    • (Oracle)
      • Number of TrueSight Server Automation sites considered for calculation
      • Number of managed servers in the existing environment
      • Number of days for which data was available for calculation
      • Number of days in the past for which server growth is considered for projecting requirements in the next six months and one year
      • Disk space, in GB, currently being consumed by each tablespace in the reports data warehouse
      • Projected disk space,in GB, required by each tablespace in the next six months and one year
      • Disk space, in GB, required for the archived data

    • (SQL Server)
      • Number of managed servers in the existing environment
      • Number of days for which data was available for calculation
      • Number of days in the past for which server growth is considered for projecting requirements in the next six months and one year
      • Disk space, in GB, currently being consumed by the data file and log file in the reports data warehouse
      • Projected disk space,in GB, required by data file and log file in the next six months and one year
      • Disk space, in GB, required for the archived data

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*