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




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.