10k HDD SAS OR SATA SSD For TS & DB server 2008r2

Hi Experts!

I plan to deploy a new Windows server 2008 R2. This server will have 2 roles.
1-Terminal server 10 users
2-DB server  MS SQL type

Now it's time to choose the right hardware for this project.
What type of Storage and configs would you recommend between:
Raid 5 of 3 SAS 10k  HDD,2 SSD (intel 520) in RAid1 or
anything else?

Thank you very much
LVL 1
Burns1978Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

pgm554Commented:
Actually ,I would put the OS on a RAID 1 set using the SSD's and use the SAS RAID 5 for the data and apps.

Although,you may just want to add a 4th drive in the RAID SAS set and do a RAID 10 as RAID 5 is not all that great on writes.

See:

http://msdn.microsoft.com/en-us/library/ms190764.aspx

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
kevinhsiehCommented:
Ten users are not that many. If you can fit everything on SSDs, that will perform much better than the SAS drives for everything but large file transfers.

A single quad core processor from the last 5 years should be fine, and make sure that you have enough RAM. Not sure how large your database will be or the apps that your users will be using. Use a 64bit OS, and probably start with at least 4 GB RAM, with 24 GB probably being major overkill, so pick something reasonable. The system will probably perform pretty well virtualized, especially if you use SSD.
BigSchmuhCommented:
Terminal services requires a mix of random and sequential io
MS-SQL mainly requires random io

Comparing a single 10krpm HDD vs the Intel 520:
Random read io : 10krpm HDD can sustain about 180 IOPS where an Intel 520 is accounting about 16000 IOPS
Random write io : 10krpm HDD can sustain about 180 IOPS where an Intel 520 is accounting about 70000 IOPS
Sequential read/write throughput : Current Sandforce based SSD delivers double throughput (about 380 MB/S) ... and REQUIRE a 6Gbps sata port

For ALL random io usages : SSD rock and are the cheapest choice ($ per IOPS) !
For sequential usages : SSD rock but are a more expensive choice ($ per MB/s) than HDD !

NB: Due to the read/xor/write penalty, parity RAID (5/6/50/60) arrays are to be avoided when one is expecting more than a few % of random io

Regarding RAM, I would fill my box with 4GB [about $9/GB] DIMMs to allow my DBMS to keep most of its data/index in memory. Ex: A 12 DIMM slots server would get 48GB RAM using 4GB DIMMs for about $420...at that price level, you don't want to risk being short in memory (which would require a service interruption and manual operation to raise the RAM)...even 8GB DIMMs are affordable, 12x 8GB = 96GB is about $960

Regarding CPU, any dual cpu server will fulfill your requirements.

Going with VM in a virtualized platform would lower the administration at 5 years boundary (because you can easily move your VM between servers and define disaster recovery plan at the VM level)
kevinhsiehCommented:
I believe that any single CPU server would provide more than enough CPU power.
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
Server Hardware

From novice to tech pro — start learning today.