Re: Optimal RAID configurations for relational databases

If the applications are particularly write-intensive, it may be appropriate to mirror a pair (for logs) and use RAID 5 for the rest . Of course, this will dedicate 40% of your DASD for fault-tolerance. For most apps, RAID 5 will perform adequately especially with the smaller, ultra-wide disks.

Hope this helps.

kbuttler_at_mcs.net wrote in message <74m72u$8ln$1_at_nnrp1.dejanews.com>...
>We are in the process of building several Compaq Proliant servers for both
 MS
>SQL 6.5 and Oracle 8.0 on NT. These servers both have a Compaq Smart 2DH
>Array Controller and five 4.3GB hard drives. We are in the middle of a
>heated debate with our DBA's on how these servers should be built (I'm on
 the
>NT side of things, so pardon my ignorance in relational databases)
>
>My question is this: Will we face a significant performance hit by using
 RAID
>5 across these five drives are is it better to use RAID 0 or RAID 1? Why?
>
>any input would be GREATLY appreciated!
>
>kevin.
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Dec 09 1998 - 00:00:00 CST