Post reply

High Disk I/O performance

  • November 24, 2008 at 9:27 pm

    #124972

    Hi,

    can anyone tell me a better configuration for better I/O performance.

    Single RAID configuration (RAID 10) with large number of disks

    or

    Multiple RAID configurations with small number of disks

    (I have 25 Disks to use)

    which one is better..??

    Thank you

  • November 24, 2008 at 10:26 pm

    #902890

    Personally, I prefer multiple volumes, as long as they are all Raid 10.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

  • November 25, 2008 at 11:17 am

    #903327

    Multiple separate RAID arrays is best. The log and data files should be physically isolated from one another.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply