New SQL Server, RAID Planning

We are installing a new SQL server. Right now, I am planning to get 10
drives:
2 - RAID 1 [Mirror] : OS
4 - RAID 10 [Mirrored Stripes] : SQL DB
4 - RAID 10 [Mirrored Stripes] : SQL Logs
There would be a dedicated controller for the OS and one dedicated two
channel controller for the SQL sets.
From everything I have been reading, this is an ideal setup for a new SQL
server.
Is there any reason to consider creating one large eight drive RAID 10 or
RAID 5 for both SQL DB and the logs? Or possibly run six drives in a RAID
10 for SQL DB and then two drives RAID 1 for the log files?
Any other considerations?
Thank You,
Kevinyou want the logs to be on RAID 1+0
Data best on RAID 1+0 also.
Your setup looks good to me.
Greg Jackson
PDX, Oregon|||Hi Kevin
You generally don't get much from striping the log unless you have an app
that tends to read the log heavily for rollbacks or transactional
replication. So your second suggestion to have 6 drives in RAID10 config and
RAID 1 for log files may have more merit as you'll get the benefit of having
more physical drives to perform the regular data file read / write activity.
You'd still get the redundancy you're after on the log with RAID1 but you'd
be giving the extra spindle to the main data array where it's probably
needed more.
Regards,
Greg Linwood
SQL Server MVP
"Kevin Hammond" <kghammond@.nrscorp.com> wrote in message
news:c6jnf2$gfo$1@.grandcanyon.binc.net...
> We are installing a new SQL server. Right now, I am planning to get 10
> drives:
> 2 - RAID 1 [Mirror] : OS
> 4 - RAID 10 [Mirrored Stripes] : SQL DB
> 4 - RAID 10 [Mirrored Stripes] : SQL Logs
> There would be a dedicated controller for the OS and one dedicated two
> channel controller for the SQL sets.
> From everything I have been reading, this is an ideal setup for a new SQL
> server.
> Is there any reason to consider creating one large eight drive RAID 10 or
> RAID 5 for both SQL DB and the logs? Or possibly run six drives in a RAID
> 10 for SQL DB and then two drives RAID 1 for the log files?
> Any other considerations?
> Thank You,
> Kevin
>sql