Tell me more ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.
up vote 0 down vote favorite

I need some SQL Server configuration advice

My application is an eCommerce Application and CMS built on Microsoft .NET 4.0 framework.

I am configuring my IIS web server with a: Dual Intel Xeon E5-2620 @2.00GHz hex core CPU Passmark 8,242 x2 = 18,484 Total 12 cores Comes with 64GB RAM 1TB Sata drive x 2 configured with s/w RAID 1

My dilemma is getting the best off-the-shelf configuration for my SQL Server 2008 R2 64 bit Server.

Server options 1)

Dual Intel Xeon E5-2620 @2.00GHz hex core CPU Passmark 8,242 x2 = 18,484 Total 12 cores 64 GB RAM Max 4 drive bays

Pros: Dual Processor, 12 cores & 64GB RAM Cons: A bay size of 4 drives limits my RAID options and separate spindle options (OS, Temp DB, Data fiels and Tranlogs)

Disk Config Options: 1 x RAID 10 Everything on one logical drive 2 x RAID 1 Arrays 1 RAID 5 array (3 dives) plus 1 one disk dedicated to tranlogs with NO RAID

Server options 2)

Single Intel Xeon E3-1270 V2 @ 3.50GHz 4 Cores Total Max 32GB RAM Max 8 Drive Bays

CONS Limited to single processor and 32GBRAM

PROS: 8 Drive bays allows for optimized SQL config H/W RAID 1 (1TB Sata x2) OS & TempDB H/W RAID 1 (1TB Sata x2) Log Files H/W RAID 10 (1TB Sata x4) Data

Which of these 2 server would deliver the best SQL Server 2008 R2 64bit performance with a database intensive application (OLAP)?

Many thanks in advance for any advice.

share|improve this question
2  
A lot more information will be needed before you can decide what config you need for your SQL Server. The biggest is how much disk IO you need, how large the database is, what the data change set will be, etc. – mrdenny♦ Dec 31 '12 at 4:47

closed as not constructive by EEAA, joeqwerty, TomTom, Ward, Khaled Dec 31 '12 at 8:01

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or specific expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, see the FAQ for guidance.