DMV: dm_os_memory_clerks

--
--Check Memory Usage
--
select top 15
type,
sum(single_pages_kb)/1024 single_pages_mb,
sum(multi_pages_kb)/1204 multi_pages_mb,
sum(awe_allocated_kb)/1024 awe_allocated_mb
from sys.dm_os_memory_clerks
group by type
order by 2 desc