Sizing for new product installations and existing BMC Server Automation installations
If you are currently using
- MultiExcerpt named 'BladeLogic' was not found
- MultiExcerpt named 'Product_Name' was not found
A script gathers the data needed to determine your database size and archival data size requirements from the
- MultiExcerpt named 'BladeLogic' was not found
Before you begin
Download the required files, as described in Sizing tools.
To determine your reports data warehouse and archival data size requirements
Log on to the
- MultiExcerpt named 'BladeLogic' was not found
- MultiExcerpt named 'BladeLogic' was not found
- Run the the appropriate script for your database type:
Oracle:
sqlplus <user>/<password>@<TNS_ENTRY> @bds_dbsizing_for_new_bds_oracle.sql bds_dbsizing_for_new_bds_oracle.html
<user>
and<password>
are the- MultiExcerpt named 'BladeLogic' was not found
<TNS_ENTRY>
is the database TNS entry name.
Microsoft SQL Server:
sqlcmd -S <server>\<instance> -d <BMCServerAutomationDatabaseName> -U <user> -P <password> -i bds_dbsizing_for_new_bds_sqlserver.sql -o bds_dbsizing_for_new_bds_sqlserver.html -h-1
<server>
is the- MultiExcerpt named 'BladeLogic' was not found
<instance>
is the name of the database instance.<user>
and<password>
are the database user name and password.
The Oracle HTML output file provides the following information:
- Number of
- MultiExcerpt named 'BladeLogic' was not found
- 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
The SQL Server HTML output file provides the following information:
- 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
If you need to increase the database size, use the instructions provided by your database vendor.
Note
- This sizing process calculates the size requirements based on one
- MultiExcerpt named 'BladeLogic' was not found
Retention period indicates the period of time for which data is retained. Data that is older than the retention period is archived.
Related topics
Sizing for new product installations and new BMC Server Automation installations
Sizing for existing product installations and existing BMC Server Automation installations
Comments