Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Memory Clerks - MEMORYCLERK_SQLBUFFERPOOL Expand / Collapse
Author
Message
Posted Sunday, November 25, 2012 11:54 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, December 18, 2014 12:03 AM
Points: 1,380, Visits: 2,708
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





Post #1388442
Posted Monday, November 26, 2012 12:16 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 1:37 PM
Points: 40,662, Visits: 37,127
First hit on google for "MEMORYCLERK_SQLBUFFERPOOL single page allocator"

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/2c14df9a-0f82-45a5-ac53-13062eb3a2df/

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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1388446
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse