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?
Asked
Active
Viewed 755 times
7
Jon Seigel
- 16,882
- 6
- 44
- 84
user33486
- 83
- 3
-
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 - http://sqlbits.com/(S(ckin5tat3ut34q55gkgc32eo))/Sessions/Event5/Designing_I_O_systems_for_SQL_Server - will be of help, I'm sure. – Marian Jan 28 '14 at 22:08
-
http://dba.stackexchange.com/questions/7009/sql-server-tempdb-data-log-file-placement – Cougar9000 Jan 29 '14 at 01:42
1 Answers
4
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:
Cougar9000
- 1,538
- 1
- 13
- 29