Skip Navigation

TempDB (system) database configuration

  • Ensure that there are four data files. Each file should have an initial size of 1GB and a maximum size set to Unrestricted.
  • Ensure that there is one log file. The log file should have an initial size of 512 MB and a maximum size set to 2 GB.
  • Set Update Statistics: True in Database properties.
  • At least 8 GB must be available on the storage array to allow for the TempDB to grow as needed by SQL Server.
The number of Data files and log files is the same regardless of the number of CPU’s.