ShowVersion

Table of Contents



Shows the names and versions of all loaded assemblies.


round-pushpin Shows versions for loaded core assemblies.
exec ShowVersion()

round-pushpin Shows versions for all loaded assemblies.
Exec ShowVersion(true)





SQL :: ShowHealthCounters
Shows the health counters that are tracked by the engine.
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 :: 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.