I've run a myriad of RAID setups over the years. In fact, I haven't had a system where I wasn't running a RAID array for over four (4) years now. With the exception of my servers, where I only run RAID 1 (or "Mirroring"
because of the nature of an SQL server, I have always run RAID-0 (or "Striping"
for speed.
Contrary to some opinions, software RAID is a joke. Sure, there are some extremely old or ultra low-end solutions that may not perform any better, but that's extremely rare. Software RAID is a last resort solution because of poor performance and zero-reliability, unless running RAID-1, but I'm assuming you're looking for enhanced performance and storage.
There are a number of considerations when deploying a RAID array, even if it is in your home PC. First, all of the drives in the array
should be
identical makes and models. Mixing and matching creates problems and hinders performance, in which case you're better off just spanning. Second, you cannot RAID your system drive if you're using software RAID. WinNT/2K will only allow you to RAID non-system drives/partitions because the OS has to be available to implement SW RAID first, which means it has to be installed on a normal drive/partition. Third, if you're running SCSI, almost all of the off-board controllers come with secondary RAM caches so the larger the better. I am running both SCSI and IDE RAID (in two different systems). The computer I use most has IDE RAID-0 using a cacheless Promise FastTrak 100TX with four (4) IBM 40GB 60GXP 7200RPM drives which performs exceptionally well. There is no better cost/performance solution than four fast drives like the 60GXPs or the new Western Digital WD800BBs and the FastTrak 100. You will max out your practical PCI Bus throughput with this configuration. Do
NOT get the cached or "Pro" version of the FastTrak 100 as the RAM cache actually hinders throughput and makes it perform
worse than its cacheless sybling.
If you're running SCSI, the RAID controllers are substantially more expensive. I have a Mylex AcceleRAID 352 dual channel U160 SCSI RAID controller in one of my other workstations with eight (8) 36.4GB 10K RPM Seagate Cheetahs and the thing flies. The system is a dual PIII 1GHz system with 64-bit 66MHz PCI slots that double the PCI Bus throughput from 133mB/sec to 266mB/sec (theorhetically) and I can just about max out that bus with a burts transfer over a 1000SX fiber connection.