Ideal TempDB size for 32 cores ?

• isuckatsql

  SSChampion

  Points: 10381

  More actions

  November 2, 2011 at 11:41 am

  #247271

  I have four 8-core processors and from what i have read, you should have one TempDB file for each core.

  I have my TempDB on a 136GB RAID1, so i use all of it for the 33 TempDB files ?

  32 TempDB data files

  1 TempDB log file (what size should this be?)

  Thanks

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  November 2, 2011 at 11:44 am

  #1402326

  isuckatsql (11/2/2011)

  ---

  I have four 8-core processors and from what i have read, you should have one TempDB file for each core.

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

  As for size - as large as it needs to be for the activity and usage of your database server.

  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