ShowLocks

Table of Contents



Shows all locks, what type of lock and the object which has been locked. Optionally specifying a process id to filter by.


round-pushpin Shows the locks for all processes.
Exec ShowLocks

round-pushpin Shows the locks for the process id 1.
Exec ShowLocks 1




SQL :: ShowHealthCounters
Shows the health counters that are tracked by the engine.
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 :: ShowWaitingLocks
Shows processes that are currently waiting on locks.
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.
SQL::ShowCachePages
Displays information about cached database pages.
SQL::ShowScalarFunctions
Displays the list of built-in scaler functions and their parameters.