How big does Tempdb need to be?

Question

TempDB should be sized based on the size of the drive it's on (and it should be on its own drive). Generally speaking you should have one TempDB file per CPU core (up to 8) and one TempDB_Log file. So. divide total space on the drive by (number of CPU cores + 1). 9 окт. 2019 г.

What should be TempDB size?

FileLogical nameInitial sizePrimary datatempdev8 megabytesSecondary data filestemp#8 megabytesLogtemplog8 megabytes

How many files do you need for TempDB?

Tempdb installs with just one data file and one log file by default.

What is the maximum size of TempDB?

Starting from SQL Server 2016, the installation wizard automatically detects the CPU cores and creates the necessary number of database files for the TempDB. It also sets the maximum growth of individual files to 64 MB.

What are the best practices for TempDB?

What are some of the best practices for TempDB?Do not change collation from the SQL Server instance collation.Do not change the database owner from sa.Do not drop the TempDB database.Do not drop the guest user from the database.Do not change the recovery model from SIMPLE.Tempdb Configuration Best Practices in SQL Server - MS SQL Tips

Expert · Answer