ShowMemoryUtilization

Table of Contents

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

Metrics reported:

Exec ShowMemoryUtilization

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 blocks associated with a process.

Shows all blocked processesand their dependencies.

Shows the cache allocation details.

Shows the memory allocations by memory cache partition.