Skip to main content
Database Administrators

Return to Question

Question does not pertain to SQL language, removing SQL tag.
Source Link
Jack Douglas
Jack Douglas
  • 40.2k
  • 15
  • 104
  • 177

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.

Regards?

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.

Regards

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?

Question does not pertain to SQL language, removing SQL tag.
Link
edit approved Oct 23, 2011 at 15:45
Shannon Severance
edit approved Oct 23, 2011 at 15:45
Shannon Severance
  • 125
  • 1
  • 6
Tweeted twitter.com/#!/StackDBAs/status/127687340859723776
Post Migrated Here from stackoverflow.com (revisions)
Source Link
Conrad Jagger
Conrad Jagger

SQL Server - Tempdb data/log file placement

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.

Regards