Benefits of using Buffer Pool Analyzer
Buffer Pool Analyzer offers performance analysts and database administrators tuning advice that is based on the analysis of DB2® trace data.
The benefits from analyzing buffer pool performance with Buffer Pool Analyzer
are:
- Easy monitoring of the performance of buffer pools and group buffer pools to detect bottlenecks, trends, and unused resources
- Fast adaptation of buffer pool parameters to changing DB2 usage conditions
- Optimized use of buffer pools by aligning buffer pool size and object placement to available resources
- Non-disruptive simulation of buffer pool behavior to test the impact of changes before they are applied
- Long-term analysis of factual performance for improved prediction of future performance and resource needs