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_clerksGROUP BY TYPEORDER BY SUM(single_pages_kb) DESC, SUM(multi_pages_kb) DESCGOWhat is your method to