Database Reference
In-Depth Information
policy (using Group Policy Editor gpedit.msc or Local Group Policy Editor
secpol.msc), as shown in
Figure 6.4
. We strongly recommend this setting be applied in
group policy, especially when AlwaysOn Availability Groups are used or when there
are multiple databases that will have this setting enabled.
Figure 6.4
Enabling the Perform Volumes Maintenance Tasks security policy.
After you have made this change, you will need to restart your SQL Server services for
it to take effect. We recommend you make this setting a standard for all your SQL
Server databases and include it in your base template.
Note
Instant File Initialization (IFI) is only used for data files and Temp DB
files. Even when IFI is configured and active, it will not be used for
transaction log files. Transaction log files will continue to zero out every
block when they are created or extended. This is due to the internal
structure of the transaction log file and how it is used for data protection
and recovery operations. This makes it even more important for you to
proactively manage your transaction log files to prevent any avoidable
