SQL HD Setup

[PU36]

I currently have 8 drives

(2) 73GB SAS 15K
(6) 146GB SAS 15K

I was planning on mirroring the OS on the two 73GB drives, however I'm s not exactly sure how to setup the other 6 drives to work best with SQL 2005.

I can RAID-5 Disk 3-5 for the SQL DB, then RAID-5 Disk 6-8 for the transactions logs.

OR

I can RAID-10 (or RAID-50) all the drives together.

Any recommendations?

 

[jpm121]

Transaction logs shouldn't be in RAID 5, since logs are sequential writes, I'd go for another RAID 1 for the logs and create a 4 drive RAID 5 for the data (or 3 drives and keep 1 as a hot spare).

 

[mrdenny]

Magnum,
This FAQ faq962-5747 is a good place to start.

As is this article.

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1262122,00.html

(I'm biased, I wrote both of them.)

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog