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