TempDB Size

• Brad Griffin

  Mr or Mrs. 500

  Points: 510

  More actions

  April 2, 2012 at 5:37 pm

  #254075

  Hi

  Is there a Best Practice in sizing the TempDB depending on the size of the associated production database's?

• sqlnaive

  SSCoach

  Points: 17437

  More actions

  April 3, 2012 at 1:31 am

  #1468034

  Here are few useful links:

  http://technet.microsoft.com/en-US/library/ms345368(v=SQL.90).aspx

  http://technet.microsoft.com/en-US/library/ms175527(v=sql.90).aspx

  http://msdn.microsoft.com/en-us/library/ms190768.aspx

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  April 3, 2012 at 1:50 am

  #1468038

  Not really. Best thing to do would be a full load test on a dev/test server (with production data volumes) and see how big TempDB needs to be.

  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