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?
Last Comment
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
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
Windows Server 2008
Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.
86K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
which process takes all the ram? see performance monitor under "memory" tab..