SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


RAID recomendations


RAID recomendations

Author
Message
Perry Whittle
Perry Whittle
SSC-Insane
SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)

Group: General Forum Members
Points: 20280 Visits: 17244
Kenneth.Fisher (1/11/2012)
I appreciate ya'lls help with this. RAID has always been a difficult subject for me but I think I'm finally getting it down.

Just as an aside, we have the interesting problem of not always knowing where are drives are comming from. In other words, the D drive and the E drive may actually both be on the same RAID array, but no one told us, its just the way it was allocated out.

Are you planning to use local disks or SAN presented storage?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
SQLRNNR
SQLRNNR
SSC-Dedicated
SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)

Group: General Forum Members
Points: 32888 Visits: 18560
I really don't like the questions about "best" practices for storage from MS. There is seldom enough information presented to properly answer those questions.

Sure, RAID10 offers better protection. RAID5 is cheaper. In discussions with EMC consultants as well as SQLIO sims you can get the same performance from both. If RAID5 is cheaper, you can add more disks and have more space in theory.

Case in point - at one client we had double the performance from RAID5 than the RAID10 (write and read were both better in SQLIO). Client could not afford to have RAID10 everywhere nor was there enough drive bays to compensate in favor of the RAID10.

If I had to use spinning disk then I would go RAID10 where possible. If I had the money I would use FusionIO not worry about the performance of the chosen array Wink.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

Perry Whittle
Perry Whittle
SSC-Insane
SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)

Group: General Forum Members
Points: 20280 Visits: 17244
The big advantage of Raid 10 is you can lose up to half the disks as long as no mirrored pair fail and the array will still operate, albeit with reduced performance.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
SQLRNNR
SQLRNNR
SSC-Dedicated
SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)

Group: General Forum Members
Points: 32888 Visits: 18560
Perry Whittle (1/11/2012)
The big advantage of Raid 10 is you can lose up to half the disks as long as no mirrored pair fail and the array will still operate, albeit with reduced performance.


Biggest part of the reason I would go with RAID10 if possible - protection.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

Steve Jones
Steve Jones
SSC Guru
SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)

Group: Administrators
Points: 63925 Visits: 19117
Raid 5 has performed great for me in many applications. Many apps where we weren't pushing the envelope on IOPS, and we had much of the needed data in RAM.

The issue with R5 is that you need a spare handy when one fails because the degradation of performance, and risk, go up dramatically.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Perry Whittle
Perry Whittle
SSC-Insane
SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)

Group: General Forum Members
Points: 20280 Visits: 17244
@SQLRNNR exactly, although if you were to lose half the drives performance would suck in a big way. Your data is still intact though.


@Steve Jones that is, unfortunately a disadvantage of the RAID5. Array rebuild times for R5 and R10 are also a consideration, with lower rebuild times R10 is often the favourite.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
Steve Jones
Steve Jones
SSC Guru
SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)

Group: Administrators
Points: 63925 Visits: 19117
Perry Whittle (1/12/2012)

@Steve Jones that is, unfortunately a disadvantage of the RAID5. Array rebuild times for R5 and R10 are also a consideration, with lower rebuild times R10 is often the favourite.


That's why you need a spare in the rack.

And if you do that, why not go with R10 then and slightly bigger drives? I've gambled on R5 in the past, but with today's capacities of drives, not sure I would anymore.

Side note: we started with R5 here in 2001, but when we purchased larger servers in 2005, we just went with multiple R1 arrays for protection since we were putting a spare drive in a 6 slot server, we just did 3 R1 arrays.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
mishradharmesh.2192
mishradharmesh.2192
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 5
RAID5 is good for DWH application for reading operation.
Go through below link
http://database.ca/blog.aspx?blogid=1024
Cool
GilaMonster
GilaMonster
SSC Guru
SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)

Group: General Forum Members
Points: 88779 Visits: 45284
Please note: 4 year old post

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


Chris Harshman
Chris Harshman
SSCertifiable
SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)

Group: General Forum Members
Points: 5000 Visits: 4010
GilaMonster (1/11/2012)
... RAID 5 has about the worst write performance of the common RAID levels because of the need to compute and then write parity...

I had asked for tempdb on RAID 10 once, and the hardware guys ended up putting it on RAID 6, when I reviewed write latency metrics I didn't know whether to laugh or cry.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search