Solved

RAM required for SQL 2008 on Windows server 2008 R2

Posted on 2014-10-24
9
164 Views
Last Modified: 2014-11-04
We are planning to install SQL 2008 on a new Windows Server 2008 R2. this is going to be our production database server. Currently we are planning to have a RAM of 4 GB. If we have the option, is it a good idea to increase the RAM? Will it make any difference if SQL is the only thing running on that Server?
0
Comment
Question by:Angel02
9 Comments
 
LVL 39

Accepted Solution

by:
lcohan earned 250 total points
ID: 40402461
Of sourse it will make a huge difference! From my experience I found that people always underdimession the RAM on SQL Servers and expect fast queries - that will never hapen so please add as much RAM as you can (afford) and make sure to set the MAX SQL memeory to not starve your system.

http://www.brentozar.com/archive/2014/05/much-memory-sql-server-need/
http://sqlperformance.com/2013/10/sql-memory/how-much-ram
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 40402470
depends how busy the application ./ database is.  I would definitely go for at least 8 / 16 GB, although I have seen SQL Servers running on 2005/ 2008 with 1GB and 2gb of ram
0
 
LVL 69

Assisted Solution

by:ScottPletcher
ScottPletcher earned 250 total points
ID: 40402506
Given that:
1) the overall cheapest way to improve performance in SQL Server is more RAM;
2) even cheap home PCs routinely have 16GB+ now
4GB is ridiculously low.

Use at least 16GB, and 32GB is strongly preferred.  The money for that will cost far less than trying to tune it to run in only 4GB.
0
 

Author Comment

by:Angel02
ID: 40402995
Thank you for the responses. I will ask for as much RAM as we can afford.

I am now thinking if I should go for Microsoft SQL Server 2012. I can't remember why I picked SQL 2008. I should mention the Windows server is 32-bit for few other reasons. Do you recommend SQL Server 2012?
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 69

Expert Comment

by:ScottPletcher
ID: 40403044
At this point, you should go with SQL 2014.

But definitely 64-bit.  If you main Windows O/S is only 32-bit, you many not be able to run some of the more recent versions of SQL.
0
 
LVL 10

Expert Comment

by:Pramod Ubhe
ID: 40403831
from a vendor support perspective you should always go for latest version/service pack.
for RAM, 4 GB is too low but a database administrator should be consulted who is aware of what kind of database/s will be hosted on that server and based on the load or his analysis he will recommend the RAM. I have some DB servers with 8GB RAM running perfectly fine and some 256GB RAM DB servers which always alert for memory. there is also a setting in SQL to limit RAM utilization by SQL to a certain amount of RAM.
so my recommendation is to get in touch with your database administrator for this.
0
 
LVL 2

Expert Comment

by:warsawtech
ID: 40403857
I wish I could add to this, but confused by how the server is 2008R2 is 32 bit Angel02??
0
 
LVL 78

Expert Comment

by:David Johnson, CD, MVP
ID: 40404712
What is the compelling reason for 32bit server.. that is something that is getting harder and harder to find these days. 32bit server stop at Server 2008R2
0
 

Author Comment

by:Angel02
ID: 40421611
It's actually Window Server 2008, my bad.
There is a DBASE program that the SQL Server accesses and the connections do not work on 64-bit. We have tried everything. Our only option at least for the next few months is to go 32-bit.

Thanks all!
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

757 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now