Articles & Content

Archives

Exploiting Query Monitor - How to Build a Performance Warehouse? (J06)

Topic: DB2 for z/OS

Subtopic: 2007



DATE: 2007-5-8 (10:40 AM - 11:40 AM)
SPEAKERS: Thanikachalam 'Billy' Sundarrajan (Fifth Third Bank)

One of the significant challenges faced by most DBA teams is the ability to provide an effective data warehouse that will cater to the needs of the application programmers as well as the management team. The purpose of a performance data warehouse is usually multifold: from providing management with the ability to view things at a macro level, while providing the application team to drill down and track performance at a plan/package/SQL level.At Fifth Third, we used a combination of the Query Monitor data store, SMF101 data, and MXG processes to extract and store Plan, Package, and SQL level performance data.This presentation focusses on the challenges in designing an effective performance warehouse, and how we overcame the challenges.

EXP. LEVEL: Intermediate,Advanced

OBJECTIVES:

Performance data collection - Challenges

Designing Performance database - Plan, Package, SQL level tables - Summary and exception dataDesigning processes to extract useful performance data

Challenges in trending/accumulating performance data for static/dynamic SQL

Techniques for reducing performance monitoring overhead

Exception based monitoring - setting practical thresholds



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.