Hi Sujeet,
I am very new to sql server, and I am working at a company where I am getting this kind of errors very frequently with almost every server. As per my knowledge , sql server takes memory from OS ,when it needs but does not releases though when it's not of any use later. So, please suggest how to deal this kind of issues and how to release memory if possible? or the only solution is to increase RAM??
total ram is 6GB
sqlserv.exe\sa using 4710952K
sql server 2008
I also hve checked the error logs but didn't find any errors.
Customer Comments: sqlserver.exe is taking maximum memory.
Summary: server name : Memory utilization is 96.89%
Kindly suggest at the earliest.
Thank you,
Rajani
