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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy