SQL 2016 – It Just Runs Faster: Automatic TEMPDB Configuration


Moved from: bobsql.com

 

Various KBs, whitepapers and blogs have outlined the need for the creation of multiple, TEMPDB files, same sized files, trace flags and the like.   All of these configuration options increase the scalability of your SQL Server.

 

In an effort to simplify the tempdb configuration experience, SQL Server 2016 setup has been extended to configure various properties for tempdb for multi-processor environments. 

 

A new tab dedicated to tempdb has been added to the Database Engine Configuration step of setup workflow. Configuration options:

Data Files

Number of files – this will default to the lower value of 8