ClearCacheAllocations

Table of Contents



Empties the engine's memory cache. The memory is kept allocated for future cache use; call ReleaseCacheAllocations afterwards to return it to the operating system.

ClearCacheAllocations()

Permissions

Requires an account that is a member of an administrator role.


round-pushpin Empties the cache.
EXEC ClearCacheAllocations




SQL :: ShowAggregateFunctions
Lists the built-in aggregate functions with their parameters and descriptions.
SQL :: ShowBlocks
Shows which process is blocking each blocked process, optionally for a single process.
SQL :: ShowBlockTree
Shows the tree of blocking processes, the processes they block and the resources being waited on. The tree is returned as a message.
SQL :: ShowCacheAllocations
Removed: The ShowCacheAllocations system procedure is no longer available.
SQL :: ShowCachePages
Removed: The ShowCachePages system procedure is no longer available.
SQL :: ShowCachePartitions
Removed: The ShowCachePartitions system procedure is no longer available.
SQL :: ShowHealthCounters
Shows the health counters tracked by the engine, such as cache hits and misses and lock wait time.
SQL :: ShowLocks
Shows every lock held by every transaction, optionally for a single process.
SQL :: ShowMemoryUtilization
Shows the operating system's view of the memory used by the database engine.
SQL :: ShowMySchemaPolicy
Shows the permissions that the logged in account has on a schema, and the role and schema each was inherited from.