Are there benefits specific to SQL Server on Azure VM when using the SQL Server Data Files in Windows Azure feature? Aka using Azure blob storage container for database files versus an Azure VM data disk which itself is backed by Azure storage page blob?
The MS docs SQL Server data files in Microsoft Azure encourage the use of this feature with SQL on Azure VM but don't make clear a compelling advantage compared to using an Azure managed data disk.
The listed benefits apply to both forms of Azure storage AFAIK.
Are there any benefits specific to SQL on Azure VM?
Why use SQL Server data files in Microsoft Azure?
- Easy and fast migration benefits
- Cost and limitless storage benefits
- High availability and disaster recovery benefits
- Security benefits
- Snapshot backup
This new feature uses Page blobs, which are more efficient when ranges of bytes in a file are modified frequently.
Per MS docs, Introduction to Azure managed disks
Azure managed disks are stored as page blobs, which are a random IO storage object in Azure. We call a managed disk ‘managed’ because it is an abstraction over page blobs, blob containers, and Azure storage accounts.