Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Location
    Mexico
    Posts
    1

    Unhappy Unanswered: Disk Stripping vs Data & Index separation

    Im working with People Soft Financials module V7.5. Were running on Sybase V12.5 in HP-UX V11 with two fiber channels and several disks using RAID 0,1.

    HP recommends using disk stripping and we implemented.

    However I think we might have a performance improvement if we stop using the striping and use the following approach: Separate indexes in one channel, data & log in the other, and tempdb in both channels.

    What do you think? Any know reference available?

    Thanks

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524

    Wink

    You can mix the both recommendations

  3. #3
    Join Date
    Apr 2003
    Posts
    18

    Re: Disk Stripping vs Data & Index separation

    Originally posted by gaacs
    Im working with People Soft Financials module V7.5. Were running on Sybase V12.5 in HP-UX V11 with two fiber channels and several disks using RAID 0,1.

    HP recommends using disk stripping and we implemented.

    However I think we might have a performance improvement if we stop using the striping and use the following approach: Separate indexes in one channel, data & log in the other, and tempdb in both channels.

    What do you think? Any know reference available?

    Thanks
    Hi,
    I think fadace is correct. You should keep the log and the tempdb on seperate disks if possible and donot place the data devices on the disk having log devices. And on top of that try to divide the data devices accross disks to get better I/O performance.

    What I would do --

    disk 1,2,3,4 for data exclusive
    disk A -- Log devices(Exclusive)
    disk B -- Tempdb(exclusive)

    Hope this helps.

    DB

Posting Permissions

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