DB2 Buffer Pool Tuning and Sizing - The Yellow Brick Road to Performance
Joel Goldstein
(732) 972-1261

• DB2 Buffer Pool Tuning and Sizing - The Yellow Brick Road to Performance
• The Past.....
• The Present.....
• The Present.....
• Large VP vs VP/HP Configuration
• Performance Impacts
• Some Limits We Must Remember.....
• HiperPools.....
• Using the Adjustable Thresholds
• Buffer Pool Hit Ratio
• Additional Hit Ratios to Track.....
• BufferPool Hit Ratio - VP & HP
• System BufferPool Data.....1
• System BufferPool Data.....2
• Application BufferPool Data
• I/O Performance Relationships.....
• Application Effects of BufferPool Tuning
• MVS Paging vs VP Buffers
• Response Time vs MVS Paging vs VP Buffers
• MVS Paging vs HP Buffers
• Response Time vs HP Buffers
• BufferPool Performance Analysis Beyond the Basic Hit Ratio.....
• BufferPool Performance Analysis Beyond the Basic Hit Ratio.....
• BufferPool Performance Analysis Beyond the Basic Hit Ratio.....
• BufferPool Performance Analysis Beyond the Basic Hit Ratio.....
• BufferPool Performance Analysis Beyond the Basic Hit Ratio.....
• BufferPool Performance Analysis Beyond the Basic Hit Ratio.....
• BufferPool Statistical Analysis
• BufferPool Statistical Analysis
• BufferPool Statistical Analysis
• Object Statistical Analysis
• Object Statistical Analysis
• Object Statistical Analysis
• Analyze the Statistical Data
• Simulate Performance Gains with Larger Pool Sizes
• Base Simulation.....BufferPool Level
• Base Simulation.....Object Level
• Base Simulation.....Object Level
• Additional Data Analysis...
• Client Case Study.....1
• Client Case Study.....Tune the Pools The Standard Shotgun Approach
• Client Case Study.....Tune the Pools
• Client Case Study.....Tune the Pools
• System Results of BufferPool Tuning
• Client Case Study.....2
• Client Case Study.....2
• Client Case Study.....2
• Client Case Study.....3
• Client Case Study.....3
• Yearly I/O Reduction Cost Saving
• Yearly Productivity Cost SavingsReducing Avg. Transaction Elapsed .1 Secs
• Pool Usage Suggestions
• Pool Usage Suggestions
• Summary.....
• The Future.....
• PP Presentation

  eMail Us with Your Questions or Comments 
 © Responsive Systems Company 1997-2008  All Rights Reserved.
281 Highway 79, Morganville, NJ 07751 USA
(732) 972-1261, (800) DB2-EXPErt, (732) 972-9416 FAX
Last modified: March 08, 2008 by Dr Bernie Domanski