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