Low Physical Memory Warning Message From Red Gate


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?


more ▼

asked Aug 27, 2010 at 01:20 AM in Default

avatar image

1.6k 55 59 62

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Aug 27, 2010 at 01:24 AM

avatar image

26.2k 18 37 48

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Aug 27, 2010 at 01:20 AM

Seen: 1575 times

Last Updated: Aug 27, 2010 at 03:08 AM

Copyright 2018 Redgate Software. Privacy Policy