opc.three (3/15/2012)

---

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 ;