How to check Instant File Initialization is enabled or not in Azure SQL Server

user_5093602 0
Viewed 211

I want to check Instant File Initialization is enabled or not in Azure SQL Server.

I have tried like this:

exec xp_readerrorlog 0, 1, N'Database Instant File Initialization'

but I got an error:

Could not find stored procedure 'xp_readerrorlog'.

I also tried with the dynamic management view sys.dm_server_registry, but this also throws an error:

Invalid object name 'sys.dm_server_registry'.

So help me out...

azure-sql-server azure-sql-database sql-server
1 Answers

Database Instant File Initialization is not available on Azure SQL Database as is shown in this documentation.

SQL Server instances running on an Azure VM can make use of the ability to clear a range of bytes in a page blob, provided by the Put Page API, to make instant log initialization a reality. For more information, please visit this blog.

user_81841390
Related