Solved

Optimal Memory Settings for Sql Server 2005

Posted on 2011-09-13
7
205 Views
Last Modified: 2012-05-12
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

0
Comment
Question by:akessel
  • 4
  • 3
7 Comments
 
LVL 8

Expert Comment

by:venk_r
ID: 36530641
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
 
LVL 8

Expert Comment

by:venk_r
ID: 36530646
Also is this a 32 or 64 bit machine?
0
 

Author Comment

by:akessel
ID: 36530665
64 bit 2008 R2
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 8

Expert Comment

by:venk_r
ID: 36530699
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
 

Author Comment

by:akessel
ID: 36530801
Leave minimum at zero?

and stupid question but for maximum 12000 (MB)
0
 
LVL 8

Accepted Solution

by:
venk_r earned 500 total points
ID: 36530813
thats right.
0
 

Author Closing Comment

by:akessel
ID: 36530920
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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Impove long SQL Stored Procedure Performance 14 79
Delete from table 6 48
Strange msg in the SSMS pane 13 60
Stored Procedure needs owner to execute 5 44
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question