DMV: dm_os_memory_objects

select type, sum(pages_allocated_count) total_pages_allocated_count
from sys.dm_os_memory_objects
group by type
order by 2 desc