Multiple temp db files

• atulyan.aries

  SSCrazy

  Points: 2020

  More actions

  January 22, 2015 at 5:32 am

  #145652

  Hi Team,

  What is the advantage of adding multiple temp db files, also is there any specific number that can be added ex 10,20 etc.

  can someone please share their experience on this

  Thanks

• dbafromthecold@gmail.com

  SSChampion

  Points: 10160

  More actions

  January 22, 2015 at 5:46 am

  #1772169

  Here's a survey performed by SQL SKills on Tempdb configuration.

  http://www.sqlskills.com/blogs/paul/tempdb-configuration-survey-results-and-advice/

  It's also got some good advice on what configuration you should use