• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 308
  • Last Modified:

Best Disk configuration for sql server

what is the best disk configuration for SQL 2000?

Database is 10GB

OS  --  Raid 0, 0+1, 1+0, 5
Data -- Raid 0, 0+1, 1+0, 5
Logs -- Raid 0, 0+1, 1+0, 5

I'm not too concerned about performance while in a degraded state, i.e one drive fails.

I need SPEED...

And most importantly, why choose any one raid over the other.
1 Solution

RAID 5 is pretty quick

I would make 2 containers in the hardware RAID manager.

Container 1:  OS   8GB
Container 2: SQL Rest of RAID space

Keep the data and the logs together, don't want the server writing data all over the place.

For an explaination on RAID,  check this out:  http://www.sohoconsult.ch/raid/raid5.html

I would just suggest RAID 5, sure performance is shot if a drive fails, but it's faster than RAID1 and less vulernable than RAID0.   RAID 0+1 is quick, but you pay a pretty penny for it.  Plus RAID 5, you can do with 3 drives, RAID 0+1 require more drives (4 or more).

If money is no problem you should go with RAID 10

Here is a explanation about RAID:


Go with Hardware RAID 5. If you lose a drive, simply plug in a new one and let the controller rebuild the new drive. It's a fast operation and you shouldn't have to reboot the server.  And if you can, off load the database9s) to a seperate server.  

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now