Results 1 to 8 of 8
  1. #1
    Join Date
    Mar 2004
    Posts
    1

    Unanswered: Which Raid to configure

    Hello,
    I run a small homw office. I am planning to purchase a dell powerdge 1750 server to install SQL server on that.
    I am confused here about which RAID should I install on this server RAID 1 or RAID 5.
    The dell customer rep could not tell me the advantages of installing only RAID 1 or only RAID 5 or installing both RAID 1 and RAID 5

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    Raid 1 is disk mirroring
    Raid 5 is disk striping with parity

    Raid 1 has good overall performance and good fault tolerance but is costly to impliment.
    Raid 5 is good for reads and slow for write with okay fault tolerance but is ecinomical to impliment.

    <stolen from SQL Server 2K PErformancing Tuning>

    I personally would go with Raid 5 for a home setup.
    Paul Young
    (Knowledge is power! Get some!)

  3. #3
    Join Date
    Mar 2004
    Posts
    45
    You have a server rack at home?

    As 1750 can only hold 3 disks, it is not a good choice for SQL Server unless you add external storage.

    Better for performance and fault-tolerance to use no less then 4 disks and then use 2 as RAID 1 for OS, program files and SQL log files, and other 2 as RAID 1 for SQL data files.

  4. #4
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    however if you only have room for internal storage I would suggest RAID 5 for the extra disk space.
    Paul Young
    (Knowledge is power! Get some!)

  5. #5
    Join Date
    Sep 2003
    Location
    Columbia, MD USA
    Posts
    95
    Originally posted by Paul Young
    however if you only have room for internal storage I would suggest RAID 5 for the extra disk space.
    I'd agree with that... just about anything will be fine if you're just running a small database and if you're getting a 1750, then RAID5 with 3 drives will give you the most space for the least amount of money (along with some redundancy). Even if you add an external enclosure RAID5 would more than likely be fine.

    The only time RAID5 isn't fine is in a VERY write intensive setting, a good controller will buy you alot of performance with RAID5 also...
    drew
    ------------------
    http://wjtechnologies.com

  6. #6
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Useful article by Micheal Otey http://www.winnetmag.com/SQLServer/A...9697/9697.html about RAID levels.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  7. #7
    Join Date
    Mar 2004
    Posts
    45
    Originally posted by Satya
    Useful article by Micheal Otey http://www.winnetmag.com/SQLServer/A...9697/9697.html about RAID levels.
    Useful how? Read the comments.
    Hans.

  8. #8
    Join Date
    Mar 2004
    Posts
    45
    Do not choose RAID level and number of disks based on capacity but instead on required performance. 3 drive RAID 5 on an otherwise powerful dedicated database server will bottleneck on the disk channel. Even if all databases fit in memory, you will still feel this during checkpoints.

    With appropriate array controller RAID 1 with 2 drives will read as fast and write faster then RAID 5 with 3 drives. 3 drives in a database server never makes sense. For only a little more money one can buy 4 drives and set up correctly with same capacity so don't buy a SQL Server that can only hold 3 drives.

    Do you have a nearly full server rack at home? Why give up disk bays for small form factor unless rack space is primary concern?
    Hans.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •