How big should my TempDB be?

Question

The recommended practice is to keep files and the initial space required for each file to be roughly 80 to 90% of the volume on which the TempDB is stored. The 10 to 20% disk space is left for OS-based virtual memory. 23 окт. 2018 г.

What should be TempDB size?

FileLogical nameInitial sizePrimary datatempdev8 megabytesSecondary data filestemp#8 megabytesLogtemplog8 megabytes

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.

How do I increase my TempDB performance?

You can further increase tempdb performance by disabling the auto update stats, which will save your tempdb some work. Usually objects created in the tempdb are fairly small and, as such, the statistics will not reach the threshold that causes the statistics to update automatically.

How is TempDB calculated?

The short version: configure one volume/drive for TempDB. Divide the total space by 9, and that's your size number. Create 8 equally sized data files and one log file, each that size. Presto, the drive is full and your TempDB is configured for easy performance.

Expert · Answer