ShowCacheAllocations

Table of Contents

Overview

Example

See also
Related

Shows the cache allocation details. This system procedure will show each file in the cache, how long its been there, how many times its been read/written and how large it is.

Example

Exec ShowCacheAllocations

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 :: 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 :: ShowCachePartitions

Shows the memory allocations by memory cache partition.

SQL :: ShowHealthCounters

Shows the health counters that are tracked by the engine.