Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

This question already has an answer here:

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?

share|improve this question

marked as duplicate by Max Vernon, Marian, RolandoMySQLDBA, Paul White, Michael - sqlbot Jan 31 '14 at 12:37

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

If 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 -… - will be of help, I'm sure. – Marian Jan 28 '14 at 22:08
up vote 4 down vote accepted

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:

Brent Ozar disk reading

TempDB best practice by people smarter than me

SQL Server Central forum chat

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.