Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Steve Jones Tempdb defaults in SQL Server 2016 RE: Tempdb defaults in SQL Server 2016
Brian.Klinect
Mr or Mrs. 500
Points: 592
More actions
July 29, 2016 at 7:12 am
#1892631
Not the most intuitive location for this information, but the "Install SQL Server 2016 from the Command Prompt" instructions lists the defaults of all the switches, including tempdb initial size/growth.
https://msdn.microsoft.com/en-us/library/ms144259.aspx