IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Installation Guide > Pre-deployment phase > Sizing the Tivoli Monitoring hardware
IBM Tivoli Monitoring, Version 6.3 Fix Pack 2
Locating and sizing the Warehouse Proxy Agent
The Warehouse Proxy Agent is driven by the amount of historical data being collected. The Warehouse load projection spreadsheet can help you estimate both the number of database inserts and the volume of data being collected in the warehouse database.
You can find the Warehouse load projection spreadsheet in the Tivoli Integrated Service Management Library by searching for "warehouse load projections" or the navigation code "1TW10TM1Y" at IBM Integrated Service Management Library.
Figure 1. Warehouse load projection spreadsheet
Figure 1 shows a sample spreadsheet summary created using the tool downloaded from the Tivoli Integrated Service Management Library site. The amount of network traffic closely matches the amount of data collected in the Warehouse. The key planning numbers, highlighted in red, are based on sample data.Each Tivoli Monitoring environment is different, so fill out the spreadsheet based on your warehousing needs. The key information in the spreadsheet includes the following data:
- Total Tivoli Data Warehouse record inserts per hour
In this example, there are 139,288 inserts per hour. Most reasonable database servers can handle this rate without any problem.
- Total megabytes of detailed data inserted per hour
In the example, 81.6 MB of data per hour are inserted. This amount roughly translates to 81.6 MB of network traffic per hour coming into the Warehouse Proxy Agent from the connected agents, and roughly 81.6 MB per hour of network traffic from the Warehouse Proxy Agent to the warehouse database server.
- Total gigabytes of data in Tivoli Data Warehouse (based on retention settings)
In this example, you expect the Tivoli Data Warehouse database to grow to 49.4 GB of data. Additional space must be allocated for the database logs. The database does not grow beyond 49.4 GB because you are summarizing the raw (detailed) metrics and pruning both the detailed and summarized data. The planning spreadsheet helps you determine your warehouse size based on your retention needs.
Multiple Warehouse Proxy Agents are required when the number of agents collecting historical data increases above approximately 3000 (to ensure that limits for the number of concurrent connections are not reached). If you use multiple Warehouse Proxy Agents, consider running them on the same servers running the remote monitoring servers, and configuring them to support agents connected to this monitoring server. This approach consolidates the Tivoli Monitoring infrastructure components, and limits the number of agents that connect to each Warehouse Proxy Agent.
For a single Warehouse Proxy agent supporting up to 3000 agents, a dual-processor system with 2 GB RAM should be sufficient. For running multiple Warehouse Proxy agents, they are typically located on the remote monitoring servers.
Parent topic:
Sizing the Tivoli Monitoring hardware