ShowCachePages

Table of Contents



Much like ShowCacheAllocations, but ShowCachePages only displays information about cached database pages. Notably, this procedure also shows the count of documents in each page.


Exec ShowCachePages




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 :: ShowCacheAllocations
Shows the cache allocation details.
SQL :: ShowCachePartitions
Shows the memory allocations by memory cache partition.