Results 1 to 14 of 14
  1. #1
    Join Date
    Jan 2004
    Posts
    25

    Unanswered: MSSQL 2005 on which RAID?

    We have a new DL380 G5 server with 6 x 146GB 10K SAS 2.5 DP HDD.

    We will be installing Windows Server 2003 and then MSSQL 2005 for one of MS Dynamics ERP

    I would like to know if RAID 10 configuration is good for this? if not what is the best?

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Depends on a few things. You'll have C for binaries, and ideally at least a drive for logs (assuming this is OLTP) and one for data. In a perfect world, you have another for files and one for tempdb. I don't live in a perfect world

    RAID 5 is good read performance, poorish write (four reads per write IIRC). RAID 5 performs poorly during rebuilds, and when a drive is lost. But it is cheaper. http://www.miracleas.com/BAARF/RAID5_versus_RAID10.txt

    RAID 10 is the ideal - performant and good redundancy.

    If write performance is critical, then RAID 10. If not (e.g. you load data overnight and just read during the day) then RAID 5 is adequate IMHO.

    It is worth noting I'm not that strong on hardware.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jan 2004
    Posts
    25
    Quote Originally Posted by pootle flump
    Depends on a few things. You'll have C for binaries, and ideally at least a drive for logs (assuming this is OLTP) and one for data. In a perfect world, you have another for files and one for tempdb. I don't live in a perfect world

    RAID 5 is good read performance, poorish write (four reads per write IIRC). RAID 5 performs poorly during rebuilds, and when a drive is lost. But it is cheaper. http://www.miracleas.com/BAARF/RAID5_versus_RAID10.txt

    RAID 10 is the ideal - performant and good redundancy.

    If write performance is critical, then RAID 10. If not (e.g. you load data overnight and just read during the day) then RAID 5 is adequate IMHO.

    It is worth noting I'm not that strong on hardware.
    Making all our 6 x 146GB to RAID 10 will get me 438GB HDD space, which is more than enough for our OS, DB, etc.,

    So you suggest to go with RAID 10?

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    It is not that simple.

    You would typically want your data files, log files and binaries all on separate physical disks.

    Data file use typically results in random IOs. Log file use typically results in sequential IO. As such, log files on their own disks are ideal - the disk heads are then not flying around all over the place. A single RAID 10 of 438GB sounds great at first, but the activity of logs, data and binaries will interfere with each other with performance consequencies.

    If you pushed me I'd say one volume RAID 1 (binaries and logs) and one RAID 10 (data), but as I say I'm not a hardware guy. I would gather more opinions.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Jan 2004
    Posts
    25
    I have got suggestion from other forum...

    Option 1:
    1) Use 2 x 146GB HDD as RAID 1 and install the OS in it
    2) Use 3 x 146GB HDD as RAID 5 for MSSQL, Log and tempdb

    Option 2:
    1) Use 2 x 146GB HDD as RAID 1 and install the OS in it
    2) Use 4 x 146GB HDD as RAID 10 for MSSQL, Log and tempdb

    Any comments, suggestions?

  6. #6
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Option 1 is pointless unless saving a drive is a goal. RAID 10 > RAID 5.

    As stated, I would go for option 2 BUT I would put logs on the RAID 1 OS volume, NOT the RAID 10 volume.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  7. #7
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by smartcard
    I have got suggestion from other forum...
    Pls could you post links to any other forums this is on?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  8. #8
    Join Date
    Jan 2004
    Posts
    25
    Quote Originally Posted by pootle flump
    Pls could you post links to any other forums this is on?
    http://www.petri.co.il/forums/showth...732#post136732

  9. #9
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    The three RAID 1 suggestion is the best separation of everything (binaries, logs & data all separate) but you lose the speed advantage of the stripe in the RAID 10 configuration. You also lose disk space for data.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  10. #10
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by pootle flump
    Option 1 is pointless unless saving a drive is a goal. RAID 10 > RAID 5.
    Sorry - I forgot you could get more usable space with RAID 5, so if that is a goal then it could be an option.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  11. #11
    Join Date
    Jan 2004
    Posts
    25
    Quote Originally Posted by pootle flump
    Sorry - I forgot you could get more usable space with RAID 5, so if that is a goal then it could be an option.
    I I think we can do the following :

    OS on RAID 1 with 1 hot spare = 3 drives
    DB and others on RAID 5 = 3 drives

  12. #12
    Join Date
    Jan 2004
    Posts
    25
    I have gone through this post http://www.tek-tips.com/faqs.cfm?fid=5747

    So in any case the OS will be on RAID 1 where we will put the Binaries too.

    The rest [db, log, tempdb] will be on a RAID 10 or RAID 5.

    I prefer RAID 10 by allocating 4 x 146GB drives, but I will get 292GB space which I feel okay for me.

  13. #13
    Join Date
    Dec 2007
    Location
    London, UK
    Posts
    741
    Physical Database Storage Design
    http://www.microsoft.com/technet/pro...hysdbstor.mspx

    Storage Top 10 Best Practices
    http://www.microsoft.com/technet/pro...ge-top-10.mspx

    and last but not least...
    http://www.baarf.com/

  14. #14
    Join Date
    Aug 2008
    Location
    India
    Posts
    55
    RAID 10 - for better read and writes - Log files and tempdb

    RAID 1 - Database data files

    Separate disk drives for Operationg system file , Database file , DB log files and Tempdb will perform better

Posting Permissions

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