DB2 Buffer Pool Tuning
Top
Down or Bottom Up?
Thresholds
...
Obvious and Not so Obvious
Application Performance
Data
Online Monitor
Application Effects of Buffer Pool Tuning
Buffer Pool Performance
Analysis
Beyond the Basic Hit Ratio.....
Buffer Pool Tool Statistical Analysis
Buffer Pool Tool Statistical Analysis
Buffer Pool Tool Statistical Analysis
BPT Object Statistical Analysis
BPT Object Statistical Analysis
BPT Object Statistical Analysis
Predict Performance Gains
Using Larger Pool Sizes &
Moving Objects
Base Simulation.....Buffer Pool Level
Base Simulation.....Object Level
Base Simulation.....Object Level
Simulation - Large Random Object
Removing Sequential Object Prediction...
Cluster Analysis Groups the Objects
Client Case Study..... 1 Tune the Pools
Client Case Study..... 2 Too Many
Client Case Study..... 4 PeopleSoft
Other Client Case
Studies
(Buffer Pool Tool
Tuning Paybacks)
DASD Subsystem - Bottom Up Tuning
DASD Subsystem - Bottom
Up Tuning
I/O Performance Perspective.....
How Bad can the Performance be?
DASD Subsystem - Bottom Up Tuning