How to view the current locks (Enterprise Manager)

To view the current locks

1. Expand a server group; then expand a server.
2. Expand Management; then expand Current Activity.
3. Expand:
   • Locks / Process ID to view the current locks for each connection.
   • Locks / Object to view the current locks for each object currently locked.
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