SQL 2016 Install Sets Multiple TempDB Files
Published: May 07, 2017
This is something that I’ve been hoping would make an appearance in SQL Server at some point, and also why I included my last post about tempDB contention. It’s the ability to choose the number of tempDB files during install rather than having to add them yourself at a later date.

This will be a very short post as, once you’ve read my last post and the related links it includes, you’ll not need too much more information, this is more just to let you know that tempDB file configuration is now included as part of the install.

So here it is:

And once installed, you can see that the tempDB files show as expected.

The only thing that hasn’t changed though, and which you would still need to change post-install is the fact that they are still both created as 8MB in size and they are set to 10% autogrow.

But other than that, it’s still good that they’ve added it to the install now so that there’s much less messing around required than in older versions, and the fact that it’s mentioned means that people might wonder why (if they don’t know already) and learn about the potential benefits of multiple tempDB files.
Leave a Comment
Your email address will not be published. All fields are mandatory.
NB: Comments will only appear once they have been moderated.

Your SQL Trainer
Kevin Urquhart

I am a SQL Server DBA, Architect, Developer, and Trainer for SQL Training. This is my blog in which I’m simply trying to share my SQL knowledge and experiences with the world.

Kevin Urquhart
SQL Server Consultant, London



Copyright © 2018 London SQL Server Training Courses @ SQL Training | Website Design From Scott Heron