SQL Server Performance

SQL Server 2000 install RAID level and partitions?

Discussion in 'Performance Tuning for Hardware Configurations' started by macgyver24x7, Mar 20, 2005.

  1. macgyver24x7 New Member


    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)
    1GB RAM
    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?

  2. derrickleggett New Member

    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 />derrickleggett@hotmail.com<br /><br />When life gives you a lemon, fire the DBA.

Share This Page