Post reply

Ms sql 2000

  • July 22, 2009 at 7:24 pm

    #203078

    Need your inputs guys...

    I'm planning to upgrade my hardware and my configuration will be:

    RAID 10 = for db.mdf

    RAID 0 = for db.ldf

    RAID 0 = for tempdb

    any additional configurations or suggestions will be much appreciated...

  • July 23, 2009 at 4:27 am

    #1028840

    RAID 10 for your data looks good.

    RAID 0 has no redundancy - so if a disk goes pop (they eventually will), you will lose the database as it contains the LDF.

    How about a RAID 1 mirrored pair for your logs?

  • July 23, 2009 at 6:53 pm

    #1029400

    Ok thanks for your inputs... i think same with tempdb will do go for raid1

  • July 23, 2009 at 8:57 pm

    #1029429

    Herbie (7/23/2009)

    Ok thanks for your inputs... i think same with tempdb will do go for raid1

    TempDB doesn't need any redundancy... it get's rebuilt every time you reboot.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • July 24, 2009 at 8:46 pm

    #1030103

    Ok that's a very well information. thanks!

Viewing 5 posts - 1 through 4 (of 4 total)

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