up vote -1 down vote favorite
share [g+] share [fb]

Just purchaced new server: Intel Xeon E3-1230 3.2GHz, 8GB DDR3, 2x 500GB SATA

We are able to get any Windows Server 2008 R2 and any Sql server 2008 r2 for free, so the question is which to choose..

We'll hold a rather small database on this server(at the moment DB is several GBs, but it'll inrease rapidly) which will handle multiple clients (they will request data and add data, including pictures) In the future will need to automate reports, to add CRM-system (most likely microsoft dynamics, cause we'll get that for free)

Question: What OS and sql server (enterprise, standart, data center) is recomended most for our purposes? What to pay attention to when installing? Particularly interested in settings associated with memory and speed.

Thanks in advance!

link|improve this question
feedback

migrated from stackoverflow.com Aug 18 '11 at 16:06

This question came from our site for professional and enthusiast programmers.

1 Answer

up vote 1 down vote accepted

Consult this PDF for SQL Server Standard vs Enterprise:

http://download.microsoft.com/download/2/D/F/2DF66C0C-FFF2-4F2E-B739-BF4581CEE533/SQLServer2008EnterpriseandStandardFeature%20Compare.pdf

I'm pretty sure Standard more than gets the job done for you, but if you have access to Enterprise for both OS and SQL, then it's not going to hurt to just throw that on.

link|improve this answer
I've already read that. I have more to choose from.. Windows Server 2008 R2: Standard, Enterprise, Datacenter, or Web SQL SERVER: Web Edition or Workgroup Edition, Standard Edition, or Developer Edition, Enterprise Edition? – Roman Lemeshko Aug 18 '11 at 16:54
Unless this is going to be a webserver or something internal, or jsut for development I'd recommend standard, enterprise, or Datacenter. then decide on which one of those based on your projected growth over the next few years. I'd say probably standard or enterprise will be the best bet. – tkrabec Aug 18 '11 at 17:14
1  
finally installed Windows Server 2008 r2 Enterprise & SQL server r2 Enterprise. Working AWESOME;) – Roman Lemeshko Aug 26 '11 at 14:09
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.