Articles & Content
Topic: 2008 EU
Subtopic: DB2 for LUW
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
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.