How to view the current locks (Enterprise Manager)

How to view the current locks (Enterprise Manager)

To view the current locks

1. Expand a server group, and then expand a server.
   
   
2. Expand Management, and then expand Current Activity.
   
   
3. Do one of the following:
   • Expand Locks / Process ID to view the current locks for each connection.
     
     
   • Expand Locks / Object to view the current locks for each object.
4. In the console tree, click the connection (SPID) or object to view.

   The current locks for the connection or object are displayed in the details pane.

See Also

Displaying Locking Information

Monitoring with SQL Server Enterprise Manager

Monitoring with Transact-SQL Statements

Understanding Locking in SQL Server