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

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 end 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:

SPID

The server process ID of the current user process.

Database

The database being used by the current process.

Count

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.).

Mode

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

Status

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.