Does Azure SQL support IFI - Instant File Initialization

Question

Does Azure SQL support IFI - Instant File Initialization. In another post, someone answered that is not supported in Azure Managed Instance. https://learn.microsoft.com/en-us/answers/questions/457488/instant-file-initialization-ifi-with-sql-mi.html

Answer 1

Hi @JK , welcome to Microsoft Q&A forum.

Database Instant File Initialization is only supported in SQL Server and not supported on Azure SQL Managed Instance and Azure SQL. This is also highlighted in the documentation.

You can read more in the below article:

How to manage & measure database file autogrowth impact on Azure SQL Managed Instance

Please let us know if this helps or else we can discuss more on this.

----------

If answer helps your query, you can mark it 'Accept Answer'

Answer 2

Following up on this, with the release of SQL Server 2022, instant file initialization (IFI) was introduced for transaction log file growth events up to 64 MB. This benefit was also added to Azure SQL Database.

So, now IFI does apply to Azure SQL Database, but not for data files. Azure SQL Database only benefits from IFI for transaction log file growth events <=64 MB.

https://learn.microsoft.com/en-us/sql/relational-databases/databases/database-instant-file-initialization