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