x

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
more ▼

asked Nov 15, 2012 at 10:14 AM in Default

Troy_2012 gravatar image

Troy_2012
750 24 36 39

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first
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.
more ▼

answered Nov 15, 2012 at 10:43 AM

Tim gravatar image

Tim
36.4k 36 41 139

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.
Nov 15, 2012 at 11:10 AM Tim
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.
Nov 15, 2012 at 11:40 AM ThomasRushton ♦

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.
Nov 15, 2012 at 11:53 AM Tim
3 disk can not make up a RAID 10 (1+0) configuration. Check out this article
Nov 15, 2012 at 11:57 AM Tim
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.
Nov 15, 2012 at 03:01 PM Tim
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1948
x13
x9

asked: Nov 15, 2012 at 10:14 AM

Seen: 638 times

Last Updated: Nov 15, 2012 at 07:21 PM