Get Memory Clerk Usage

SELECT TOP (10) mc.[type] AS [Memory Clerk Type]
	,CAST((SUM(mc.pages_kb) / 1024.0) AS DECIMAL(15, 2)) AS [Memory Usage (MB)]
FROM sys.dm_os_memory_clerks AS mc WITH (NOLOCK)
GROUP BY mc.[type]
ORDER BY SUM(mc.pages_kb) DESC
OPTION (RECOMPILE);





dm_os_memory_clerks

Spread the love