Hardware Thread, SQL server: RAID1 with SSDs or RAID10 with regular HDs? in Technical; I'm currently investigating a storage upgrade to help add a bit of fizz to our SQL server.
The server only ...
6th October 2011, 01:44 PM #1
SQL server: RAID1 with SSDs or RAID10 with regular HDs?
I'm currently investigating a storage upgrade to help add a bit of fizz to our SQL server.
The server only has a SATA interface, so SCSI or SAS is out as an option. I have 4 drive bays. The server is also a Hyper-V host (not clustered) for other servers that are not disk IO intensive, but I need to maintain a reasonable amount of disk space for those (more than I can afford using just SSDs).
These are the two scenarios I'm considering:
- 2x SSDs in RAID1 for the SQL guest (probably the Intel 320s) + 2x 10,000RPM hard disks in RAID1 (for the other guests)
- 4x 10,000RPM hard disks in RAID10 for all guests.
My thinking is that in RAID10 the 4x HDs should reach a sustained transfer rate approaching or even exceeding the RAID1 SSDs, due to being able to read off of 4 spindles at once. Writing will be slower, but that's the same for SSDs too. However, I suspect that the reduction in seek times will give the SSDs the advantage.
Last edited by AngryTechnician; 6th October 2011 at 01:46 PM.
6th October 2011, 05:06 PM #2
What is the drive controller? The Intel ICH controllers do not (last time I looked) support trim with SSDs in a RAID array, only when they are attached as individual drives.
6th October 2011, 09:59 PM #3
7th October 2011, 09:52 AM #4
Unless your taking hourly backups/or db replication of the SSDs I'd go HDD, SQL bashes the IO continuously and so without the database being replicated on another server with standard storage I'd be a bit iffy. The SSDs will be quicker but the safer option which also gives your other VMs more horesepower to work with is the four spindles option.
RAID controllers can also actually be harmful to the performance of SSDs because all the optimisation and cacheing of calls they do is designed for spindles and so can actually be slower than hitting the SSDs nativly or with a very thin layer of RAID overhead (read cheap RAID controller).
Depending on how many other VMs you have I'd give the whole lot as many spindles as possible as SATA is soooo slow (from personal experience) even with four of them.
By jlondon in forum Windows Server 2008
Last Post: 26th June 2010, 03:14 PM
By tosca925 in forum Hardware
Last Post: 23rd May 2007, 12:36 AM
Last Post: 20th January 2007, 05:58 PM
By wesleyw in forum How do you do....it?
Last Post: 18th October 2006, 02:08 PM
By GavRob in forum Windows
Last Post: 20th September 2006, 11:03 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)