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::ShowCachePages
Displays information about cached database pages.
SQL::ShowScalarFunctions
Displays the list of built-in scaler functions and their parameters.
SQL::ShowSystemFunctions
Displays the list of built-in system functions and their parameters.
SQL::System Procedures
Built in procedures that allow you to evaluate various aspect of the database engine.