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, October 13, 2016 1:22 AM
Points: 1,416, Visits: 2,931
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: Saturday, December 3, 2016 5:18 AM
Points: 45,619, Visits: 44,147
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