Worth Corner, Crawley, RH10 7SL

Support Hours - Mon-Sat, 8.00-18.00

Welcome to our SQL Server blog

This blog was created in order to pass on some of our knowledge and advice in the hope that the community might find it useful.

Obviously Microsoft SQL Server is our area of expertise and therefore this is our most thorough blog with everything from the basic through to the the incredibly advanced and, as such, we should have something for everyone within our pages.

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.

SQL  World  CEO
Kevin  Urquhart

iPhone Selfie

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


© Copyright 2020 SQLTraining Ltd.