The Locks grid shows information about all locks currently held or requested.
Edit me

About the grid

To view session details, right-click an entry in the grid and select View Session Details.

The Locks grid is not refreshed automatically. To refresh the Locks grid, click Refresh Data.

To close a SQL Server session, right-click and select Kill this session. This will terminate the entire connection (SPID), not just the lock you selected. This option is available only to members of the Spotlight Diagnostic Administrators group.

For performance reasons, Spotlight limits the number of records that can be viewed in this grid. By default, only 1000 locks will be displayed. If there are more locks than this, then no information will be displayed.

The available columns are:


The server process ID of the current user process.


The database being used by the current process.


The number of locks of the type specified in the Lock Type column against the database specified in the Database column from the SPID specified in the SPID column.

Index Name

The index being used by the current process (if any).

Object Name

The object that is currently locked.

Lock Type

The type of the resource that is currently locked (Database, Table, Page, Row, Extent, etc.).


The kind of lock being applied to the resource (Shared, Exclusive, Update, IntentShared, IntenExclusive, etc.).


The status of the lock (Blocked, Blocking, or blank (Granted)).

Filter the results

To view or change the filter for this grid, click the Change Filter Settings link in the upper right corner of the drilldown.

You can also view or change this setting by right-clicking the grid and choosing View/Edit Filter.

Selecting any of the Locks filtering options means that the selected locks are included in the grid, along with other types of locks. It does not mean that only the selected locks are shown in the Locks grid.