Server.EnumLocks Method

 

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

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

NameDescription
System_CAPS_pubmethodEnumLocks()

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

System_CAPS_pubmethodEnumLocks(Int32)

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

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.

Return to top
Show: