I am using SQL SERVER 2008R2 in Window 7 with 16 GB RAM, and three production database are running on that server.
I am worrying about Memory usage reserverd upto 15.1 GB out of 16 GB. and most of the memory has taken by SSMs & SSRS. but when at night there is no user is working at that time Memory usage will not be release the space , it will be remain same. because of that we have got complain that application is running slow from the users and sometimes while generating the reports its throw the error" out of memory".
can anyone please help me on this.