I speak to many people who use cloud technologies, especially database tech and how little consideration they give to their MISSION CRITICAL Databases that run in the cloud and its Disaster Recovery process. When I say mission critical, I mean its relative to the company I am talking to, so what might be a tier 1 app for you might not be the case for Bob.
We all would like to save money when operating in the cloud, Microsoft has released a stop / start concept for SQL Managed Instances – preview mode!
A post close to my heart, Azure SQL Managed Instance, I have blogged about this many times but I feel I should be sharing more details about this. One important topic – Maintenance windows.
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.
With SQL Managed Instance you will need to consider your configuration requirements in terms of core count for the CPU and memory, which we all know that the MIN/MAX settings for SQL is so important.
All About Tech 