Hi,

Thank you for the reply... how to get back the memory which is used by SQL Server as we need some for OS as well. Here my concern is that the amount of memory is taken by SQL Server is not retrieving back. And thing is we cannot clear the buffer cache as it stores the latest transactions on the buffer pool and if we delete it, the performance may de grade as the SQL Server need to get the data from the drive or disk for the data.

Please let me know what to do….

Thank you in advance.