Skip to content

Instantly share code, notes, and snippets.

@BrentOzar
Created May 29, 2019 11:45
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save BrentOzar/46571c5b1fc7e36d2a235b67e71a4ad9 to your computer and use it in GitHub Desktop.
Save BrentOzar/46571c5b1fc7e36d2a235b67e71a4ad9 to your computer and use it in GitHub Desktop.
SELECT msm.*, hbp.*, pmem_in_use_kb = pm.physical_memory_in_use_kb, large_pages_kb = pm.large_page_allocations_kb,
locked_pages_kb = pm.locked_page_allocations_kb, commit_limit_kb = available_commit_limit_kb,
tot_mem_kb = sm.total_physical_memory_kb, [version] = @@VERSION,
sm.available_physical_memory_kb
FROM sys.dm_os_process_memory pm
CROSS JOIN sys.dm_os_sys_memory sm
CROSS JOIN (SELECT max_server_mem = value_in_use FROM sys.configurations
WHERE NAME = 'max server memory (MB)') msm
CROSS JOIN (SELECT hybrid_buffer_pool = value_in_use FROM sys.configurations
WHERE NAME = 'hybrid_buffer_pool') hbp
SELECT * FROM sys.dm_os_memory_clerks ORDER BY virtual_memory_reserved_kb DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment