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
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: Monday, April 13, 2015 2:38 AM
Points: 1,391, Visits: 2,751
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?


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



Group: General Forum Members
Last Login: Yesterday @ 9:06 AM
Points: 41,533, Visits: 38,142
First hit on google for "MEMORYCLERK_SQLBUFFERPOOL single page allocator"

And the BoL page for the DMV you're using

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