SQLCrazyCertified (1/3/2013)
We have some performance issue..SQL server is running very slow due to high memory usage.
Are you sure that high memory usage is causing SQL to run slow? Cause, not correlation?
Is there any other way to release the memory? Or how can we find why SQL server is using high memory?
What are some of the causes of using high memory? Someone with experience in performance tuning, please advise.
Normal, expected behaviour. SQL uses as much memory as it is allowed to use to cache data and plans to avoid slow disk access and expensive plan recompilations. SQL will use up to the max it is allowed and that is perfectly fine. You typically want SQL to use lots of memory as it allows for efficient caching.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability