Solved

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

Posted on 2012-03-14
4
1,123 Views
Last Modified: 2012-06-21
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
0
Comment
Question by:Burns1978
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 30

Accepted Solution

by:
pgm554 earned 167 total points
ID: 37723109
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
0
 
LVL 42

Assisted Solution

by:kevinhsieh
kevinhsieh earned 167 total points
ID: 37723550
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.
0
 
LVL 18

Assisted Solution

by:BigSchmuh
BigSchmuh earned 166 total points
ID: 37724064
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)
0
 
LVL 42

Expert Comment

by:kevinhsieh
ID: 37726217
I believe that any single CPU server would provide more than enough CPU power.
0

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Requirements: root access via SSH, telnet, or other.. Alternately, access from the server administrator to run a counter-strike server, and the proper access rights to do so. Enough free disk space (and allowed to use this much, eg disk quota): 6…
Moving your enterprise fax infrastructure from in-house fax machines and servers to the cloud makes sense — from both an efficiency and productivity standpoint. But does migrating to a cloud fax solution mean you will no longer be able to send or re…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

710 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