ShowWaitingLocks

Table of Contents



Shows the processes that are currently blocked waiting for a lock, optionally for a single process.

ShowWaitingLocks(Numeric processId = null)

Permissions

Requires an account that is a member of an administrator role.


    • ProcessId - the process that is waiting.
    • Granularity - the kind of object it is waiting to lock.
    • Operation - the kind of lock: Read, Write, Delete, Stability.
    • Wait Time (ms) - how long it has been waiting.
    • Object Name - the object it is waiting to lock.


round-pushpin Shows all waiting locks.
EXEC ShowWaitingLocks

round-pushpin Shows the waiting locks of process 1.
EXEC ShowWaitingLocks(1)




SQL :: ReleaseCacheAllocations
Returns unused cache memory to the operating system. Call ClearCacheAllocations first to release as much memory as possible.
SQL :: ShowAggregateFunctions
Lists the built-in aggregate functions with their parameters and descriptions.
SQL :: ShowBlocks
Shows which process is blocking each blocked process, optionally for a single process.
SQL :: ShowBlockTree
Shows the tree of blocking processes, the processes they block and the resources being waited on. The tree is returned as a message.
SQL :: ShowHealthCounters
Shows the health counters tracked by the engine, such as cache hits and misses and lock wait time.
SQL :: ShowLocks
Shows every lock held by every transaction, optionally for a single process.
SQL :: ShowMemoryUtilization
Shows the operating system's view of the memory used by the database engine.
SQL :: ShowMySchemaPolicy
Shows the permissions that the logged in account has on a schema, and the role and schema each was inherited from.
SQL :: ShowProcesses
Shows every connected process (session) with its session id, process id, client name and transaction state, optionally for a single process.
SQL :: ShowScalarFunctions
Lists the built-in scalar functions with their parameters and descriptions.