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

Question

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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 1

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/