Instant File Initialization : Impact During Setup

Published On: March 11, 2016

Categories: tempdb, Windows, Disk Performance 0

SQL Server 2016 allows you to enable instant file initialization during installation; Aaron Bertrand (@AaronBertrand) looks at how this can impact tempdb data file creation.

Continue reading... is about providing innovative and practical solutions for improving SQL Server performance. Whether you are running a 3rd party application database where very little can be changed, or you are a DBA at a site where getting the application developers to change anything is next to impossible, industry experts including Paul Randal, Jonathan Kehayias, Erin Stellato and Paul White will cover both the "how" and the "why."


Fighting Downtime and Slowdowns