Advanced Performance Diagnostics for SQL

Download PDF

Session title: Advanced Performance Diagnostics for SQL

Session abstract: Db2 provides a number of important features for diagnosing and solving your SQL problems. Through a series of practical examples, this session will introduce you to the latest Db2 capabilities available for SQL diagnostics and show you how you can leverage them to solve query problems in your own environment.You will learn how to identify your most expensive SQL statements using the package cache table functions, and how to use DB2’s “time spent” metrics to analyze where your problem queries are spending their time. You will also learn how to use the latest sort memory metrics to analyze query memory consumption in order to tune your analytic workloads. Finally you will learn how to use the runtime explain capabilities in conjunction with the activity event monitor to capture actual plan cardinalities as well per object metrics for individual plans.

Speaker biography: David Kalmuk is a Senior Technical Staff Member & Master Inventor currently responsible for the MPP scale-out, Workload Management, and Monitoring areas of the Db2 family products. David has contributed to the development of numerous technologies in Db2 over the years including BLU Acceleration, Workload Management, Monitoring, as well as much of Db2’s Processing and Communications architecture. He is currently leading development efforts focused on Db2’s Hybrid Warehousing Architecture. David has been a member of the Database team at IBM since 2000.