SQL Server 2000 install RAID level and partitions? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL Server 2000 install RAID level and partitions?

Hi, I’m getting ready to install SQL Server 2000. Here are specs of the server: Dell PowerEdge 2850
Dual 2.8GHz Intel Xeon CPUs (hyper-threaded)
RAID controller: Dell PERC 4e/DI
disks: (4) 73GB (Maxtor Atlas 10K Ultra320 SCSI) For using four disks, how do you recommend I create the RAID arrays, what RAID levels, and how to split up the arrays and partitions before installing SQL Server 2000? Also, I’ve read a couple recommendations about staying away from RAID-5 for SQL Servers. What do you think about this? thanks!

How much load is this server going to have?<br />What other applications will be running on here? (Is it also a web server, for example, with IIS?)<br />What version of SQL Server?<br /><br />1GB of RAM and 4 disks aren’t a lot to work with. On the disks, you might want to go with two RAID 1 groups. However, if the database is large size and low on writes, a RAID 5 configuration might be fine for you. It really depends on the operational requirements for the box. Make sense?<br /><br />There’s nothing bad in having RAID 5 for SQL Server IF it meets all the needs you have for that particular installation. That’s like saying screwdrivers are bad. <img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br /><br />MeanOldDBA<br />[email protected]<br /><br />When life gives you a lemon, fire the DBA.