SQL 2016 – It Just Runs Faster: Instant File Initialization

Moved from bobsql.com


Database Instant File Initialization was added several SQL Server releases ago.   The instant file initialization feature scales the creation and expansion (growth) of database, DATA files.    The ‘Manage Volume Privilege’ option is off by default preventing many SQL Server installations from taking advantage of the feature.


SQL Server 2016 Setup provides the option to enable ‘Perform Volume Maintenance Task’ privilege to the SQL Server Service SID. This privilege enables instant file initialization by avoiding zeroing of data pages.  For security and performance considerations see Database Instant File Initialization topic.


For Failover Cluster instance, each node will be configured individually for