Optimal RAID configurations for relational databases

From: <kbuttler_at_mcs.net>
Date: 1998/12/09
Message-ID: <74m72u$8ln$1@nnrp1.dejanews.com>#1/1

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