SQL-EM can monitor locks for either a process or for an object. To get to the Lock display, you must follow these steps while running SQL-EM:
Select the server group
Select the server
Select Current Activity
Select Lock/Process ID or Select Lock/Object
Select the process or object to view lock details
View locks by object
Click the SQL EM Lock by Process link below to see SQL-EM locks by object screen.
The same column headers will be seen in this display as you did when you viewed the locks by process screen.
In the screens you just viewed there are columns for lock mode and lock status. Mode – A lock mode can be…
…or a combination of these. Status – A lock’s status can be…
Grant: A granted lock
Wait: Locks that have been requested
CNVT – Locks that are being converted
When viewing locks with SQL-EM you can double-click the lock to see the SQL that caused the lock.
In SQL-EM there is no way to view detailed information on all of the current locks.
The next lesson covers how to monitor the overall performance of the SQL Server.