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 Management
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.
SQL EM Lock by Process
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…
Shared
Update
Exclusive
Intent
Schema
Bulk update
…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.