×
 
 
  •  
$helper.renderConfluenceMacro('{bmc-global-announcement:$space.key}')
TrueSight Smart Reporting for Server Automation 19.01 ... Planning Planning for TrueSight Server Automation - Data Warehouse deployment

Sizing tools for TrueSight Server Automation - Data Warehouse

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

Sizing tools for your database type help you to systematically determine the approximate size requirements for your reports 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 (spreadsheets and scripts) determine the database size by projecting the amount of data that you will have a specified number of days into 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. For instructions for accessing the file and extracting its contents, see Downloading the installation files.

Sizing scenarios

Tools are provided for the supported database types and for specific scenarios, as described in this section.

Note

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

ScenarioRequired sizing tools

Installing TrueSight Server Automation and TrueSight Server Automation - Data Warehouse for the first time

The sizing method provides a way to estimate size requirements based on a set of parameter values.

  • (Oracle users) bds_dbsizing_oracle.xls
  • (Microsoft SQL Server users) bds_dbsizing_sqlserver.xls

For more information about this scenario and instructions for using the worksheets, see Sizing for new product installations and new TrueSight Server Automation installations.

Currently using TrueSight Server Automation and preparing to install and use TrueSight Server Automation - Data Warehouse for the first time

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

  • (Oracle users) bds_dbsizing_for_new_bds_oracle.sql
  • (SQL Server users) bds_dbsizing_for_new_bds_sqlserver.sql
For more information about this scenario and instructions for using the sql scripts, see Sizing for new product installations and existing TrueSight Server Automation installations.

Currently using TrueSight Server Automation and TrueSight Server Automation - Data Warehouse

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

  • (Oracle users) bds_dbsizing_for_existing_bds_oracle.sql
  • (SQL Server users) bds_dbsizing_for_existing_bds_sqlserver.sql

For more information about this scenario and instructions for using the sql scripts, see Sizing for existing product installations and existing TrueSight Server Automation installations.

 Related topics

Impact of TrueSight Server Automation use cases on database size

Was this page helpful? Yes No Submitting... Thank you
Last modified by Ranu Ganguly on Apr 13, 2019
concept requirements databases sizing tools sizing_tools

Comments

Log in or register to comment.

User accounts
Impact of TrueSight Server Automation use cases on database size
© Copyright 1996-2019 BladeLogic, Inc.
© Copyright 2014-2019 BMC Software, Inc.
Legal notices

Powered by Atlassian Confluence and Scroll Viewport

© Copyright 2005-2024 BMC Software, Inc. Use of this site signifies your acceptance of BMC’s Terms of Use . BMC, the BMC logo, and other BMC marks are assets of BMC Software, Inc. These trademarks are registered and may be registered in the U.S. and in other countries.