/* --------------------------------------------------
유형별 메모리 할당
-------------------------------------------------- */
SELECT [type]
, [name]
, SUM(pages_kb) AS [MEM(KB)]
FROM sys.dm_os_memory_clerks
GROUP BY
[type]
, name
ORDER BY SUM(pages_kb) DESC;