SQL Server can take advantage of IFI to reduce the time that needs for SQL Server to grow the data base file.
To enable this, we need to grant the “perform volume maintenance task” under gpedit
We only see sql server is zeroing out the log file
This apply to the tempdb as well.
Other scenario that will not instant initialization the file:
1. Remove the permission from security policy
2. Use trace flag 1806
3. Turn on the TDE
4.Create database snapshot
5. DBCC CHECKDB