Cross Platform DB2 for z/OS & LUW

E16 - Before You Tune your SQL Performance You Need to Find Real Good Tuning Opportunities 

Oct 10, 2016 09:37 AM

Identifying SQL Queries that waste your CPU may not be as simple as it seems. Just to rely on observations or SMF reports tend to show only long running SQL statements, while many “fast” queries get lost in the hay stack. This is even more difficult with a Workload of Billions of SQL statement per day within a highly heterogeneous environment. Modern Java Applications are capable of generating thousands of varying SQL Statements, a strategy is needed to find tuning opportunities. The session speaker tells about his own experiences in finding the best strategy and tools to support this approach.

Attachment(s)
pptx file
RB_Presentation_Wide_V27.pptx   10.23 MB   1 version
Uploaded - Jun 05, 2020

Related Entries and Links

No Related Resource entered.