There is a setting / feature in Managed Instance worth talking about, it is called SQL Trust Groups.
SQL Managed Instances – Cross Instance?
3
SQL Managed Instance – Failover Groups Quick Tips
Lets summarise some important learnings about SQL MI and failover groups.
SQL Managed Instances – Failing Over
This is our current setup shown below.
There is not much to failing over with Managed Instances, from experience it is similar to that of Azure SQL Database.
Failover Groups for Managed Instances
If you have been following me for a while you will know that I really like the Fail over groups within Azure SQL DB and it is no different to when applying it to Managed Instances. If you want a rock-solid DR plan, this is the way forward.
Azure SQL Managed Instance – Premium Tier
In case you are not aware Microsoft have now deployed a new change to SQL Managed Instances within the tier types. In certain regions ( shown later) you can select something different to that of gen 5 hardware now called standard – more specifically premium series where you have 2 options as shown below – a much wanted request!
All About Tech 