Is Azure SQL Database Managed Instance the Right Solution?

Published On: 2018-11-05By:

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

https://www.flickr.com/photos/theaucitron/5810163712/

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.

Denny

The post Is Azure SQL Database Managed Instance the Right Solution? appeared first on SQL Server with Mr. Denny.

Video

Globally Recognized Expertise

As Microsoft MVP’s and Partners as well as VMware experts, we are summoned by companies all over the world to fine-tune and problem-solve the most difficult architecture, infrastructure and network challenges.

And sometimes we’re asked to share what we did, at events like Microsoft’s PASS Summit 2015.