Optimize Tempdb in SQL Server

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 ');

GO

ALTER DATABASE tempdb

MODIFY FILE (NAME = templog, FILENAME =, E: Datatemplog.ldf ');

GO

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