Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

DISCOVER_LOCKS Rowset

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

Community Additions

ADD
Show:
© 2015 Microsoft