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