Monitoring SQL  «Prev 

sp_lock output

Click the following thumbnails to view the full-sized image.
1) spid 2) dbid 3) ObjId 4) IndId 5) Type 6) Resource 7) Mode 8) Status

  1. 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.
  2. The database ID of the object being locked.
  3. The object identifier of the table that is being locked.
  4. The index ID represents the index that is being locked.
  5. Type identifies the type of lock in request.
  6. The resource identifies the specific item that is being locked. For instance, for a page lock, it identifies the database page.
  7. Identifies the mode of the lock. A lock mode can be Shared, Update, Exclusive, Intent, Schema, or bulk update, or a combination of them.
  8. 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.