“Lock Summary” provides overview statistics about lock activity that took place during the sample interval.
“Total Lock Requests” reports the total number of lock requests.
“Avg Lock Contention” reports the average number of times there was lock contention as a percentage of the total number of lock requests.
If the value is insufficient in determining how severe the lock contention is. To determine the severity of the lock contention, query the monSysWaits, monProcessWaits, and monLocks monitoring tables, or use sp_object_stats. For more information, see Performance and Tuning Series: Monitoring Tables. See the Adaptive Server Reference Manual: Procedures for more information about sp_object_stats. See Performance and Tuning Series: Locking and Concurrency Control for more information on tuning locking behavior.
“Deadlock Percentage” reports the percentage of deadlocks as a percentage of the total number lock requests. If this value is high, see “Deadlocks by Lock Type”.
