Link to home
Start Free TrialLog in
Avatar of psanjoy
psanjoyFlag for United Arab Emirates

asked on

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?
Avatar of Giladn
Giladn
Flag of Israel image

please give more details, what is running on this server? SQL? EXCHANGE?
which process takes all the ram? see performance monitor under "memory" tab..
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
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.
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.
ASKER CERTIFIED SOLUTION
Avatar of psanjoy
psanjoy
Flag of United Arab Emirates image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of psanjoy

ASKER

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