For many reasons I only have 3 hard drives (RAIDed and in an Always-On AG) for all my database files:
- D: Data
- E: Logs
- F: Tempdb
Should the tempdb log file go on F: with the data file(s) or on E:?
My tempdb data file has the highest stalls by far, with the log file 4th out of 24.
In my limited DBA experience (I'm a developer) I would lean to putting the tempdb.ldf on E: as the writes will all be sequential.