Solved

RAID Level for SQL 2000 & 2005 MDF files.

Posted on 2008-10-28
2
525 Views
Last Modified: 2010-07-27
I know that best pratices is to put the LOG (.LDF) files on a RAID1 configuration, but what about the DATA (.MDF) files.  Is it okay to put it on the second channel in RAID1 as well? Or is it better to have RAID5 on the second channel for the .mdf file? What do you have to say? Please provide you thoughts and aso any links to published documentation.  

Thank you very much and have a great day.
0
Comment
Question by:BygRob
2 Comments
 
LVL 32

Accepted Solution

by:
Daniel Wilson earned 500 total points
ID: 22822300
Raid5 would be better (at least if you're getting much WRITE activity)  ... but Raid1 sure beats no RAID !

Raid1 increases READ performance, but hurts WRITE performance.  RAID 1-0 is great, but many controllers won't handle it.  RAID 5 is pretty good on READ, WRITE and the basic -- redundancy.  And most controllers support it.
0
 
LVL 26

Expert Comment

by:lnkevin
ID: 22823399
Is it okay to put it on the second channel in RAID1 as well?

RAID 1 only supports 2 drives. If you create 2 RAID 1, why don't you create one RAID 10? As you know, RAID 10 offers the best performance and redundancy. You can separate OS, logs, and data by partition.

RAID1 VS RAID 5?

Raid 1 (for 2 drives or 10 for more than 2 with even number of drives) offers more read and write performance compares to RAID 5. Check this Bench Mark Chart for both read and write on the two RAIDs:
http://blogs.sun.com/mrbenchmark/entry/raid_1_vs_raid_56

Bottom line, RAID 5 is NOT the best choice for performance wise, RAID 1 or 1+0 is. However, RAID 5 offers affordable storage space with a decent performance. For database system with heavy transaction, RAID 10 offers best performance, but if you are short on budget, you only need to put the logs on RAID 1 (for heavy write purpose) and the entire database can be on RAID 5 since there is not much WRITE transaction on the .MDF part. If you put it on RAID 1 or 10, you would have increased the read performance by a little, not much.

K

0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now