Forum Discussion
Azure SQL Managed Instance vs SQL Server in Azure VM
When we have migrated to Azure due to MSDTC limitation in SQL Managed Instance, decided to use SQL Server running in Azure VM. It looks like there is a public review available for MSDTC feature in S...
Hi below some benefits of using SQL server managed instance :
- 99.99% uptime Service Level Agreement (SLA)
- Azure AD authentication and single sign-on support (SSO)
- Automated back-ups and backup retention
- Automated patching and and version updates
- Built-in high availability (HA)
- Point-in-time database restore capability
- Threat detection (alerts)
- Cost Effective
However since the ability to coordinate distributed transactions is a preview feature i would suggest to wait it's Generala Availability to migrate for production use . Check also the limitations before implementing .
https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-transactions-overview