Jan 31 2021 05:16 PM - edited Jan 31 2021 05:33 PM
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?
Feb 01 2021 01:30 AM
Hi below some benefits of using SQL server managed instance :
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