due to this our server RAM utilization is almost 96% all the time , the moment we shut down SQL Services RAM Utlizatin drops below 5%
when we checked the process Only SQL and Repoerting Servies are the highest utlised proceses
Yup, that's exactly how SQL is supposed to behave. Nothing wrong there, no problems that need solving.
It is supposed to take as much memory as it is allowed (up to max server memory) for caching of data, plans and various other things.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass