Currently we got TEMPDB Data (number of data files:2) and LOG file on same drive.
On monitoring we have found I/O issues on TempDB.
We got an extra drive available – should we move the TempDB Log file to new drive or should we move the second TEMPDb data file on the new drive to help us reduce I/O issue?
Best Answer
If you're already certain you have IO contention, start by understanding which files are the cause.
With the data from that query you can judge whether the log or data files are the point of contention in tempdb. It's probable you'd be better off with both data files on one drive and the log file separate, but you'll never know without the numbers to back the decision.