Solved

RAID Level for SQL 2000 & 2005 MDF files.

Posted on 2008-10-28
2
513 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
Comment Utility
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
Comment Utility
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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

744 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

13 Experts available now in Live!

Get 1:1 Help Now