Temp DB size for optimal performance

• Gangadhara MS

  Hall of Fame

  Points: 3377

  More actions

  November 22, 2010 at 9:22 pm

  #226915

  Dear All,

  How to monitor the temp DB size.

  One of my production database is using lots of temp table and if the temp DB is limited in size that could be the bottle neck.

  How do i check the best temp db size for production server and any related tempdb recommendations for optimal performance.

  Thanks,

  Gangadhar

• Brigadur

  SSCrazy

  Points: 2097

  More actions

  November 23, 2010 at 4:02 am

  #1254309

  Hi,

  These links explains it:

  Troubleshooting Insufficient Disk Space in tempdb

  Capacity Planning for tempdb

  Cheers