Overview
In previous articles I wrote about how you check that Instant File Initialization (IFI) is set, and how to set it. At the time, it was not available for the Log file. This has now changed.
New in SQL 2022
Now, with SQL Server 2022 IFI will also work when a log file is extended by an autogrowth event that is set to 64Mb or less, maker the extension of the log file a far quicker process.
As 64Mb is the default size for log file autogrowth, you may want to consider leaving it that. Otherwise, you might need to compare the advantages of a larger growth event (but zero-filled – you can’t prevent that) against several smaller, ‘instant’ autogrowth events.
Notes on SQL 