Home > SQL SEVER – Finding Memory Pressure – External and Internal

SQL SEVER – Finding Memory Pressure – External and Internal

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

Etiquetas:

performance

Página inicial Mapa do site RSS Imprimir

SQL SEVER – Finding Memory Pressure – External and Internal

Etiquetas:

Pesquisar no site