psanjoy
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?
How can identify which db takes max memory and how we can fine tune it?
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
which process takes all the ram? see performance monitor under "memory" tab..