x

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.
more ▼

asked Aug 27 '10 at 01:20 AM in Default

Leo gravatar image

Leo
1.6k 51 56 58

(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 '10 at 01:24 AM

WilliamD gravatar image

WilliamD
25.8k 17 19 41

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1816
x53

asked: Aug 27 '10 at 01:20 AM

Seen: 1239 times

Last Updated: Aug 27 '10 at 03:08 AM