IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Installation Guide > Tivoli Data Warehouse solutions > Plan considerations for the Tivoli Data Warehouse > Estimate the required size of your database
IBM Tivoli Monitoring, Version 6.3 Fix Pack 2
Step 5: Determine the estimated size of your database
First, determine the total space required for each attribute group. Add the amount of detailed data and the amount of aggregate data for the attribute group.
Use the following equation:
(detailed data size) + (aggregate data size)
Second, determine the total space required for all attribute groups for the agent. Add the total space for each attribute group that you want to collect. Use the following equation:
aggGroup1 + aggGroup2 + aggGroup3 ...
Third, determine the total space required for all agents. Add the total space for each agent. Use the following equation:
agent1 + agent2 + agent3 ...
Finally, to estimate the total disk space requirement for the database, multiplying the total amount of data (detailed + aggregate for all attribute groups) by 1.5 (to increase the number by 50%). Compare this number to the Database data row in Table 1 to determine the number of disks you need for your database.
Use the following worksheet to estimate the size of your data warehouse database.
Tivoli Data Warehouse database size estimation worksheet
Attribute group Number of agents Data from the User's Guide Collection interval Detailed records per day* Attribute agent disk space (KB)* Days of detailed data kept Warehouse space– detailed (MB)* Aggregate records Warehouse space– aggregated (MB)* Total warehouse space for attribute group (MB) Record size– detailed Record size– aggregated Interval instances Total warehouse data size (sum of all attribute group total warehouse space) Total database size (total warehouse data size * 1.5) * Use the equations in Estimate the required size of your database to obtain these values.
Parent topic:
Estimate the required size of your database