I am keep getting 'Low Physical Memory' Message on couple of my servers. I am getting those messages from Red Gate Response software. I am not running too much work load on the server and it has 24GB of memory installed. Checked in Task Manager and SQL server is using 23GB of memory as usual.
Any idea to resolve that issue?
It is generally a good idea to leave around 3GB memory for Windows, and let SQL Server have the rest (max memory setting for the SQL server instance).
That being said; if your memory usage is fine for you, you can change the warning level in Response to suit your needs.
answered Aug 27 '10 at 01:24 AM