Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
1  
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 - sqlbits.com/(S(ckin5tat3ut34q55gkgc32eo))/Sessions/Event5/… - will be of help, I'm sure. –  Marian Jan 28 at 22:08
    
add comment

marked as duplicate by Max Vernon, Marian, RolandoMySQLDBA, Paul White, Michael - sqlbot Jan 31 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.

1 Answer

up vote 3 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
add comment

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