Optimal Memory Settings for Sql Server 2005

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.

Regards,  Andy

akesselAsked:
Who is Participating?
 
venk_rConnect With a Mentor Commented:
thats right.
0
 
venk_rCommented:
You need to first identify the exact problem before tweaking the memorys ettings.Check to see if its memory issue or the disk issue.
0
 
venk_rCommented:
Also is this a 32 or 64 bit machine?
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
akesselAuthor Commented:
64 bit 2008 R2
0
 
venk_rCommented:
Well ,if it turns out to be a memory issue  and If there are other software running apart from the SQL Server on this machine then try to allocate 12G to the SQL Server  which leaves 3-4 G to the OS.
The memory change should be dynamic  and it shouldnt need a restart.
0
 
akesselAuthor Commented:
Leave minimum at zero?

and stupid question but for maximum 12000 (MB)
0
 
akesselAuthor Commented:
thanks for your help.  I can't see the harm in limiting the server to 12 gb for sql server, so going to see if it has any impact.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.