ShowProcesses

Table of Contents

Shows all active processes, their session ID, process ID and various transaction information. Optionally specifying a process id to filter on.

Shows process information for all processes.

Exec ShowProcesses

Shows process information for the process id 1.

Exec ShowProcesses 1

Shows the memory allocations by memory cache partition.

Shows the health counters that are tracked by the engine.

Shows all locks for all transactions.

Shows the operating system level memory utilization used by the database engine.

Shows all transactions that are current active.

Shows the names and versions of all loaded assemblies.

Shows processes that are currently waiting on locks.

Terminates an existing process.

A breakdown of all high-level statements available via the query handler.

Displays the list of built-in aggregation functions and their parameters.