Stolen SQL Server Memory

Hi,

i have a question on stolen sql server memory for one of my sql 2012 instance (64bit)

Max memory set as 18 gb out of total 24 gb

Stolen memory shows as 13gb, please advice how i can reduce and find what is causing this high.

Thanks & Regards,
Chandra
Chandra Mohan KanithiPrincipal Consultant - DatabaseAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jmcgOwnerCommented:
That's an alarming number.

Just to get you started, can I assume you've looked at the various web pages that talk about this topic? Here are a couple that I found:

http://sql-sasquatch.blogspot.com/2013/09/perfmon-database-pages-stolen-pages.html

where the SQL Sasquatch talks about stolen page metrics, but doesn't give a full solution.

The most often mentioned culprit is ad hoc queries, hence:

http://www.sqlserver-dba.com/2012/11/sql-server-troubleshooting-internal-memory-pressure-stolen-pages-and-buffer-count.html

and

http://www.sqlservercentral.com/Forums/Topic1549602-3387-1.aspx

which give some directions on how to probe for more detailed breakdown of memory consumption.

So, maybe those links can get you started on investigating your problem. Shortly, more experts will be along who know more specifically what you should do and the mods are then welcome to delete this placeholder post.
Vitor MontalvãoMSSQL Senior EngineerCommented:
The server is dedicated to SQL Server engine? Or do you have more things installed?
Please count SSAS, SSIS & SSRS and non part of SQL Server engine.
EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
please post your OS version\edition \service pack
also for your sql 2012 edition and service pack

you need make sure to have the latest sp for OS and sql server installed that can fix your issue
Also,as per above post, tell what sql components are installed, etc
and try the sysinteranls VMMap utility

<VMMap is a process virtual and physical memory analysis utility>
https://technet.microsoft.com/en-us/library/dd535533.aspx

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.