If the physical memory on the server is full and you have allocated “Maximum Server memory” for SQL Server close the physical memory of the server then I would recommend decreasing the “Maximum Server memory” of SQL Server to left some memory for Operating system.

If your SQLServer engine max server memory is reached the limit and you still have physical memory available then I would advise increasing the “Maximum Server memory” will help.

If your Virtual memory is full then you need more Physical memory and I would advise to add the same.

About Me

I have been working with Database technologies for over 16 years, specialized in High Availability Solutions such as Oracle RAC, Data Guard, Grid Control, SQLServer Cluster, SAPHANA. I have experience on wide range of products such as MySQL, Oracle Essbase, Agile, SAP Basis, SharePoint, Linux and Business Apps admin. I have implemented many business critical systems for fortune 500, 1000 companies.