Sizing tools

provides sizing tools that you can use to determine the initial size needed for your reports data warehouse.

Sizing tools for your database type help you to systematically determine the correct size requirements for your data warehouse before you begin the product installation. These tools are in the form of scripts and spreadsheets and vary based on your scenario.

The sizing tools determine the database size by projecting your data amounts by the specified number of days. This enables you to determine your database size requirements for any required time period.

Tools are provided for the supported database types and for specific scenarios, as follows:

• If you are currently using 

  The macro unmigrated-inline-wiki-markup from Confluence is no longer available.

  and are preparing to install and use 

  The macro unmigrated-inline-wiki-markup from Confluence is no longer available.

  .
  If you are already using 

  The macro unmigrated-inline-wiki-markup from Confluence is no longer available.

  , the sizing method estimates warehouse size requirements by counting the data volume from the 

  The macro unmigrated-inline-wiki-markup from Confluence is no longer available.

  database. For more information, see Determining-data-warehouse-size-for-existing-BMC-Server-Automation-users.
• If you are not yet using 

  The macro unmigrated-inline-wiki-markup from Confluence is no longer available.

  and are preparing to install and use 

  The macro unmigrated-inline-wiki-markup from Confluence is no longer available.

  and 

  The macro unmigrated-inline-wiki-markup from Confluence is no longer available.

  .
  If you are installing 

  The macro unmigrated-inline-wiki-markup from Confluence is no longer available.

  and 

  The macro unmigrated-inline-wiki-markup from Confluence is no longer available.

  for the first time, the sizing method provides a way to estimate size requirements based on a set of parameter values. For more information, see Determining-data-warehouse-size-for-new-BMC-Server-Automation-users.

Be sure to download the correct sizing tools for your database type and the current scenario.

Accessing the sizing tools

The sizing files are included in the BDSSA82-servicepackVersion-external-files.zip file. To download the zip file, click the BMC BladeLogic Decision Support for Server Automation 8.2.00 servicepackVersion External Files link on Electronic Product Distribution (EPD) site. It is included with the 

product download files. For instructions on accessing the file and extracting its contents, see Downloading-the-BMC-BladeLogic-Decision-Support-for-Server-Automation-External-Files.

• If you are currently using 

  The macro unmigrated-inline-wiki-markup from Confluence is no longer available.

  and are preparing to install and use 

  The macro unmigrated-inline-wiki-markup from Confluence is no longer available.

  , you need the following files:
  • (Oracle users) get_BBSA_count_for_BDSSA_sizing_oracle.sql and BSARAversion_DW_Sizing_Existing_BBSA_and_New_BDSSA_oracle.xls
  • (Microsoft SQL Server users) get_BBSA_count_for_BDSSA_sizing_SQLServer.sql and BSARAversion_DW_Sizing_Existing_BBSA_and_New_BDSSA_SQLServer.xls
• If you are not yet using 

  The macro unmigrated-inline-wiki-markup from Confluence is no longer available.

  and are preparing to install and use 

  The macro unmigrated-inline-wiki-markup from Confluence is no longer available.

  and 

  The macro unmigrated-inline-wiki-markup from Confluence is no longer available.

  , you need the following files:
  • (Oracle users) BDSSAversion_DWBMC BladeLogic Decision Support for Server Automation_Sizing_New_BBSA_and_New_BDSSA_oracle.xls
  • (SQL Server users) BDSSAversion_DW_Sizing_New_BBSA_and_New_BDSSA_SQLServer.xls