Server.EnumLocks Server.EnumLocks Server.EnumLocks Method

Definition

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

Overloads

EnumLocks() EnumLocks() EnumLocks()

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

EnumLocks(Int32) EnumLocks(Int32) EnumLocks(Int32)

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

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.

EnumLocks() EnumLocks() EnumLocks()

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

public:
 System::Data::DataTable ^ EnumLocks();
public System.Data.DataTable EnumLocks ();
Public Function EnumLocks () As DataTable
Returns

A DataTable system object value that contains a list of current locks held by the specified process on the instance of SQL Server. The table describes the different columns of the returned DataTable.

Column
Data type
Description
RequestorSpid
Int32 The SQL Server process ID that uniquely identifies the process requesting the lock.
LockType
String The type of lock. See req_mode in sys.syslockinfo (Transact-SQL).
Database
String The name of the database that contains the lock.
Schema
String The schema of the locked resource.
Table
String The table that contains the lock.
Index
String The index that contains the lock.
Status
Int32 The status of the lock. 1 for Grant, 2 for Convert, and 3 for Wait.

Examples

C#

Server srv = new Server("(local)");  

DataTable d = srv.EnumLocks();  
foreach (DataRow r in d.Rows)  
{  
   Console.WriteLine("============================================");  
   foreach(DataColumn c in d.Columns)  
   {  
      Console.WriteLine(c.ColumnName + " = " + r[c].ToString());  
   }  
}  

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")  

$d = $srv.EnumLocks()  
foreach ($r in $d.Rows)  
{  
   Write-Host "============================================"  
   Foreach ($c in $d.Columns)  
   {  
      Write-Host $c.ColumnName "=" $r[$c]  
   }  
}  

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.

EnumLocks(Int32) EnumLocks(Int32) EnumLocks(Int32)

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

public:
 System::Data::DataTable ^ EnumLocks(int processId);
public System.Data.DataTable EnumLocks (int processId);
Public Function EnumLocks (processId As Integer) As DataTable
Parameters
processId
Int32 Int32 Int32

An Int32 value that specifies the system ID value that uniquely identifies the process.

Returns

A DataTable system object value that contains a list of current locks held by the specified process on the instance of SQL Server. The table describes the different columns of the returned DataTable.

Column
Data type
Description
RequestorSpid
Int32 The SQL Server process ID that uniquely identifies the process requesting the lock.
LockType
String The type of lock. See req_mode in sys.syslockinfo (Transact-SQL).
Database
String The name of the database that contains the lock.
Schema
String The schema of the locked resource.
Table
String The table that contains the lock.
Index
String The index that contains the lock.
Status
Int32 The status of the lock. 1 for Grant, 2 for Convert, and 3 for Wait.

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.

Applies to