Tutorial Flow:



Determining the problem category


As part of the initial diagnosis, the database administrator looks for familiar patterns of symptoms to categorize the problem at a high level. This example uses the MONREPORT.DBSUMMARY report. The Summary report contains in-depth monitor data for the entire database, as well as key performance indicators for each connection, workload, service class, and database member. This report is implemented as a stored procedure in MONREPORT module. The MONREPORT module provides a set of procedures for retrieving variety of monitoring data and generating text reports.


Monitoring report used



Report highlights

Pay attention to "Part 1 - System performance"

Results



Conclusion



Identified problem

High lock wait time and high total wait time indicates problems with the locks.