You mean something like this

select

SUM(pages_allocated_count)*8 as MemKB,

type

from

sys.dm_os_memory_objects

group by

type

order by

MemKB desc

select

SUM(pages_allocated_count)*8 as MemKB,

type

from

sys.dm_os_memory_cache_entries

group by

type

order by

MemKB desc