If the number of drives is fixed, then I would put SQL and the log files on the RAID...> I'm building a new SQL 2000 server. I typically use HP DL380... will have 4 300 GB drives in a RAID 5. Three of the drives will make up the RAID 5 and the forth will be an online spair. SQL will be installed on the RAID 5 (D:). Is this configuration ok? Is there a prefered way ...

..., PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada .....com... Hi, What would this configuration do for performance? I'm ... better performance. Also, if 2 drives fail in RAID 5, you're... Moreau, BSc, PhD, MCSE, MCDBA SQL Server MVP Toronto, ON Canada ... I'm building a new SQL 2000 server. I typically use ... RAID 5 (D:). Is this configuration ok? Is there a prefered ...

....com... Hi, What would this configuration do for performance? I'm not... better performance. Also, if 2 drives fail in RAID 5, you'... Moreau, BSc, PhD, MCSE, MCDBA SQL Server MVP Toronto, ON Canada ... I'm building a new SQL 2000 server. I typically use ... will be an online spair. SQL will be installed on the ... RAID 5 (D:). Is this configuration ok? Is there a prefered ...

... better performance. Also, if 2 drives fail in RAID 5, you'... Moreau, BSc, PhD, MCSE, MCDBA SQL Server MVP Toronto, ON Canada ... I'm building a new SQL 2000 server. I typically use...will have 4 300 GB drives in a RAID 5. Three...of the drives will make up the RAID 5 and the...will be an online spair. SQL will be installed on the...RAID 5 (D:). Is this configuration ok? Is there a prefered...

... better performance. Also, if 2 drives fail in RAID 5, you'... Moreau, BSc, PhD, MCSE, MCDBA SQL Server MVP Toronto, ON Canada ... I'm building a new SQL 2000 server. I typically use ... will have 4 300 GB drives in a RAID 5. Three of the drives will make up the RAID 5 and the ...will be an online spair. SQL will be installed on the...RAID 5 (D:). Is this configuration ok? Is there a prefered...

Hi. I'm building a new SQL 2000 server. I typically use HP DL380 machines with split backplane. SCSI controller one .... SCSI controller two will have 4 300 GB drives in a RAID 5. Three of the drives will make up the RAID 5 and the forth will be an online spair. SQL will be installed on the RAID 5 (D:). Is this configuration ok? Is there a prefered way to set ...

.../browse_frm/thread/62f3a348a1635bfb/940933bc778feab9?lnk=st&q=&rnum=1&hl=en#940933bc778feab9 -- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada . "Ron" <fdskljfoiewiorewuokdvsfds@FI74as32etwIOtrFewDS.com> wrote in message news:%%23QV38$E$GHA.3952@TK2MSFTNGP03.phx.gbl... Tom Moreau ...

Tom Moreau wrote: RAID5 requires more I/O due to having to do parity. It gets worse the more disks you have. I thought the more RAID5 HDs you have the faster the performance becomes. I swear I read (or heard) it somewhere but can't remember where :-(

.../tonyrogerson - technical commentary from a SQL Server Consultant http://sqlserverfaq.com...phx.gbl... Thanks for the recomendation. Drive C and D are...in SQL 2005 is more heavily used but even in 2000...24/958.aspx) -- Tony Rogerson SQL Server MVP http://sqlblogcasts.com...best possible performance. Which RAID configuration is better for the data...

....phx.gbl... Thanks for the recomendation. Drive C and D are ... in SQL 2005 is more heavily used but even in 2000 ...24/958.aspx) -- Tony Rogerson SQL Server MVP http://sqlblogcasts.com...tonyrogerson - technical commentary from a SQL Server Consultant http://sqlserverfaq.com...best possible performance. Which RAID configuration is better for the data...