ShowVersion

Table of Contents

Shows the names and versions of the engine's assemblies, or of every loaded assembly when showAll is true.

ShowVersion(Boolean showAll = false)

Assembly and Version.

Shows the core assemblies.

EXEC ShowVersion

Shows every loaded assembly.

EXEC ShowVersion(true)

Returns unused cache memory to the operating system. Call ClearCacheAllocations first to release as much memory as possible.

Lists the built-in aggregate functions with their parameters and descriptions.

Shows which process is blocking each blocked process, optionally for a single process.

Shows the tree of blocking processes, the processes they block and the resources being waited on. The tree is returned as a message.

Shows the health counters tracked by the engine, such as cache hits and misses and lock wait time.

Shows every lock held by every transaction, optionally for a single process.

Shows the operating system's view of the memory used by the database engine.

Shows the permissions that the logged in account has on a schema, and the role and schema each was inherited from.

Shows every connected process (session) with its session id, process id, client name and transaction state, optionally for a single process.

Lists the built-in scalar functions with their parameters and descriptions.