Maybe. Is the software that you’re trying to move to Microsoft’s Azure require the use of a SQL Server instance so that you can create jobs, logins, and do
things like cross-server queries? Are you trying to avoid adding more Virtual Machines (VMs) to be managed in your environment (and a SQL Server Failover Cluster or Availability Group)? If the answer to these questions is “yes” then Managed Instance might not be the right solution for you.
Now granted, you may need to wait until the Performance Tier of Managed Instance is available as the General Purpose tier may not have the power to run the application that you need to set up. If CPU and memory is the only problem that you’re running across than merely waiting is all that you have to do.
Managed Instance is like everything else in Azure, it may or may not be the correct solution to solve the problem at hand, but it might be.
The post Is Azure SQL Database Managed Instance the Right Solution? appeared first on SQL Server with Mr. Denny.
Contact the Author | Contact DCAC