SQL Server: memory management

Three layers of memory

Querying a few memory related values from system views

select
   name,
   description,
   value_in_use
from
   sys.configurations
where
   name like '%memory%'

select
   convert(decimal (10,2), physical_memory_kb  / 1024.0 / 1024.0) physical_memory_gb,
   convert(decimal (10,2), virtual_memory_kb   / 1024.0 / 1024.0) virtual_memory_gb,
   convert(decimal (10,2), committed_kb        / 1024.0 / 1024.0) committed_gb,
   convert(decimal (10,2), committed_target_kb / 1024.0 / 1024.0) committed_target_gb
from
   sys.dm_os_sys_info;

See also