How to find out who is stealing memory from Buffer Pool memory ??

• vsamantha35

  SSChampion

  Points: 11551

  More actions

  April 29, 2016 at 8:11 am

  #316098

  Hi All,

  I wanted to see what all components are stealing memory from Buffer Pool as I can clearly see the Stolen Pages count very high.

  In SQL 2012, Is there a DMV through which we can tell how is stealing memory ?

  The below dmv works well in sql 2008 but in SQL 2012, multi_pages_kb column is missing.

  select top 10 type, multi_pages_kb

  from sys.dm_os_memory_clerks

  order by multi_pages_kb desc

  Thanks in advance.

  -Sam

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738337

  More actions

  April 30, 2016 at 12:23 pm

  #1875768

  This might help: https://www.simple-talk.com/blogs/2009/08/03/stolen-pages-ad-hoc-queries-and-the-sins-of-dynamic-sql-in-the-application/

  Stolen pages being high (whatever that is for your system) is a sign of memory pressure. Lots of ad hoc queries, things that require SQL Server to use the memory instead of the buffer pool.

  You might also diagnose here: http://blogs.msmvps.com/bradley/2009/01/15/how-to-troubleshoot-sql-memory-issues-part-ii/