Finding Memory Pressure – External and Internal

The following query will provide details of external and internal memory pressure. It will return the data how much portion in the existing memory is assigned to what kind of memory type.

SELECT TYPE, SUM(single_pages_kb) InternalPressure, SUM(multi_pages_kb) ExtermalPressure

FROM sys.dm_os_memory_clerks

GROUP BY TYPE

ORDER BY SUM(single_pages_kb) DESC, SUM(multi_pages_kb) DESC

GO