ShowBlocks

Table of Contents

Shows blocks associated with a each process, optionally specifying a process id to filter on.

Shows blocks for all processes.

Exec ShowBlocks()

Shows blocks for the process id 1.

Exec ShowBlocks(1)

The home page

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 all blocked processesand their dependencies.

Shows the cache allocation details.

Shows the memory allocations by memory cache partition.

Shows the health counters that are tracked by the engine.