Notes on SQL

Random articles from a puzzled DBA


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.


Microsoft Learn – Instant File Initialization

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: