With the introduction of Azure SQL Database Managed Instance (SQL MI), as presented here, more and more customers using SQL Server on premise looking in SQL MI as a great way to migrate to Azure. Having an almost 100% compatibility surface, security and isolation options as a fully managed PaaS with attractive licensing options enables many customers to take the leap to Azure SQL with high confidence. As SQL MI also offers a scale up instance up to 80 cores, it enables consolidation scenarios that can offer great ROI benefits.
But, as any other SQL server consolidation effort, attention is required into planning resources and the right combination of workloads and databases to ensure all work right together. You will find several suggestions below coming from similar deployments and projects that may benefit you as well.
Findings and best practices
As such, consider also enabling accelerated database recovery in SQL MI, as discussed here.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.