TempDB Resizing/Reconfig is broken

DC-AC / SQL2016_Scripted_Install

Automated install and best practices application for Microsoft SQL Server 2016

12 stars 17 forks source link

TempDB Resizing/Reconfig is broken #6

Open AirborneGeek opened 8 years ago

AirborneGeek commented 8 years ago

In its current form, it resizes the existing file to whatever the max size for the DB is supposed to be.

I've got a fix for this written, but I'm going to piggyback some other changes to the TempDB area with it.

jdanton commented 8 years ago

Removed TempDB Max Size to address bug. Will debate on best practice for max file size--current will just fill up volume, which I think is ok for tempdb. Unless we come up with a smart calc for volume size based on TempDB and number of files. Testing now.