DISCOVER_LOCKS Rowset
Provides information about the current standing locks on the server.
Rowset Columns
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 "Waiting to lock the object." 1 means "Lock Granted." |
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.
Restriction Columns
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. |
Remarks
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. |