select [physical_memory_kb], [virtual_memory_kb], [committed_kb], [committed_target_kb], [sql_memory_model_desc], [numa_node_count] from sys.dm_os_sys_info;

select top 10 [name], [type], [pages_kb], [entries_count] from sys.dm_os_memory_cache_counters order by [pages_kb] desc;

select count_big([page_id])/128 as [cached_mb],
       case [database_id] when 32767 then 'resource' else db_name([database_id]) end as [db]
from sys.dm_os_buffer_descriptors
group by db_name([database_id]), [database_id]
order by 1 desc

SELECT 
      [physical_memory_in_use_kb] /1024 as [phys_mb],
      [large_page_allocations_kb] /1024 as [large_page_mb]
      [page_fault_count] as [faults],
      [memory_utilization_percentage] as [mem_usage],
      [process_physical_memory_low] as [phys_low]
      [process_virtual_memory_low] as [virt_low]
FROM sys.dm_os_process_memory;  

select [name], [value], [value_in_use], [description] from sys.configurations where [name] in (N'locks', N'min memory per query (KB)', N'query wait (s)', N'min server memory (MB)', N'max server memory (MB)', N'max degree of parallelism')

select [cntr_value], [instance_name], [counter_name] from sys.dm_os_performance_counters where [counter_name] in ('Periodic evictions (pages)', 'Pressure evictions (pages/sec)') and instance_name = 'Buffer Pool'
union
select [cntr_value], [instance_name], [counter_name] from sys.dm_os_performance_counters where [counter_name] in ('Page life expectancy')
union
select [cntr_value], [instance_name], [counter_name] from sys.dm_os_performance_counters where [counter_name] in ('Query exec memory target (KB)')
union
select [cntr_value], [instance_name], [counter_name] from sys.dm_os_performance_counters where [counter_name] in ('Memory Grants Pending', 'Memory Grants Outstanding', 'Granted Workspace Memory (KB)' )
union
select [cntr_value], [instance_name], [counter_name] from sys.dm_os_performance_counters where [counter_name] in ('Memory grant queue waits') and [instance_name] = 'Average wait time (ms)'