SQL Server with Mr. Denny

Mar 22 2011   2:00PM GMT

Why can’t I just use RAID 10 for everything?

Denny Cherry Denny Cherry Profile: Denny Cherry

In a perfect work, you would use RAID 10 for everything.  However we don’t work in the perfect world, we have budgets to deal with.  And these budgets mean that we have to make sacrifices at times so we don’t get what we want.

RAID 10 is very expensive to implement, much more so per gig than RAID 5 or RAID 6, especially if there are a lot of disks in the RAID array.  If the database doesn’t specifically need more performance than the RAID 5 array can provide, then using a RAID 10 array is just a waste of money.  And that money is money that could be used for other projects that the company is trying to complete.

In the real world that we all work in (or at least most of us) performance comes at a cost, and those costs have to be controlled.  If you need RAID 10, and you actually need it, and you’ve got the budget for it, then use it.  Otherwise use something less expensive.  If you aren’t sure if you need RAID 10 or not, start with a lower level such as RAID 5 or RAID 6, and if needed switch up to RAID 10.

Denny

2  Comments on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Unclebiguns
    Denny, Being a storage novice, how much downtime/effort goes into switching from Raid 5/6 to Raid 10?
    0 pointsBadges:
    report
  • Denny Cherry
    In a DAS a lot as you'll have to rebuild the array. In a SAN none, it can be moved in the background with no inturption of service.
    66,360 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: