question

Troy_2012 avatar image
Troy_2012 asked

SQL SERVER with RAID

Dear all If we have a server with [8] hard disks,and If we made [2] hards RAID 1+0 (c:) what is the best practice for the other hard disks (6) for SQL Server. 3 hard disks (d:) RAID 1+0 , 3 Hard disks(e:) RAID 1+0 install SQL on C: put the data file on d: and T-log on e: any Idea
sql-server-2005hard-disksraid
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Tim avatar image
Tim answered
It all depends on your I/O requirement. Best practice is to separate your data files and log files due to sequential vs random I/O, however if you are going to have multiple log files on the same drive then your sequential writes become more random. It all comes down to speed, size and protection that you are going for. I would personally go with a RAID 1 for C: and then RAID 6 for the secondary drive. SQL on C and Data and Logs on D. Again though, it depends on the work load, size of the data, etc.
19 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

RAID 5 with two partitions provides no benefit other than two drive letters, it is the same number of spindles and does not provide any additional I/O benefit.
3 Likes 3 ·
I thought you needed an even number minimum of 4 disks for RAID 1+0, being a combination of striping & mirroring... I could, of course, be mis-remembering.
2 Likes 2 ·
WIth the low storage requirement and with 700 GB 15k drives, you would be better off with RAID 1 with 4 drives. C, D, E and F. OS and SQL install on C, tempdb data on a drive, tlogs on a drive and data files on the other. Just make sure you have a spare 700 GB 15k on hand in the event of a failure, you don't want to lose a drive and have to wait a couple of days for vendor X to send you a replacement.
2 Likes 2 ·
3 disk can not make up a RAID 10 (1+0) configuration. Check out this [article]( http://www.thegeekstuff.com/2010/08/raid-levels-tutorial/)
2 Likes 2 ·
Awesome, it has been a lot of fun helping you on here. Have a great day. Also if I have answered your questions to help you out, please mark them as the answer in your post by checking the accept button next to your question. That helps me get more creditability on this site and lets others know you have been answered. You also build extra karma (points) as well. It is good for all.
2 Likes 2 ·
Show more comments

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.