Oct 29 / 2024 / 10:00 am - 11:30 am UTC-6
Kai Stroh will be a guest speaker at the ADUG meeting giving a talk about SQL workloads, how to build a lightweight monitor to identify workload tuning potential, and how SQL monitors like SQL Quality Control can help.
He’ll explain how to capture SQL statistics from Db2’s dynamic statement cache and combine them with data from the EXPLAIN tables.
The code will even be available for download after the show!
You’ll learn to identify which queries benefit most from tuning, saving time by focusing on high-impact queries. He’ll cover basic metrics like RID list errors and expand to more complex metrics, including top consumers, I/O statistics, and lock contention. He’ll go over SQL monitors and how to track SQL statement performance over time, enabling you to identify trends. Lastly, he’ll address detecting access path changes in dynamic SQL workloads, a common issue. Using historical EXPLAIN data to spot these changes and act quickly, especially after events like RUNSTATS executions, which can alter Db2’s access path choices.
We use cookies and other technologies on our website. Some of them are essential, while others help us to improve this website and your experience. If you are under 16 and wish to give consent to optional services, you must ask your legal guardians for permission. Personal data may be processed (e.g. IP addresses), for example for personalized ads and content or ad and content measurement. You can find more information about the use of your data in our privacy policy. You can revoke or adjust your selection at any time under Settings.