TEMPDB Sizing

• jsqldba

  SSChampion

  Points: 11257

  More actions

  July 6, 2001 at 8:45 am

  #77843

  What's the best way to size TEMPDB? Perfmon lets you monitor % Log used and Database size, but not % use don the database. Ou TEMPDB is 2GB for some reason. I was thinking to resize it to something fairly small, say 200-500MB, and set auto-growth on.

  Thanks

  Jay

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  July 6, 2001 at 10:24 am

  #416950

  Unless you're short on disk space, I wouldnt sweat the size. Definitely keep auto grow on. We had a recent thread along similar lines:

  http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=499&FORUM_ID=5&CAT_ID=1&Topic_Title=Recommended+TempDB+Size&Forum_Title=Administration

  Andy

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter