SQL SEVER – Finding Memory Pressure – External and Internal

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

What is your method to find memory pressure?

Read more: Journey to SQL Authority with Pinal Dave

Posted via email from .NET Info