SQL Server Performance

Disadvantage of this Config

Discussion in 'Performance Tuning for Hardware Configurations' started by mcosy, Apr 3, 2008.

  1. mcosy New Member

    HI All,
    Please tell me the disadvantage of this following config for SQL server.
    Controller 1 : OS : RAID 1 : 2 x 72GB
    Controller 2 : LOG : RAID 1 : 2 x 146GB
    Controller 2: Data / temp/ bkp : RAID 10 : 4 x 300GB


    mcosy, Apr 3, 2008
    #2

  2. Luis Martin Moderator

    Except tempdb (to me in 2) sound good to me.
    Luis Martin, Apr 3, 2008
    #3

  3. melvinlusk Member

    What Recovery Model are you using for your DB's? If it is in full recovery mode, putting tempdb on the same drive as the log file may cause some high disk queues. If you're using simple mode, the log volume probably makes more sense.
    Mel
    melvinlusk, Apr 3, 2008
    #4

  4. mcosy New Member

    HI,
    Thanks, But According to Joe Chang articles distributing IO load over as many spindles (diskdrives) and IO channels is the way to get more performace isn't it?
    And also not selecting bigger drives 300GB?
    mcosy, Apr 7, 2008
    #5

Share This Page