The Locking tab on the Database Analysis drilldown gives you an overview of lock activity on the database. Scanning the graphs and statistics on this drilldown, you can quickly detect the following locking problems on the database:
High rates of lock holding or waiting
High numbers of deadlocks, escalations, or timeouts
Near-or full-capacity utilization of the lock list space.
If lock problems are evident, use the Client Applications drilldown to investigate the lock activity of individual applications to pinpoint those applications that are contributing to the locking issues.
Monitor the following graphs to detect abnormal lock activity on the database:
Average Lock Wait Time ( msec )
These lock activity counts provide more detail about any lock problems depicted in the graphs. For each activity type, you can view the count for the lifetime of the statistic (the number of occurrences since the database was activated or performance statistics were reset).
Additionally, the Statistics tab shows rates based on these counts. The names for these statistics begin with Lock.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
