SQL Server Performance

Disk/RAID configuration....again!!

Discussion in 'Performance Tuning for Hardware Configurations' started by frozenwaste, Feb 4, 2004.

  1. frozenwaste New Member

    Hi,

    I am currently building a new server for a SQL2000 DB which is around 30Gb in size and expected to grow to about twice this size. I have looked at implementing the following configuration, does this look okay? Or are there some glaring errors here?

    Array A: 2x72Gb RAID1 - OS
    Array B: 2x72Gb and Array C: 2x72Gb spanned to create RAID10 - data files
    Array D: 2x72Gb RAID1 - Transaction Log files
    Array E: 1x72Gb RAID0 - Tempdb
    Array F: 1x72Gb RAID0 - Backup file (this is backed up via Tivoli to our SAN)

    There will also be two standby hot spare 72Gb drives supporting the above.

    Thanks.
  2. bradmcgehee New Member

    That's a "dream" configuration, and ideal one that most people can't afford to implement.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  3. Luis Martin Moderator

    Indeed.


    Luis Martin
    Moderator
    SQL-Server-Performance.com
  4. frozenwaste New Member

    Thanks, one other quick question, what's the best way to configure the above giving that the RAID controller has two channels on it?
  5. Luis Martin Moderator

    My oppinion:
    One channel for Data and log, other for rest.


    Luis Martin
    Moderator
    SQL-Server-Performance.com
  6. sr66uk New Member

    Hello All,

    I have a similar config as frozenwaste, but with 8 x 146Gb 10K U320 drives, on a dual channel raid card. I need to achieve upto 500Gb DB and on a very strict budget.
    Unfortunately I am now confused,

    An external source has suggested 2 x Raid10 arrays with one for OS and LOGS the other DB, but on following the forums and articles on this site, surely it would be better to seperate logs from os and sql.
    Personally I would have used 12 x 73Gb 15k discs,
    1 x Raid1, OS,SQL
    1 x Raid1, Logs
    1 x raid5 across 7 discs, 1 x HS, DB. This is roughly what I use for my exchange server.

    My question really is: Do I agree with our consultant?
    You guys seem to be very SQL as I'm not I hope you could help. Need to get this right first time.
    Would be very grateful for suggestions

    SR
  7. satya Moderator

    We achieved similar performance by keeping OS & Logs on same RAID on one of our services, but this purely depends on the application whether its an OLTP or a normal application. I would suggest you to go with article listed in this site and get the optimum results.

    Is it a third party application or in-house developed?

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page