ReleaseCacheAllocations

Table of Contents

Overview

Example

See also
Related

Releases unused memory from the internal memory cache back to the operating system. Call ClearCache before calling ReleaseCacheAllocations to maximize the memory that will be released.

Example

Exec ReleaseCacheAllocations

See also

Home

The home page

SQL :: CheckpointHealthCounters

Writes the health counters to disk.

SQL :: ClearCacheAllocations

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

SQL :: ClearHealthCounters

Clears the health counters that are tracked by the engine.

SQL :: Exec

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

SQL :: ShowBlocks

Shows blocks associated with a process.

SQL :: ShowBlockTree

Shows all blocked processesand their dependencies.

SQL :: ShowCacheAllocations

Shows the cache allocation details.

SQL :: ShowCachePartitions

Shows the memory allocations by memory cache partition.

SQL :: ShowHealthCounters

Shows the health counters that are tracked by the engine.