Click here to monitor SSC
SQLServerCentral is supported by Redgate
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: Thursday, May 19, 2016 5:02 AM
Points: 1,412, Visits: 2,879
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 @ 3:01 PM
Points: 44,597, Visits: 42,322
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, MVP, M.Sc (Comp Sci)
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