ClearCacheAllocations

Table of Contents

Overview

Example

See also
Related

Clears the internal memory cache collection. This does not release memory to the operating system, but leaves the memory allocated to free cache slots to be used for further cache operations. If the memory needs to be immediately freed, then use ReleaseCacheAllocations.

Exec ClearCacheAllocations

The home page

SQL :: CheckpointHealthCounters

Writes the health counters to disk.

SQL :: ClearHealthCounters

Clears the health counters that are tracked by the engine.

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

SQL :: ReleaseCacheAllocations

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

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.