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.

See Also

XML for Analysis Schema Rowsets