In that blog (did you read it yet? ), I suggested that development and test machines should be some old, underpowered, pieces of junk. I also warned against hiding performance defects behind large DB2 bufferpools.
DBI is presently undertaking QA measures for our upcoming releases of our best in class DB2 LUW Performance Tools. For my own testing efforts, I am using a junk laptop that is 6 years old - the LCD monitor doesn't even work! It has only 2GB memory and a dual core CPU that operates at a snail's pace by today's standards. Suffice it to say, I've found some queries that need some tuning! When you can get great performance from old junk hardware, then you are probably ready for production!
More remarkably, there are some queries in the workload that take about 6 seconds to complete with a 128MB bufferpool. But, when the bufferpool is increased to 256MB, the entire 203MB table fits in memory and the same queries complete in 1/4 second!!!
With the 256MB bufferpool, I get 100% Bufferpool Hit ratio. Yippee. At the same time, XP Task Manager shows that the dual core CPU is on fire at 100% busy! Folks, please don't fall prey to BUFFERPOOL FOLLY!
GET SMART ABOUT TUNING DB2 LUW
- The DB2 Symposium in Dallas, TX, USA 21-23 March 2011 brings together top name speakers teaching full day seminars on DB2 z/OS and LUW. I am teaching a two day class wherein you will learn everything you need to know to make your DB2 LUW databases perform extremely well. I hope to see you in class! Early bird registration discounts expire 18 February 2011 - HURRY!
- Have you seen DBI's new ad yet in IBM Data Management Magazine? CHECK IT OUT and find instructions on how you can obtain my new white paper "IBM DB2 LUW Critical Performance Measurements"
- And, of course, make sure you are watching recorded replays of The DB2Night Show™ edutainment webinar series!
Finally, Happy Valentines Day to all DB2 lovers out there!
Our #2 Job is giving you the documentation to prove it!