DISCOVER_LOCKS
Provides information about the current standing locks on the server.
The DISCOVER_LOCKS rowset contains the following columns.
Column name | Type indicator | Length | Description |
|---|---|---|---|
LOCK_CREATION_TIME | DBTYPE_DBTIMESTAMP |
| The UTC server time at the moment lock was requested. |
LOCK_GRANT_TIME | DBTYPE_DBTIMESTAMP |
| The UTC server time at the moment lock was granted on the resource. |
LOCK_ID | DBTYPE_GUID |
| The unique identifier of the lock, as a GUID. |
LOCK_OBJECT_ID | DBTYPE_WSTR |
| The unique identifier of object being locked. |
LOCK_STATUS | DBTYPE_I4 |
| The lock status. 0 means "Lock Granted." 1 means "Waiting to lock the object." |
LOCK_TRANSACTION_ID | DBTYPE_GUID |
| The unique identifier of the transaction, as a GUID. |
LOCK_TYPE | DBTYPE_I4 |
| A bit mask of Lock Types; for more information, see the Remarks section of this topic. |
SPID | DBTYPE_I4 |
| The session ID. |
This schema rowset is not sorted.
The DISCOVER_LOCKS rowset can be restricted on the columns listed in the following table.
Column name | Type indicator | Restriction State |
|---|---|---|
SPID | DBTYPE_I4 | Optional. |
LOCK_TRANSACTION_ID | DBTYPE_GUID | Optional. |
LOCK_OBJECT_ID | DBTYPE_WSTR | Optional. |
LOCK_STATUS | DBTYPE_I4 | Optional. |
LOCK_TYPE | DBTYPE_I4 | Optional. |
LOCK_MIN_TOTAL_MS | DBTYPE_I8 | Optional. |
Lock Types
Lock Name | Value | Description |
|---|---|---|
LOCK_NONE | 0x0000000 | No lock. |
LOCK_SESSION_LOCK | 0x0000001 | Inactive session; does not interfere with other locks. |
LOCK_READ | 0x0000002 | Read lock during processing. |
LOCK_WRITE | 0x0000004 | Write lock during processing. |
LOCK_COMMIT_READ | 0x0000008 | Commit lock, shared. |
LOCK_COMMIT_WRITE | 0x0000010 | Commit lock, exclusive. |
LOCK_COMMIT_ABORTABLE | 0x0000020 | Abort at commit progress. |
LOCK_COMMIT_INPROGRESS | 0x0000040 | Commit in progress. |
LOCK_INVALID | 0x0000080 | Invalid lock. |
