SQL Server Performance

New Setup Questions...

Discussion in 'Performance Tuning for Hardware Configurations' started by kb9coupe, Feb 16, 2007.

  1. kb9coupe New Member

    OK. Which setup would you choose ?

    3 possible setups:
    (1)
    8 drives raid 10 data files
    2 drives raid 1 tempdb
    2 drives raid 1 all tranlogs

    (2)
    4 drives raid 10 data files
    4 drives raid 10 tempdb
    4 drives raid 10 all tranlogs

    (3)
    4 drives raid 10 data files
    4 drives raid 10 tempdb
    2 drives raid 1 tranlog for biggest db
    2 drives raid 1 tranlog all other dbs

    DB is used mostly for 'everything' read:write ratio is 8:1
    I'm looking for opinions esp. on performance..
  2. Luis Martin Moderator

    How big is DB?
    The disks are 10K or 15K?
    Is sql server dedicated?



    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



  3. kb9coupe New Member

    Disks are 15K.
    Main DB with most traffic (90%+) is 50GB
    Other 10 or so low traffic DBs are another 50GB or so.
    Server is dedicated to one instance on SQL Server (nothing else)

    I guess the main question is how much speed, if any do I gain/loose be moving from RAID 1 to RAID 10 for tran logs and/or temp db. (1 vs 2)

    Also, how much speed do I gain from splitting log for main db from others (ex. 3)

    As the side note.. TempDB (2 datafiles) and TempDBLOG will be on same, separate drive.
  4. Luis Martin Moderator

    I'll wait for Joe, but if I have to choose I think in 1).

    BTW: I've moved to relevant forum.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



  5. joechang New Member

    10 disks for all data, temp, other log
    2 disks for main db logs

    VERY VERY IMPORTANT
    the advice is NOT separate data and logs: as in multiple logs on one array
    you lose the benefits of very fast sequential writes to disk if there is more than 1 load.
    the advice is each busy log needs its own dedicated drives

    this is actually only true if you want to support > 200 very low latency writes/sec
    in some circumstance, you don't need to

    also, this makes it difficult to do database consolidation, as too many drives would be required for logs
    i think ssd needs to be investigated for many busy db on 1 server

Share This Page