The DB2Night Show Episode #262: Build a Lightweight Monitor to Identify SQL

Presented by: Kai Stroh Database Engineer, UBS Hainer Software "The DB2Night Show Episode #262: Build a Lightweight Monitor to Identify SQL Workload Tuning Potential" Replays available in WMV and MP4 formats! 100% of our studio audience learned something!This was a powerful session. The focus on capturing and analyzing SQL stats with EXPLAIN data made it easier to pinpoint high-impact tuning opportunities. Tracking metrics over time for trends, plus detecting access path changes, provided valuable insights into performance bottlenecks, especially in dynamic environments. Watch the replay...

Show Hosts: Mohan and Martin's Commentary

Session Overview: Capture SQL statistics from Db2’s dynamic statement cache and combine these statistics with EXPLAIN table information for deeper insights. By the end, you'll be able to identify the most impactful queries to tune, allowing you to focus on high-value areas. Key Metrics: Started with fundamental metrics like RID list errors, then move to advanced metrics such as top consumers, I/O statistics, lock contention, and more. You’ll learn to track the performance of individual SQL statements over time to help reveal performance trends. Dynamic SQL Workload Monitoring: Addressed access path changes—a frequent challenge in environments with high dynamic workloads. For example, a single RUNSTATS execution can lead to unexpected access path changes. By utilizing historic EXPLAIN data, you’ll be able to quickly spot and address these changes. The code is available for download from the link provided at the end of the session. Search #DB2Night to learn more.

Are you following The DB2Night Show on Twitter?

Get the Download Replays

To download a recorded replay of Episode 262 in WMV format:"
Episode 262 25 October 2024 Build a Lightweight Monitor to Identify SQL Workload Tuning Potential

Have an iLife, iDevice, iPod, iPad, or iPhone? Download the MP4 format!

Kai graciously made the PDF of Episode 262 available at this link:
Handout (PDF)

Follow the Db2Night Show channel on Youtube!!

Did you learn something from this show?

Share a great show with your friends and followers:
Tweet