Check Memory pressure on the server

--Memory presure 3 query
SELECT m.process_physical_memory_low
	,m.process_virtual_memory_low
FROM sys.dm_os_process_memory m --both should be zero

SELECT m.physical_memory_in_use_kb / 1024 [Mem Used in MB]
FROM sys.dm_os_process_memory m

SELECT m.total_physical_memory_kb / 1024 [Mem in MB]
	,m.available_physical_memory_kb / 1024 [Available Mem MB]
	,m.system_memory_state_desc
FROM sys.dm_os_sys_memory m

SELECT m.committed_kb / 1024 [Commited in MB]
	,m.committed_target_kb / 1024 [TartGet Mem MB]
FROM sys.dm_os_sys_info m

Possible System Memory State values:
* Available physical memory is high
* Physical memory usage is steady
* Available physical memory is low
* Available physical memory is running low
* Physical memory state is transitioning

-- Good basic information about OS memory amounts and state 
SELECT total_physical_memory_kb/1024 AS [Total Memory (MB)], 
       available_physical_memory_kb/1024 AS [Available Memory (MB)], 
       total_page_file_kb/1024 AS [Total Page File (MB)], 
available_page_file_kb/1024 AS [Available Page File (MB)], 
	   system_cache_kb/1024 AS [System Cache (MB)],
       system_memory_state_desc AS [System Memory State]  --should be "Available physical memory is high" 
FROM sys.dm_os_sys_memory WITH (NOLOCK) OPTION (RECOMPILE);
------

sys.dm_os_sys_memory

Spread the love