Azure SQL Managed Instance vs SQL Server in Azure VM

%3CLINGO-SUB%20id%3D%22lingo-sub-2109534%22%20slang%3D%22en-US%22%3EAzure%20SQL%20Managed%20Instance%20vs%20SQL%20Server%20in%20Azure%20VM%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2109534%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20we%20have%20migrated%20to%20Azure%20due%20to%20MSDTC%20limitation%20in%26nbsp%3BSQL%20Managed%20Instance%2C%20decided%20to%20use%26nbsp%3B%20SQL%20Server%20running%20in%20Azure%20VM.%20It%20looks%20like%20there%20is%20a%20public%20review%20available%20for%20MSDTC%20feature%20in%26nbsp%3BSQL%20Managed%20Instance.%20So%20if%20we%20decide%20to%20move%20to%20managed%20instance%2C%20what%20are%20the%20benefits%3F%3C%2FP%3E%3CP%3EIs%20there%20any%20cost%20benefit%20too%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2109750%22%20slang%3D%22en-US%22%3ERe%3A%20Azure%20SQL%20Managed%20Instance%20vs%20SQL%20Server%20in%20Azure%20VM%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2109750%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F718697%22%20target%3D%22_blank%22%3E%40RJNIMP%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20below%20some%20benefits%20of%20using%20SQL%20server%20managed%20instance%20%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3E%3CSPAN%3E99.99%25%20uptime%20Service%20Level%20Agreement%20(SLA)%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FUL%3E%3CUL%3E%3CLI%3E%3CSPAN%3EAzure%20AD%20authentication%20and%20single%20sign-on%20support%20(SSO)%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FUL%3E%3CUL%3E%3CLI%3E%3CSPAN%3EAutomated%20back-ups%20and%20backup%20retention%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FUL%3E%3CUL%3E%3CLI%3E%3CSPAN%3EAutomated%20patching%20and%20and%20version%20updates%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FUL%3E%3CUL%3E%3CLI%3E%3CSPAN%3EBuilt-in%20high%20availability%20(HA)%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FUL%3E%3CUL%3E%3CLI%3E%3CSPAN%3EPoint-in-time%20database%20restore%20capability%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FUL%3E%3CUL%3E%3CLI%3E%3CSPAN%3EThreat%20detection%20(alerts)%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3ECost%20Effective%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3EHowever%20since%20the%20ability%26nbsp%3B%3CSPAN%3Eto%20coordinate%20distributed%20transactions%26nbsp%3B%20is%20a%20preview%20feature%20i%20would%20suggest%20to%20wait%20it's%20Generala%20Availability%20to%20migrate%20for%20production%20use%20.%20Check%20also%20the%20limitations%20before%20implementing%20.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-sql%2Fdatabase%2Felastic-transactions-overview%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-sql%2Fdatabase%2Felastic-transactions-overview%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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

@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