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

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.

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

Displays information about cached database pages.

SQL::ShowScalarFunctions

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