Articles & Content

Archives

Where my request spending time? --- First taste DB2 9.7 Time Spent metrics (C04)

Topic: 2010 NA

Subtopic: DB2 for LUW



DATE: 2010-5-11 (04:15 PM - 05:15 PM)
SPEAKERS: Pak Kwan (Fifth Third Bank)

Where is my database request spending time? It was a very difficult question for the pre db2 9.7. DBA does not have very good tools or methods to answer these questions. Thanks for new and improved DB2 9.7 monitoring features. Now, DB2 provides wait time monitor elements measure the time spend waiting for a particular entity or resource. In this presentation, Audiences will have first taste how sweet wait time monitor elements would be. Presenter will show audiences examples how to identify the performance bottlenecks.

EXP. LEVEL: Intermediate

OBJECTIVES:

Introduction a new database performance model: wait time analysis

Traditional Ratio based Analysis Vs Wait time analysis Audience can tell the different between these two methods. Pros and Cons

Overview Db2 9.7 Wait time Monitor Elements Audiences identify eight categories of wait time monitor elements.

Audiences can identify the IO is the bottleneck based on IO wait time data Audiences can identify the lock waiting is the bottleneck based on locking wait time data Demo is included.

Audiences are motivated to use wait time analysis as part of database performance and tuning technique as tool set.



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

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