Show all locks held or requested by the selected session.
Edit me

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, IntentExclusive, etc.)

Status

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

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

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

Object Name

The object that is currently locked.