Hi, I am now getting the following message from Red-Gate Response.
Low physical memory: Server_01
It has 24GB on the server. 2147483647 Maximum Server Memory in (MB). I don't think server need more memory.
Why I keep getting that message? Memory Leak somewhere???
asked Oct 26 '10 at 08:56 AM in Default
Limit the max server memory on SQL Server so that it doesnt starve the OS for memory and see what happnes. If SQL is the only one running on that machine you can limit SQL around 20GB and leave the rest for the OS.
Try something in the line of:
answered Oct 26 '10 at 09:06 AM