Run this one too please and post the results, this one includes multi-page allocations:
-- top 10 consumers of memory
SELECT TOP 10
type,
CAST(SUM(single_pages_kb+multi_pages_kb) / 1024.0 AS DECIMAL(10, 2)) AS [Mem, Mb]
FROM sys.dm_os_memory_clerks
GROUP BY type
ORDER BY SUM(single_pages_kb+multi_pages_kb) DESC ;
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato