Microsoft Dynamics 365 Business Central development team has recently announced Azure SQL Managed Instances official support.
Awara IT highly recommends this read in case you plan to have big Microsoft Dynamics NAV/ Microsoft Dynamics 365 Business Central databases and concerned about its productivity.
Please find more details at Microsoft Dynamics Community.