sqlnIGHTS.COM

My Sql Server info repository

SQL2016 TempDB

SQL2016 TempDB Configuration

Prior to sql2016, during the installation process, there was no option to configure tempdb in accordance with Microsofts’ best practice guidance advice. The setup phase created a single tempdb datafile and you had to add more if you needed to after the installation.

Now with sql2016 we have options during the setup phase. SQL Servers setup will auto detect the number of cores you have and allocate an appropriate number of Tempdb files accordingly upto a maximum of 8 if you have 8 cpu cores. This hopefully will remove tempdb related waits such as PAGEIOLATCH.

Below is a screen shot of the setup phase for Tempdb:

tempdb-setup2016

I think this is a great option and something long over due – It should make sql server more responsive from day 1 !