Post reply

creating a new database - best practice

  • January 19, 2006 at 3:14 am

    #90448

    It's a long time since i've had to do this.  Please can someone tell me the best practice recommendations regarding location of data and log files e.g should they be on the same drive, different drives, etc?

     

    Thanks

  • January 19, 2006 at 3:48 am

    #615730

    Separate arrays is best

    Raid 1+0 array for data and mirrored for your log files

    try and avoid raid 5 arrays if you can (write overhead is costly)

    also place your tempdb on a seperate array

    place backup files on a seperate array to you rmain MDF (data files) to reduce risk

    many people missundertsand this advice and make 3 partitions on a single array - no performance benefit in this as they still share spindles and controllers

    if you can afford it - make the mirroring of the arrays across 2 controllers rather than 2 channels of the same controller (then if a controller dies you still have access to the data)

    MVDBA

  • January 19, 2006 at 6:57 am

    #615773

    thanks for the advice.

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

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