Post reply

Data & log files for application dbs, system dbs, and tempdb

  • May 16, 2012 at 5:42 pm

    #392277

    I'm understanding that it's highly recommended putting the tempdb on a separate array from the application dbs and system dbs, but does this mean to separate the tempdb.mdf from the temp.ldf, as well?

    If I had E:\, F:\ & G:\ to work with, how would you separate the files? Would this be the best option?

    E:\ - *.mdf's (all application & system dbs) & tempdb.mdf

    F:\ - *.ldf's (all application dbs, master, model & msdb)

    G:\ - tempdb.ldf

    Or should I put the tempdb.mdf on G:\ as well??

    Thanks for your input.

  • May 16, 2012 at 5:47 pm

    #1488746

    Typically, I see more activity in tempdb data files than in the log file. So if I have to choose, I put the tempdb data files on their own array. Sometimes, I put the log file on that same array with the data files.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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