RAID 5 and Performance Degradation Concerns
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: RAID 5 and Performance Degradation Concerns

  1. #1
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367

    RAID 5 and Performance Degradation Concerns

    Dear All

    My manager (not a DBA) has put together a spec for a new disk array (Hewlett Packard XP 1024) on which we'll be running our 600GB OLTP database (64bit 8i and HP-UX 11i) and has asked for my opinions. My most immediate concern, and one which I've mentioned to him, is that it only has RAID level 1 or 5. Now we definitely need some hardware level striping so RAID 5 is our only option. I'm no storage expert, but understand that Oracle and RAID 5 is generally percieved to be a bad idea on a write heavy application due to the maintenance of parity information. He's responded that HP claim that on this array RAID 5 performs just as well as RAID 0+1 (my preferred option, we currently have an EMC Symmetrix and utilise this). I'm meeting some HP reps on Monday and want to grill them on this, but I was wondering if anybody out there has any practical experience with Oracle and this product, or any opinions on HPs claims.

    Any guidance would be much appreciated.

    Thanks

    Austin

  2. #2
    Join Date
    May 2003
    Location
    Pretoria, Rep of South Africa
    Posts
    191
    I will quote from the Oracle 9i bible(Performance Tuning Tips and Techniques)....p.65

    "Raid 1+0 This level provides mirrored disks and striping. This incorporates the advantage of the first two RAID levels by providing the disk I/O benifit of RAID0 to the redundancy provided by RAID1.For high read/write environments such as OLAP,where sporadic access to data is the norm, this RAID level is recommended".

    and

    "RAID5 ...It is a low-cost solution that is inefficient for write-intensive applications."

    --If you can get the book over the weekend read chapter 3.--
    Able was I ere I saw Elba

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    No matter what HP says about RAID 5, it will hurt perf for an OLTP system.

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    Re: RAID 5 and Performance Degradation Concerns

    Originally posted by hacketta1
    He's responded that HP claim that on this array RAID 5 performs just as well as RAID 0+1 (my preferred option, we currently have an EMC Symmetrix and utilise this).
    Tell them to put up or shut up. Have them give you two boxes to evaluate, one configured with RAID 1+0 and the other with RAID 5 and run your application on them. If there's no difference, go with the RAID 5.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    One more test you can do.

    When DB is running, ask the HP guy to pull out 2 disks randommly selected in the striped set, and now you see your DB is up and running. Or the disk array itself is crashed.

    Tamil

  6. #6
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    Thanks for your responses. I like the idea of doing some tests of my own; not sure if they'll agree though. One thing I'm thinking is that the array will have at a minimum an 8GB cache, so if this could be configured as write-only it may go someway to circumventing the RAID-5 write penalty.

    Something else that's vexing me is that it apparantly this thing has a minimum stripe size of 9GB. Again, I'm no expert in these things but I can't really see how this would help eliminate hot-spots.

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by hacketta1
    I like the idea of doing some tests of my own; not sure if they'll agree though.
    We eval stuff all the time. If they don't like the idea, tell them you are looking at adding some EMC arrays...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

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



Click Here to Expand Forum to Full Width