What type of Raid to use on Windows Servers and tempdbs?

Tags:
RAID
RAID 1
RAID 10
SQL Server database design and modeling
Windows Server 2003
I have a SQL Server with eight disks, and I am not sure if I should use Raid 10 twice, one for Windows Server 2003 with NDFs and the other for the log file and tempdb, or apply Raid 1 for the Windows Server, Raid 10 for the NDF and MDF, and Raid 1 again for the tempdb and log. What would you suggest?
ASKED: October 24, 2008  4:52 PM
UPDATED: October 25, 2008  12:04 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

It all depends on the load your are expecting on the system.

You effectively have 6 disks to work with. You need two for a RAID 1 array for Windows and the SQL Server binaries and the page file. You may simply want to do three RAID 1 arrays. One for data files, one for log files and one for tempdb. Without knowing more about the system I can’t make a solid recommendation.

This <a href=”http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1262122,00.html”>article</a> may help guide you.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following