Adrian has a look at the performance benefits of instant file initialisation https://www.youtube.com/watch?v=b6NE-ipzLbQ&feature=youtu.be Below is Ade's auto growth script... DECLARE @trcfilename VARCHAR(1000) ; SELECT @trcfilename = path FROM sys.traces WHERE is_default = 1 SELECT StartTime , DB_NAME(DatabaseID) AS DatabaseName , FileName, SUM(( IntegerData * 8 ) / 1024) AS [Growth (MB)] , ( Duration /... Continue Reading →