ReleaseCacheAllocations

Table of Contents

Overview
Prototype

Example

See also
Related

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

Prototype

ReleaseCacheAllocations()

Permissions

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

Example

Empties the cache and releases its memory.

EXEC ClearCacheAllocations
EXEC ReleaseCacheAllocations

See also

Home

The home page

SQL :: Alter Procedure

User-defined stored procedures are not currently available.

SQL :: Cancel

Cancels (rolls back) the transaction of the given process, leaving the process connected.

SQL :: CheckpointHealthCounters

Writes the health counters to disk. This is useful when monitoring performance and you need the metrics in the health JSON file.

SQL :: ClearCacheAllocations

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.

SQL :: ClearHealthCounters

Resets the health counters tracked by the engine. This is helpful when performance tuning.

SQL :: Exec

Exec runs a system procedure.

SQL :: Keywords

A breakdown of all of the statements and keywords supported by the query processor.

SQL :: Print

Evaluates an expression and returns the result as a message with the query results.

SQL :: RefreshMyRoles

Reloads the role memberships of the logged in account. Roles are cached at login, so run this after your memberships change instead of logging out and back in. The roles are returned as messages.