November 25, 2012 at 11:54 pm
Hi Guys
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]
FROM sys.dm_os_memory_clerks
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.
Any Help?
Thanks
November 26, 2012 at 12:16 am
First hit on google for "MEMORYCLERK_SQLBUFFERPOOL single page allocator"
And the BoL page for the DMV you're using
http://msdn.microsoft.com/en-us/library/ms175019%28v=sql.105%29.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply