September 2010
Intermediate to advanced
1704 pages
111h 8m
English
Another method of monitoring locking in SQL Server is through the Performance Monitor. The sys.dm_tran_locks view and SSMS Activity Monitor provide a snapshot of the actual locks currently in effect in SQL Server. If you want to monitor the locking activity as a whole on a continuous basis, you can use the Windows Performance Monitor and monitor the counters available for the SQLServer:Locks performance object (see Figure 37.4).
Figure 37.4 Choosing counters for the SQLServer:Locks performance object in Performance Monitor.

If you are monitoring a SQL Server 2008 named instance rather than a default ...