SQL 2012 Memory Clerks

• SQLSACT

  SSC-Insane

  Points: 21838

  More actions

  September 27, 2013 at 7:00 am

  #298414

  Hi All

  Prior to SQL 2012, when using the sys.dm_os_memory_clerks, the MEMORYCLERK_SQLBUFFERPOOL clerk always showed zero, this was because single_pages_kb refers to the amount of single pages the clerk is pulling from the buffer pool, so the buffer pool won't be reading single pages from itself, hence the 0kb.

  Has this changed in SQL 2012? I am seeing huge amounts for this clerk now which I am assuming is the database data/index pages.

  Thanks

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  September 27, 2013 at 7:55 am

  #1654028

  Yes.

  There are a lots of chages in many DMVs structure. See http://blogs.msdn.com/b/sqlosteam/archive/2012/07/11/memory-manager-surface-area-changes-in-sql-server-2012.aspx

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)