opc.three (3/1/2013)

---

Is your system running NUMA of any flavor?

Does this yield multiple rows?

SELECT [type],

[name],

memory_node_id,

SUM(single_pages_kb) / 1024 AS [SPA Mem, Mb]

FROM sys.dm_os_memory_clerks

WHERE type = 'CACHESTORE_SQLCP'

GROUP BY [type],

[name],

memory_node_id;