Do I want to store the tempdb log files on the same drive as my user database log files, the same drive as the tempdb data file, or on a separate drive?
-
1If you have enough distinct disks/LUNs available, then I'd say: get your TempDB on separate disk/LUN, with data files on a disk/LUN and log file on a separate disk/LUN. This presentation - sqlbits.com/(S(ckin5tat3ut34q55gkgc32eo))/Sessions/Event5/… - will be of help, I'm sure.– MarianCommented Jan 28, 2014 at 22:08
-
dba.stackexchange.com/questions/7009/…– Cougar9000Commented Jan 29, 2014 at 1:42
Add a comment
|
1 Answer
It depends on how many disks you have available, how active your databases are going to be, and how much data work tempDB will see. In our environments we put tempDB on its own disk and size it out, with the log file lumped in with the user log files and have not had any issues. Of course, monitor for contention and keep an eye on everything. Here are some links for further reading:
answered Jan 29, 2014 at 1:54
