Export (0) Print
Expand All

DISCOVER_LOCKS Rowset

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 "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.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft