Click the following thumbnails to view the full-sized image.
- The system process ID of the connection locking the resource. You can compare this with the ID from sp_who to find out the login name.
- The database ID of the object being locked.
- The object identifier of the table that is being locked.
- The index ID represents the index that is being locked.
- Type identifies the type of lock in request.
- The resource identifies the specific item that is being locked. For instance, for a page lock, it identifies the database page.
- Identifies the mode of the lock. A lock mode can be Shared, Update, Exclusive, Intent, Schema, or bulk update, or a combination of them.
- The status column represents the lock status. It can be GRANT for granted locked, WAIT for locks that have been requested, or CNVT for locks that are being converted.