Re: Optimal RAID configurations for relational databases

From: Neil Pike <100577.553_at_compuserve.com>
Date: 1998/12/09
Message-ID: <VA.000007fb.0034791a@neilpikeport.itops.natwestuk>#1/1

Kevin,

With only 5 disks it's a difficult one. You'll probably find a single raid-5 is best.

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

Neil Pike MVP/MCSE. Protech Computing Ltd (Please post ALL replies to the newsgroup only unless indicated otherwise) For SQL FAQ entries see www.ntfaq.com/sql.html and http://www.swynk.com/friends/hotek/articles/sqlserverfaq.asp and GO MSSQL lib 1 on Compuserve Received on Wed Dec 09 1998 - 00:00:00 CST