Post reply

TempDB .ldf and .mdf files question.

  • March 25, 2009 at 1:37 pm

    #130138

    Is it ok to have the TempDB .ldf and TempDB .mdf on the same drives ?

    Or should it be on the same drive as the database log files ?

    I have split the Database .ldf and .mdf onto different drives and split the TempDB into one file per single processor core.

    I also have the program files on their own drive.

    Thanks

  • March 25, 2009 at 2:04 pm

    #966269

    In the ideal world, I think the best bet is to have the tempdb files separated from each other and separated from the database files as well (basically each file has its own drive or set of drives therefore no worries about sharing of IO at the disk level). But obviously that is not always possible, given budgetary constraints etc..

    But I would try to keep things as separate as possible. And if you can not do that, try benchmarking the IO patterns on your databases and see which ones are being hit the hardest. If you see that your Database data file is consistently using up the most IO, put as many drives under it as you can and separate is from the other files. If tempdb is the one using up the most IO, do the same for it.

    Separate is better, but the more information you have going in to designing the disks under your DB's the better.

  • March 25, 2009 at 2:13 pm

    #966277

    Thanks !

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

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