ShowMemoryUtilization
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.
EXEC ShowMemoryUtilization