<div>
question back to you:<br />
<br />
WHAT ITS GOT TO DO WITH SQL SERVER?
</div>


question back to you:

WHAT ITS GOT TO DO WITH SQL SERVER?

<div>
Heh<br />
<br />
Good question.<br />
<br />
This array will &quot;house&quot; our SQL 2000 data, with two SQL Servers Active-Passive connected to it.<br />
<br />
Thanks for the question.<br />
<br />
John
</div>


Heh

Good question.

This array will "house" our SQL 2000 data, with two SQL Servers Active-Passive connected to it.

Thanks for the question.

John

<div>
<div class="content wysiwyg-content">
The hardware had been purchased when i arrived here. &nbsp;It's a Dell Powervault with 13 73 Gig drives.<br />
<br />
My bosses want:<br />
<br />
- fault tolerance<br />
- fault tolerance<br />
- fault tolerance<br />
- fault tolerance<br />
- fault tolerance, and, of course,<br />
- fault tolerance.<br />
<br />
And they want it to be fast too.<br />
<br />
What would be the best way to configure these drives to provide both. Had a bad experience with a single point of failure web server on Friday - one drive in a four drive RAID 5 array crashed and the thing just wallowed while it compensated.r<br />
<br />
Originally, the vision for this array was 10 drives RAID-5. &nbsp;We're wondering now if that is the best route. &nbsp;Another opinion here is two mirrored RAID 5 volumes of 5 drives each.<br />
<br />
What is the best way to configure this so that the failure of one drive doesn't bring drag our enterprise into the mud?<br />
<br />
John
</div>
</div>


The hardware had been purchased when i arrived here.  It's a Dell Powervault with 13 73 Gig drives.

My bosses want:

- fault tolerance
- fault tolerance
- fault tolerance
- fault tolerance
- fault tolerance, and, of course,
- fault tolerance.

And they want it to be fast too.

What would be the best way to configure these drives to provide both. Had a bad experience with a single point of failure web server on Friday - one drive in a four drive RAID 5 array crashed and the thing just wallowed while it compensated.r

Originally, the vision for this array was 10 drives RAID-5.  We're wondering now if that is the best route.  Another opinion here is two mirrored RAID 5 volumes of 5 drives each.

What is the best way to configure this so that the failure of one drive doesn't bring drag our enterprise into the mud?

John

How to best configure 13 drive array for SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.