Created
May 29, 2019 11:45
-
-
Save BrentOzar/46571c5b1fc7e36d2a235b67e71a4ad9 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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