Tutorial Flow:
- Determining the problem category (completed)
- Performing detailed diagnosis of the problem
- Identifying the scope of the SQL statements involved
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
- No deadlocks
- High values of
LOCK_WAITS
and LOCK_WAIT_TIME
Conclusion
- The locking problem does not involve lock timeouts, deadlocks, or lock
escalations. This is purely a lock wait problem.
- The increased overall lock wait time
(LOCK_WAIT_TIME)
is due to many
statements waiting for a lock for a shorter period.