Solution

Adjust TempDB default settings:

  1. Create TempDB/Logs folders (if missing)
  2. Move the tempdb log file to the Log file drive (if needed)
  3. Calculate if there is enough disk space for an increase in tempdb files
  4. Analyze and compare the number of tempdb files based on Core up to 8 (create more if needed)
  5. Adjust size and growth (if needed)

Implementation

https://github.com/steverezhener/DBA/blob/master/Procedures/bestpractices.usp_optimize_server_tempdb.sql

Example

Disclaimer

This blog post was made possible using the following resources:

https://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-1230-tempdb-should-always-have-one-data-file-per-processor-core/#:~:text=On all later versions%2C including SQL Server 2012%2C,everyone apart from the official Microsoft guidance recommends.