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