Tempdb disk

• sqlfriend

  SSC Guru

  Points: 52781

  More actions

  February 14, 2013 at 5:50 pm

  #268652

  We have a tempdb disk on a sperated disk from other databases. It is on a SAN drive with random I/O

  I know it is a good practice to create multiple files for temdpb the same number as cores if less than 8 cores on the server.

  But is it still beneficial to performance if it is a random I/O disk instead of sequential I/O

  Thanks

• e4d4

  SSCertifiable

  Points: 5777

  More actions

  February 15, 2013 at 12:25 am

  #1588207

  I don't know about what you ask?

  So "A SQL Server DBA myth a day: (12/30) tempdb should always have one data file per processor core"

  http://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-1230-tempdb-should-always-have-one-data-file-per-processor-core/

• Life is too short

  SSC Journeyman

  Points: 82

  More actions

  February 15, 2013 at 9:28 am

  #1588381

  The need of mutiple files is to reduce contention on certain key system pages in the data file.

  I must admit that as a habit I dont create these extra files unless there is an issue. Too many shops wont know what to do if things start going wrong so why add unnecessary chaff that will distract from the actual issue?

• Igor Micev

  SSC-Dedicated

  Points: 33109

  More actions

  February 16, 2013 at 12:29 pm

  #1588620

  See this http://www.simple-talk.com/sql/database-administration/optimizing-tempdb-configuration-with-sql-server-2012-extended-events/

  Igor Micev,My blog: www.igormicev.com