View Printable Version

D01 - Advanced Performance Diagnostics for SQL

Session Number: 5083
Track: Db2 for LUW - II
Session Type: Podium Presentation
Primary Presenter: David Kalmuk [IBM Canada]
Time: Apr 30, 2018 (12:45 PM - 01:45 PM)
Room: Commonwealth D

Session Code: D01
Speaker Bio: David Kalmuk is a Senior Technical Staff Member currently leading the MPP scale-out, Workload Management, and Monitoring areas of the Db2 Warehouse product. 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 new development efforts related to Db2 Warehouse on Cloud. David has been a member of the Database team at IBM since 2000.
Audience experience level: Beginner, Intermediate, Advanced
Presentation Category: Data Management, Data Warehousing and Business Intelligence, Managing Database Resources, Managing Performance
Presentation Platform: DB2 for Linux, UNIX, Windows
Audiences this presentation will apply to: Database Administrators, New Users
Technical areas this presentation will apply to: Data Warehousing and Business Intelligence, Database Performance (DB2 for LUW), pureScale, SQL and XML Performance
Objective 1: Learn how to pinpoint your most expensive SQL statements using the package cache SQL function.
Objective 2: Learn how to analyze where a problem query is spending its time using DB2's time spent metrics.
Objective 3: Learn how to monitor query sort memory usage and spilling.
Objective 4: Learn how to use the runtime explain capabilities and activity event monitor to capture both the actual cardinalities and the new object metrics for a problem query.
Objective 5: Take away practical examples you can use in your own environment.

Abstract:  The IBM Db2 family of products including Db2, Db2 Warehouse, and BigSQL provide 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 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 query plan cardinalities as well the per object metrics.

For questions or concerns about your event registration, please contact support@idug.org