question

Leo avatar image
Leo asked

Low Physical Memory Warning Message From Red Gate

Hi, 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? Thanks.
sql-server-2008memory
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
WilliamD avatar image
WilliamD answered
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.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.