• select name,type,

    sum(single_pages_kb+multi_pages_kb) as MemoryKB

    from sys.dm_os_memory_clerks

    group by name,type

    order by memorykb desc