查詢sql server 2005 記憶體瓶頸

--緩沖區池消耗記憶體總量

SELECTSUM(multi_pages_kb + virtual_memory_reserved_kb + shared_memory_reserved_kb

+awe_allocated_kb) AS[Used by BPool,kb]

FROM sys.dm_os_memory_clerks

WHERE type='MEMORYCLERK_SQLBUFFERPOOL'

--查詢确認哪些内部元件竊取了緩沖區池中大部分的頁面

SELECTTOP10 type,

SUM(single_pages_kb) AS stolen_mem_kb

GROUPBY type

ORDERBYSUM(single_pages_kb) DESC

--緩沖區池外配置設定了記憶體的内部元件

SUM(multi_pages_kb) AS menory_allocated_kb

ORDERBYSUM(multi_pages_kb) DESC