Please help me understand why the following Query returns 0 for the Single Page allocator on my system for the MEMORYCLERK_SQLBUFFERPOOL clerk
SELECT [type], [name], SUM(single_pages_kb) AS [SPA Mem, Kb] ,SUM(multi_pages_kb) AS [MPA Mem, Kb]
GROUP BY [type], [name]
ORDER BY SUM(single_pages_kb) DESC;
Does this mean that there are zero pages in my Buffer Pool? This definately cannot be the case.