Forum Discussion

RJNIMP's avatar
RJNIMP
Copper Contributor
Jan 31, 2021

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 SQL Managed Instance. So if we decide to move to managed instance, what are the benefits?

Is there any cost benefit too?

1 Reply

  • ibnmbodji's avatar
    ibnmbodji
    Steel Contributor
    Feb 01, 2021

    RJNIMP 

     

    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