Home > IT Answers > SQL Server > Where to place the tempdb log file?
SQL Server Ask the Experts
2,585 pts.
 Where to place the tempdb log file?
MDF, NDF, SQL Server, TempDB
I've heard it recommended to place the tempdb on its on own drive. Regarding the tempdb log file specifically, should it be on a different disk than the mdf or ndf files of the tempdb?

Software/Hardware used:
ASKED: April 10, 2009  6:11 PM
UPDATED: April 13, 2009  1:28 PM
RELATED QUESTIONS
Answer Wiki:
This depends on the kind of load that you will be putting the tempdb database under. If you are using all very small transactions then you won't get much benefit from putting it on it's own drive. However if you are doing lots of large transactions and moving lots of data into the tempdb at one time then having the ldf on it's own drive can improve performance.
Last Wiki Answer Submitted:  April 11, 2009  6:56 am  by  Denny Cherry   64,505 pts.
All Answer Wiki Contributors:  Denny Cherry   64,505 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _