Posted on 4/30/2010
In our 17th show, Berni Schiefer, IBM DE, Toronto Lab, shared with us the latest news on DB2 LUW Performance achievements and some best practices. DB2 is still winning TPC benchmarks! Berni's talk is peppered with assorted hints, tips, and best practices. What are his favorite DB2 9.7 features? Watch and learn...
To download a recorded replay of Episode #17, right click on the link below and choose "Save As... "
Episode 17, 2010 Apr 30, DB2 LUW Performance Updates and Tips with special guest Berni Schiefer, Distinguished Engineer, IBM TorontoJoin The DB2Night Show™ LinkedIn GroupThe DB2Night Show™ now has a LinkedIn Group. The group is an open group. Join to receive LinkedIn group updates including future shows and replay information, and, if you like, start some discussions about the show! Join The DB2Night Show LinkedIn Group!Our Shameless Marketing MomentHow can you verify that a change you made improved performance? How can you build trust with the Self Tuning Memory Manager?In this episode, DBI demonstrated performance trend charts that automatically track and plot changes on trend graphs. Automatically is worth repeating. Tracked changes include before and after values for changes to: - DBM CFG
- DB CFG
- Registry Variables
- Bufferpools (Create, Drop, Alter Sizes)
- Index Changes (Create, Drop, and Changes)
- STMM Changes
With DBI's trend charts, you can:- SEE the IMPACT of Changes
- CPU utilization
- System Memory and Paging
- Response Times
- SLA Attainments
- Transaction Costs
- Throughput Rates
- ... and many more
- Grow trust with STMM and visually monitor its effects on your database
- Make Changes with Confidence
- Discover Changes that other team members may have made - inside or outside of change control procedures
DBI's comprehensive performance and configuration repository with the industry's best trend graphs enable you to monitor and manage your databases with confidence, improve stability, and achieve scalability with existing hardware. Hint: Use our performance trend charts on your next performance review to earn high praise from management. :icon_wink: Contact DBI and find out how our DB2 LUW Performance Solutions can truly help you optimize performance and lower IT costs. |