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.