SQL Server 2008 Hard drive considerations


I'm going to be setting up a new server soon and I have two choices to consider regarding the hard drive configuration.   For the data files, I need to use a RAID 5 array.  For the operating system and transaction log, I can either set up two separate mirrored volumes (one for OS and one for TL), or a RAID 10 volume for the both of them to occupy.  Suggestions?
Who is Participating?
pcelbaConnect With a Mentor Commented:
The bottleneck will be the RAID5. Then, from speed point of view, it is not relevant if you use RAID 10 or two mirrors. I would use two mirrors as physically separated storages.
it should be better that you plan different disks for os, data, log and temp
data disk should be raid 5 or raid 1+0 depending on your need and write performance..
log and temp disks should be raid 1
os disks depends on your hardware possible raid 1 or raid 1+0
ccwestbrookAuthor Commented:
What about using multiple RAID 1 volumes instead of RAID 5 or RAID 10 for the data files?
tigin44Connect With a Mentor Commented:
In my site I prefer using raid 1+0 for data files..
ccwestbrookAuthor Commented:
Thanks for the input.  I am going to go with a 6 disk RAID 10 volume for the data files, and two mirrored volumes for TL and OS.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.