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.


round-pushpin Shows process information for all processes.
Exec ShowProcesses

round-pushpin Shows process information for the process id 1.
Exec ShowProcesses 1




SQL::ShowCachePages
Displays information about cached database pages.
SQL::ShowScalarFunctions
Displays the list of built-in scaler functions and their parameters.
SQL::ShowSystemFunctions
Displays the list of built-in system functions and their parameters.
SQL::System Procedures
Built in procedures that allow you to evaluate various aspect of the database engine.