I have summarized a few rules for this:
1. Rebuilt tempdb after each reboot which gives it a sufficiently initial size.
2. tempdb is often accessed and outsourcing to another drive.
Script to move the tempdb files.
ALTER DATABASE tempdb
MODIFY FILE (NAME = tempdev, FILENAME =, E: DATAtempdb.mdf ');
MODIFY FILE (NAME = templog, FILENAME =, E: Datatemplog.ldf ');
3. Give it a sufficient capacity and leave it to grow on automatic.
4. Disable the Automatic Update.Read more: https://dzone.com/articles/how-to-optimize-tempdb-in-sql-server
Powered by IDERA