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: Friday, October 2, 2015 1:43 AM
Points: 1,403, Visits: 2,801
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: Today @ 2:46 PM
Points: 43,029, Visits: 40,011
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
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