3

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...

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Chanukya
  • 5,833
  • 1
  • 22
  • 36

1 Answers1

1

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.

Alberto Morillo
  • 13,893
  • 2
  • 24
  • 30