ShowCachePages

Table of Contents

Overview

Example

See also
Related

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

Example

Exec ShowCachePages

See also

SQL :: ShowHealthCounters

Shows the health counters that are tracked by the engine.

SQL :: ShowLocks

Shows all locks for all transactions.

SQL :: ShowMemoryUtilization

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

SQL :: ShowProcesses

Shows all active processes, their session ID, process ID and various transaction information.

SQL :: ShowTransactions

Shows all transactions that are current active.

SQL :: ShowVersion

Shows the names and versions of all loaded assemblies.

SQL :: ShowWaitingLocks

Shows processes that are currently waiting on locks.

SQL::Keywords

A breakdown of all high-level statements available via the query handler.

SQL::ShowAggregateFunctions

Displays the list of built-in aggregation functions and their parameters.

SQL::ShowScalarFunctions

Displays the list of built-in scaler functions and their parameters.