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?

[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.

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..
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
Qlemo"Batchelor", 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.
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

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.
psanjoySystem AdministratorAuthor Commented:
Issue has been by shrinking high utilized databases.  Helped below article https://support.microsoft.com/en-us/kb/920093

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
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.