tempdb per processor cores?

• sumith1andonly1

  SSCrazy

  Points: 2250

  More actions

  January 14, 2013 at 10:13 pm

  #287955

  Any perfromance difference in these type of configuration?

  How we can set these ?

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  January 14, 2013 at 11:10 pm

  #1577150

  In which types of configuration?

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events

• sumith1andonly1

  SSCrazy

  Points: 2250

  More actions

  January 14, 2013 at 11:26 pm

  #1577153

  tempdb per processor cores configuration.

  is there any relation in

  "number of processor core " = "number of tempdb files"?

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  January 15, 2013 at 1:20 am

  #1577169

  http://www.sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-%281230%29-tempdb-should-always-have-one-data-file-per-processor-core.aspx

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• sumith1andonly1

  SSCrazy

  Points: 2250

  More actions

  January 15, 2013 at 1:26 am

  #1577171

  thanxs