SQL SEVER – Finding Memory Pressure – External and Internal

Posted by pinaldave on SQL Authority See other posts from SQL Authority or by pinaldave
Published on Fri, 10 Dec 2010 01:30:30 +0000 Indexed on 2010/12/10 22:20 UTC
Read the original article Hit count: 688

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?

Reference: Pinal Dave (http://blog.sqlauthority.com)


Filed under: Pinal Dave, SQL, SQL Authority, SQL Optimization, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology

© SQL Authority or respective owner

Related posts about Pinal Dave

Related posts about sql