RAM required for SQL 2008 on Windows server 2008 R2

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?
Angel02Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lcohanDatabase AnalystCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Aneesh RetnakaranDatabase AdministratorCommented:
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
Scott PletcherSenior DBACommented:
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
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Angel02Author Commented:
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
Scott PletcherSenior DBACommented:
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
Pramod UbheCommented:
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
warsawtechConsultantCommented:
I wish I could add to this, but confused by how the server is 2008R2 is 32 bit Angel02??
0
David Johnson, CD, MVPOwnerCommented:
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
Angel02Author Commented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.