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 :: System Procedures
Built-in procedures for inspecting and managing the database engine.
SQL :: Terminate
Terminates a process: rolls back its transaction, disconnects it and frees its resources. Kill does the same thing.