Select type, - type of clerk
sum(virtual_ memory_ reserved_ kb)as vm_ Reserved_ KB, - reserved memory
sum(virtual_ memory_ committed_ kb)as vm_ Committed_ KB, - committed memory
sum(awe_ allocated_ kb)as awe_ Allocated_ KB, - memory used after awe is turned on
sum(shared_ memory_ reserved_ kb)as sm_ Reserved_ KB, - shared reserved memory
sum(shared_ memory_ committed_ kb)as sm_ Committed_ KB, - shared committed memory
sum(single_ pages_ kb)as SinlgePage_ Memory of stolen in KB, - buffer pool
sum(multi_ pages_ kb)as MultiPage_ KB -- memory of memtoleave
FROM sys.dm_os_memory_clerks
GROUP BY type ORDER BYtype
--Query buffer pool / memory to leave
SELECT
sum(virtual_memory_reserved_kb)AS [Reserved],
sum(virtual_memory_committed_kb)AS [Commit],
sum(virtual_memory_reserved_kb)/sum(virtual_memory_committed_kb) AS[Reserved/Commit],
sum(single_pages_kb)+sum(multi_pages_kb) AS [Stolen],
sum(virtual_memory_committed_kb)+sum(single_pages_kb)AS [Buffer Pool],
sum(multi_pages_kb) AS[MemToLeave],
SUM(awe_allocated_kb)AS [AWEAllocated]
FROM sys.dm_os_memory_clerks
--Query SQL server memory usage
select * from sys.dm_os_process_memory
