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 Summarization and Pruning Agent
The Summarization and Pruning Agent provides the ability to customize the length of time for which to save data (pruning), and how often to aggregate detailed data (summarization) in the Tivoli Data Warehouse database. Configuration of the Summarization and Pruning Agent can have a significant impact on the performance of your Warehouse.
The Summarization and Pruning agent can be installed on the warehouse database server, or on a separate fast server with a low latency and high network bandwidth connection to the warehouse database server (100 Mbps or higher).
Table 1 shows guidance for setting up the Summarization and Pruning Agent based on the amount of data inserted into the warehouse database per day. The server sizing is based on the warehouse database and Summarization and Pruning Agent running on the same server, and the Warehouse Proxy Agent running on a separate server. The assumption is that you have new and fast server-class hardware because the warehouse database server is a high-performing server.For smaller environments, use a minimum of three dedicated disks because of the high disk I/O requirements of the warehouse database server.
Warehouse database server considerations
Data inserted per day Number of CPUs Memory Hard disk storage 0 to 500 K inserts per day 2 CPUs 2 GB 4 or more dedicated SCSI drives 0.5 to 2 Million inserts per day 2 CPUs 4 GB RAID Array with 4 or more disks 2 to 10 Million inserts per day 4 CPUs 4 GB Multiple RAID Arrays with 5 or more disks. Or, SAN storage 10 to 20 Million inserts per day 4 CPUs 8 GB RAID Arrays with 15 to 20 dedicated disk drives or high-performance SAN storage > 20 Million inserts per day 4 CPUs 8 - 16 GB Multiple RAID Arrays with 20 to 25 dedicated disks or high-performance SAN storage
If your Summarization and Pruning Agent is installed on the warehouse database server, configure the agent so that it leaves some processing power for others to perform Warehouse queries and for the Warehouse Proxy Agent to insert data. Set the number of worker threads to 2 to 4 times the number of CPUs on the system where the Summarization and Pruning Agent is running. Start with 2 times the number of CPUs and then increase the number to see if it continues to improve your performance.
To set the number of worker threads, edit the Summarization and Pruning Agent configuration file (KSYENV on Windows, sy.ini on UNIX or Linux) and set the KSY_MAX_WORKER_THREADS to the number of desired threads. This parameter can also be set using the configuration dialog panels.
To assess the performance and throughput of the Summarization and Pruning Agent for your environment you can use the Statistics workspace and the Work Completed workspace. These workspaces are described in the Warehouse Summarization and Pruning Agent User's Guide. See Tivoli Data Warehouse for tuning information.
Parent topic:
Sizing the Tivoli Monitoring hardware