ShowBlocks

Table of Contents



Shows blocks associated with a each process, optionally specifying a process id to filter on.


round-pushpin Shows blocks for all processes.
Exec ShowBlocks()

round-pushpin Shows blocks for the process id 1.
Exec ShowBlocks(1)




SQL :: ShowLocks
Shows all locks for all transactions.
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.