Memory Clerks - MEMORYCLERK_SQLBUFFERPOOL

• SQLSACT

  SSC-Insane

  Points: 21838

  More actions

  November 25, 2012 at 11:54 pm

  #285092

  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

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  November 26, 2012 at 12:16 am

  #1562078

  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, 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