2M (8/22/2016)
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.
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