--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); ------