Tutorial Flow:





Performing detailed diagnosis of the problem


The database administrator determines that the problem is related to locking. He identifies the type of locking problem by revisiting the MONREPORT.DBSUMMARY report. This report contains further information related to locking.


Monitoring report used



Report highlights

Pay attention to check common request metrics and focus on lock metrics.

Results



Conclusion