Monitoring SQL  «Prev  Next»

Lesson 5 Monitoring locks with SQL-EM
Objective Use SQL-EM to monitor locks.

SQL EM Monitor Locks

Using SQL-EM to monitor locks

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:
  1. Select the server group
  2. Select the server
  3. Select Management
  4. Select Current Activity
  5. Select Lock/Process ID or Select Lock/Object
  6. 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…
  1. Shared
  2. Update
  3. Exclusive
  4. Intent
  5. Schema
  6. Bulk update

…or a combination of these.
Status – A lock’s status can be…
  1. Grant: A granted lock
  2. Wait: Locks that have been requested
  3. 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.