opc.three (3/15/2012)

---

juanc.aguirre (3/15/2012)

---

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 ;

Hello... there's no server link on that instance.

and... the result of the query is

MEMORYCLERK_SQLOPTIMIZER1.95

CACHESTORE_PHDR30.23

CACHESTORE_XMLDBTYPE0.01

CACHESTORE_EVENTS0.02

USERSTORE_OBJPERM0.40

USERSTORE_TOKENPERM0.37

MEMORYCLERK_SQLSTORENG15.59

CACHESTORE_XPROC0.05

OBJECTSTORE_SNI_PACKET2.66

CACHESTORE_BROKERRSB0.01

Thanks...

That does not look right, did you include the ORDER BY when you ran it?