TempDB on C:\ drive

• swaroop.sahoo

  SSChasing Mays

  Points: 617

  More actions

  November 23, 2011 at 7:44 am

  #247385

  Hi All,

  Server Structure:

  Sql Server 2008 R2

  C: SCSI Drive (Server's Drive)

  D: SATA

  E: SATA

  F: SATA

  The Temp DB is on C: as it is faster than the SATA drives. On the other hand putting tempDB in windows drive is also not advisable.

  Can anybody suggest whether moving tempDB from SCSI drive to SATA will improve the performance as it won't be the window's drive.

  Thanks,

  swaroop

• Devendrakumar

  SSC-Forever

  Points: 42493

  More actions

  November 23, 2011 at 7:47 am

  #1412204

  No need to create duplicate threads.

  http://www.sqlservercentral.com/Forums/Topic1211025-1550-1.aspx