“Deadlocks by Lock Type” reports the number of specific types of deadlocks. “% of total” gives the number of each deadlock type as a percentage of the total number of deadlocks.
Deadlocks may occur when many transactions execute at the same time in the same database. They become more common as the lock contention increases between the transactions.
This category reports data for these deadlock types:
Exclusive Table
Shared Table
Exclusive Intent
Shared Intent
Exclusive Page
Update Page
Shared Page
Exclusive Row
Update Row
Shared Row
Shared Next-Key
Exclusive Address
Shared Address
Others
“Total Deadlocks” summarizes the data for all lock types.
As in the example for this section, if there are no deadlocks, sp_sysmon does not display any detail information, it only prints the “Total Deadlocks” row with zero values.
To pinpoint where deadlocks occur, do one or both of:
Use sp_object_stats.
See Chapter 2, “Locking Configuration and Tuning,” in Performance and Tuning Series: Locking and Concurrency Control for more information.
Enable printing of detailed deadl,ock information to the log.
See Chapter 3, “Locking Reports” in Performance and Tuning Series: Locking and Concurrency Control for more information.
