ReleaseCacheAllocations



Returns unused cache memory to the operating system. Call ClearCacheAllocations first to release as much memory as possible.

ReleaseCacheAllocations()

Permissions

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


round-pushpin Empties the cache and releases its memory.
EXEC ClearCacheAllocations
EXEC ReleaseCacheAllocations




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.