Share via


Server.EnumLocks Method

Include Protected Members
Include Inherited Members

Enumerates a list of current locks held on the instance of SQL Server.

This member is overloaded. For complete information about this member, including syntax, usage, and examples, click a name in the overload list.

Overload List

  Name Description
Public method EnumLocks() Enumerates a list of current locks held on the instance of SQL Server.
Public method EnumLocks(Int32) Enumerates a list of current locks held by the specified process on the instance of SQL Server.

Top

Remarks

Use this method to determine the locks that are currently held on the instance of SQL Server. The information that is returned can help you identify locking problems that might affect performance.