Multiple tempdb files can be created during setup.
Here are a list of links that might help you learn more. Note that many of these are links to other sites and we cannot guarantee they still work. We also should note that some of these, especially Books Online, may change over time.
If you find broken links or think we should have more here, please leave a comment in the discussion for this article.
- Books Online - Multiple Tempdb Database Files
- SQL Server 2016 - Getting tempdb a little more right
- SQL Server 2016 First Look - Automatic Tempdb File Creation
- Managing Tempdb Creating in SQL Server: Tempdb Configuration (msdn)
- Tempdb Configuration - SQL Server 2016 Setup
- SQL Server 2016 CTP2: First Thoughts about tempdb database
Continue learning more about SQL Server
View the index of features for the various versions.
