Chapter 2: Monitoring Performance with sp_sysmon
Lock Management
“Lock Management” reports locks, deadlocks, lock promotions, and lock contention.
