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

The home page

Cancels transaction associated with a given process.

Writes the health counters to disk.

Clears the internal memory cache collection. This does not release the memory, but leaves it allocated for further cache operations.

Clears the health counters that are tracked by the engine.

Exec is used to execute a stored procedure (system or user created).

Releases unused memory from the internal memory cache back to the operating system.

Shows blocks associated with a process.

Shows all blocked processesand their dependencies.

Shows the cache allocation details.