Find SQL Server Memory total and Available including Page File Size

-- Good basic information about memory amounts and state

SELECT total_physical_memory_kb/1024000 Total_Physical_MM_GB, available_physical_memory_kb/1024000 Available_Physical_MM_GB,

total_page_file_kb/1024000 Total_Page_File_GB, available_page_file_kb/10240000 Available_Page_File_GB,

system_memory_state_desc

FROM sys.dm_os_sys_memory WITH (NOLOCK) OPTION (RECOMPILE);

-- You want to see "Available physical memory is high"

-- This indicates that you are not under external memory pressure