SQL Server 2016 New Features – Multiple TempDB Files Configured at Server Install

Configuring multiple tempdb files is not a new feature in SQL Server and has been a best practice for sometime to help ease and prevent tempdb contention which helps to increase the scalability of your SQL Server installation.

Before SQL Server 2016, this was a task which needed to be carried out after the installation but one of the new features of SQL Server 2016 is the ability to configure this as part of the install process.

As you step through the installation and get to the point of Database Engine Configuration, there is a tab for tempdb where the configuration can be done.

New Feature of SQL Server 2016 configure multiple tempdb files

There is not a lot else to say about this really except that it’s another welcome new feature of SQL Server 2016! 🙂

About Andy Hayes

Andy Hayes is a DBA working with SQL Server since version 7.0. He has a wonderful wife and two beautiful children. He loves database technology, playing cricket, and blogging. He is passionate about sharing his experiences as a DBA and learning more to further his understanding and knowledge. You can follow me on Twitter, check out my Facebook page or follow me on

Speak Your Mind