ShowMemoryUtilization

Table of Contents



Shows the operating system's view of the memory used by the database engine.

ShowMemoryUtilization()

Permissions

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


One row with the columns: Working Set, Min. Working Set, Max. WorkingSet, Peak Working Set, Paged Memory, Non-paged System Memory, Peak Paged Memory, Peak Virtual Memory, Virtual Memory and Private Memory.

round-pushpin Shows the memory usage.
EXEC ShowMemoryUtilization




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.