Posted by rcamarda on 12/02/06 18:34

Tony,
I like to use RAID 10 when I can, much faster than 5.
Are you saying that even thou there is a single logical drive that the
raid controller built, there is a difference at the windows level when
we create seperate O/S logical drives? Or, are you refering back to the
Raid 5 vs. Raid 1??
I'd like to clarity on this point as I am going to building new
servers.
Tony Rogerson wrote:
> RAID 5 should be no where near a database server now-a-days; use RAID 1 or
> preferably RAID 10.
>
> Each file spawns a thread out to the OS so yes there is benefit; you have to
> be aware that the two threads will be doing async io so on a poor io
> subsystem or one that is loaded you can actually hurt performance by doing
> it.
>
> --
> Tony Rogerson
> SQL Server MVP
> http://sqlblogcasts.com/blogs/tonyrogerson - technical commentary from a SQL
> Server Consultant
> http://sqlserverfaq.com - free video tutorials
>
>
> <justin.merth@gmail.com> wrote in message
> news:1165001018.950900.59520@f1g2000cwa.googlegroups.com...
> > Is there any benefit in creating seperate file groups for a partitioned
> > table on a multi-processor server with RAID5 and 1 Logical Drive?
> >

[Back to original message]