Posted by Tony Rogerson on 12/02/06 13:38

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?
>

• Next in forum: Re: Oracle Sequence/Link 2 MS SQL SERVER 2005
• Prev in forum: Re: Oracle Sequence/Link 2 MS SQL SERVER 2005
• Thread view: Re: Table Partitioning on a RAID 5 Server

[Reply to this message]