April 9, 2009 at 7:42 am
Hi Guys,
I am currently experiencing memory issues on one of my servers. We are currently using a third party tool and the memory utilization on the box is more than 90%.
Server Details:
64 bit SQL server
Windows Server 2003
SP2
Dual-Core AMD
7 GB RAM
I upgraded from a 32 bit to a 64 bit last month. Enabled the -g switch to 512.
Should I change the max memory to a different amount? Currently it's set to 2147483647.
Please advise on what to do.
Regards
IC
April 9, 2009 at 8:49 am
HI
I would set the maximum Memory to 6GB and leave 1GB for OS, this is the case when you have only SQL server running on a server, as u mentioned you are having a 3rd party app, check how much that app needs and include that in free memory, then restart SQL server for this effect to take place, then check how much memory is been used and by which app. 🙂
April 9, 2009 at 8:53 am
Thanks for this. The app is situated on another box.
Do I have to restart the machine after I set the memory to 6GB?
Regards
IC
April 9, 2009 at 6:09 pm
Yes.
To reduce the max server memory you may need to restart SQL Server to release the memory(http://msdn.microsoft.com/en-us/library/ms178067.aspx).
MJ
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply