ShowWaitingLocks

Table of Contents



Shows all processes that are currently waiting on a lock an provides information about those locks.

  • Returns:
    • ProcessId - the process which is waiting.
    • Granularity - the granularity of the lock the process is waiting to acquire. File, directory, etc.
    • Operation - the operation of the lock the process is waiting to acquire. Read, write, delete, stability, etc.
    • ObjectName - the object that the process is waiting to acquire a lock on.


round-pushpin Shows waiting locks for all processes.
Exec ShowWaitingLocks

round-pushpin Shows waiting locks for a specific process.
for the process id 1.
Exec ShowWaitingLocks 1





SQL :: ShowCachePartitions
Shows the memory allocations by memory cache partition.
SQL :: ShowHealthCounters
Shows the health counters that are tracked by the engine.
SQL :: ShowLocks
Shows all locks for all transactions.
SQL :: ShowMemoryUtilization
Shows the operating system level memory utilization used by the database engine.
SQL :: ShowProcesses
Shows all active processes, their session ID, process ID and various transaction information.
SQL :: ShowTransactions
Shows all transactions that are current active.
SQL :: ShowVersion
Shows the names and versions of all loaded assemblies.
SQL :: Terminate
Terminates an existing process.
SQL::Keywords
A breakdown of all high-level statements available via the query handler.
SQL::ShowAggregateFunctions
Displays the list of built-in aggregation functions and their parameters.