TempDB configuration

https://www.brentozar.com/archive/2016/01/cheat-sheet-how-to-configure-tempdb-for-microsoft-sql-server/

  • 1 volume for all tempdb files
  • Use SSDs
  • 8 equally sized files
  • Size them and log file to fill up the tempdb drive

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.