Articles & Content


Query Oriented Approach to DB2 UDB Performance Tuning (C16)

Topic: DB2 for LUW

Subtopic: 2008

DATE: 2008-10-16 (11:45 - 12:45)
SPEAKERS: Farid Hosseini (Performadvance Inc)

There have been different techniques to manage the performance of a database, such as monitoring hit ratios, overflows, wait times, different snapshot outputs, rules of thumbs, etc. Though, the most effective way of looking at the performance of a database is to directly look at the performance of the submitted queries to the database and evaluate the database's performance on query basis. We will see the tools and techniques to go right to the queries and rank those based on their performance. Then we can analyze the most effective actions we can take to improve the performance of those queries and the overall database performance as a whole.

EXP. LEVEL: Advanced


Concept of Query oriented performance tuninng

Techniques to extract queries

Performance Expert usage to extract right set of queries

A couple of practical scenarios in Query oriented performance tuninng

Thinkgs to avoid/consider in Query oriented performance tuninng

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.