Optimal Memory Settings for Sql Server 2005
Posted on 2011-09-13
I am having some issues with my Sql Server 2005 Server. on Windows 2008 R2
Looking into whether it might be a Raid issue, as I'm seeing some delay type errors in access .ldf files, but. I have heard some issues about Sql Server being a bit of a memory Hog.
I have 16gb of ram on this box, and while it is primarily running Sql Server 2005 (sp3) I also have backup software, as well as a little application server that looks for scanned documents and stores them in a database.
So the question is:
1) what should I set the sql server memory settings - min and max to?
2) If I change this, do I need to reboot, or can I do this on the fly.
3) Any other suggestions?
Thanks all, I'm in a little over my head on troubleshooting this.
I am thinking a problem with the RAID drive only because when I installed 2008 R2 (clean install) it installed and ran so cleanly, that besides normal updates I haven't updated specific drivers for the LSI card.