SQL server memory utilization shows almost 100% utilization

Server memory is 16GB and ultilization shows 95%
How can identify which db takes max memory and how we can fine tune it?
psanjoySystem AdministratorAsked:
Who is Participating?
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.

GiladnCommented:
please give more details, what is running on this server? SQL? EXCHANGE?
which process takes all the ram? see performance monitor under "memory" tab..
0
GiladnCommented:
see here:
https://support.microsoft.com/en-us/kb/321363

and here for determination how much ram is needed for your  SQL:
https://support.microsoft.com/en-us/kb/319942/en-us

G
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Unless you have several instances of services, and they are competing for memory (individual process' memory usage is changing much all the time) , let it alone. Used memory is good memory, it is only an issue if memory needs to get allocated and released all the time because the processes do not have enough available to work well.
0
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

sameer2010Commented:
Other parameters to look for include multi-core CPU, unlimited memory enablement in 'show advanced options'. Also, check out for fulltext index. Parsing can actually consume huge amount of memory.
0
psanjoySystem AdministratorAuthor Commented:
Issue has been by shrinking high utilized databases.  Helped below article https://support.microsoft.com/en-us/kb/920093
0

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
psanjoySystem AdministratorAuthor Commented:
Took the reference of Microsoft article  https://support.microsoft.com/en-us/kb/920093 for tuning options for SQL Server when running in high performance workloads
0
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 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.