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





Home
The home page
SQL :: Cancel
Cancels transaction associated with a given process.
SQL :: CheckpointHealthCounters
Writes the health counters to disk.
SQL :: ClearCacheAllocations
Clears the internal memory cache collection. This does not release the memory, but leaves it allocated for further cache operations.
SQL :: ClearHealthCounters
Clears the health counters that are tracked by the engine.
SQL :: Exec
Exec is used to execute a stored procedure (system or user created).
SQL :: ReleaseCacheAllocations
Releases unused memory from the internal memory cache back to the operating system.
SQL :: ShowBlocks
Shows blocks associated with a process.
SQL :: ShowBlockTree
Shows all blocked processesand their dependencies.
SQL :: ShowCacheAllocations
Shows the cache allocation details.