ShowTransactions

Table of Contents

Shows all transactions that are current active. Optionally specifying a process id.

Shows active transaction for all processes.

Exec ShowTransactions

Shows active transactions for the process id 1.

Exec ShowTransactions 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.