question

Leo avatar image
Leo asked

Low Physical Memory - Red Gate

Hi, I am now getting the following message from Red-Gate Response. *Low physical memory: Server_01
Server : Server_01
Alert Level : Medium
Occurred at : 26/10/2010 09:41:53
Description : Low physical memory on 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???
sql-server-2008red-gate
9 comments
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.

WilliamD avatar image WilliamD commented ·
@Leo - you can change the thresholds for alerts on sql response. Your problem here is that Max Memory is not set, but the threshold may also be changed to a lower value if you wish
2 Likes 2 ·
Kev Riley avatar image Kev Riley ♦♦ commented ·
+1 WilliamD's comment - the Red Gate tool works out of the box with a default set of thresholds that may or *may not* apply to your setup. If you had SQL sharing a server with another function (shudder), then memory config would be lower than if the box is a dedicated db server.
0 Likes 0 ·
Leo avatar image Leo commented ·
Hi Will - Where about in SQL Response to change the threshold? I have version 1.3.
0 Likes 0 ·
WilliamD avatar image WilliamD commented ·
@Leo - I can't quite remember, we don't use it here. It was somewhere around the server and alerts themselves. Read the help file or get in touch with Red-Gate, they will help you out.
0 Likes 0 ·
Leo avatar image Leo commented ·
Will - I will have a look in Help file or I might phone them if I can't find it. Kev - that is pure SQL Server, not sharing with anything. So..is that worth to set Max Memory??
0 Likes 0 ·
Show more comments

1 Answer

·
DaniSQL avatar image
DaniSQL answered
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: EXEC sys.sp_configure N'show advanced options', N'1' RECONFIGURE WITH OVERRIDE GO EXEC sys.sp_configure N'max server memory (MB)', N'20000' GO RECONFIGURE WITH OVERRIDE GO EXEC sys.sp_configure N'show advanced options', N'0' RECONFIGURE WITH OVERRIDE GO
2 comments
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.

WilliamD avatar image WilliamD commented ·
@DaniSQL +1: Setting Max Memory should solve the problem here. @Ramesh, page life expectancy and buffer cache hit ratio are not fixed values to try to attain. They should be as high as possible, but do not mean you have a memory leak when they are at less than 100% and less than 300 seconds respectively.
2 Likes 2 ·
ramesh 1 avatar image ramesh 1 commented ·
yes i agree with DaniSQL ,but first check the buffer cache hit ratio it must be 100%, check page life expectancy ,if it is less than 300, then it as a memory leak, check your stored procedure,or other application running in the server,slow running queries, if your sql server is 64 bit, then ignore it, it is the good advantage of sql server 64 bit,
0 Likes 0 ·

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.