Find Out Memory Used by SQL Server Components

The sys.dm_os_memory_clerks Dynamic Management View returns the set of all memory clerks that are currently active in the instance of SQL Server 2005/2008.

Here’s how to use this view:

SELECT name, type,
SUM(single_pages_kb + multi_pages_kb) AS MemoryKB
FROM sys.dm_os_memory_clerks
GROUP BY name, type
ORDER BY MemoryKB desc

OUTPUT