Public preview of Azure SQL Database Managed Instance
Microsoft has announced the public preview of Azure SQL Database Managed Instance. I blogged about this before. This will lead to a title wave of on-prem SQL Server database migrations to the cloud. In summary:
Managed Instance is an expansion of the existing SQL Database service, providing a third deployment option alongside single databases and elastic pools. It is designed to enable database lift-and-shift to a fully-managed service, without re-designing the application. SQL Database Managed Instance provides the broadest SQL Server engine compatibility and native virtual network (VNET) support so you can migrate your SQL Server databases to SQL Database without changing your apps. It combines the rich SQL Server surface area with the operational and financial benefits of an intelligent, fully-managed service.
Two other related items that are available:
- Azure Hybrid Benefit for SQL Server on Azure SQL Database Managed Instance. The Azure Hybrid Benefit for SQL Server is an Azure-based benefit that enables customers to use their SQL Server licenses with Software Assurance to save up to 30% on SQL Database Managed Instance. Exclusive to Azure, the hybrid benefit will provide an additional benefit for highly-virtualized Enterprise Edition workloads with active Software Assurance: for every 1 core a customer owns on-premises, they will receive 4 vCores of Managed Instance General Purpose. This makes moving virtualized applications to Managed Instance highly cost-effective.
- Database Migration Services for Azure SQL Database Managed Instance. Using the fully-automated Database Migration Service (DMS) in Azure, customers can easily lift and shift their on-premises SQL Server databases to a SQL Database Managed Instance. DMS is a fully managed, first party Azure service that enables seamless and frictionless migrations from heterogeneous database sources to Azure Database platforms with minimal downtime. It will provide customers with assessment reports that guide them through the changes required prior to performing a migration. When the customer is ready, the DMS will perform all the steps associated with the migration process.
More info:
Migrate your databases to a fully managed service with Azure SQL Database Managed Instance
What is Azure SQL Database Managed Instance?
Video Introducing Azure SQL Database Managed Instance
Azure SQL Database Managed Instance – the Good, the Bad, the Ugly
“Lift and shift”, LOL. OK fine. I wonder why it’s taken so long. For that matter, I wonder why they didn’t do it this way the first time around. I don’t see pricing information.
Hi JR,
Pricing can be found at https://azure.microsoft.com/en-us/pricing/calculator/
I am a little unclear about this; is it effectively a VM Sql managed by Microsoft instead of having to do it manually. I ask because it’s priced on vcores instead of those impossible to predict DTUs.
I have tried SQL Azure Database but it’s way to slow even on the most premium of plans for me to use and then costs 1000’s a month … slow AND ridiculously expensive. So I have had to use an Azure VM with SQL Server. However, it’s a pain to have to manage updates and so on on the VM, and I don’t get benefit of redundancy or failover etc with a huge amount of config and extra vms and complexity which I don’t have knowledge or experience of.
This sql managed instance seems a better fit for my app, but only if it isn’t as slow as sql azure and more akin to a VM?
Could you help me out with a more fundamental explanation of what it is and what it’s difference is to Sql Azure and a VM.
Hi Dan,
Think of Managed Instance as Azure SQL Database on steroids. It has all the benefits of Azure SQL Database (i.e. built-in disaster recovery, no VMs to manage, etc) while removing almost all the limitations of Azure SQL Database (i.e. cross-database queries, SQL Agent). It is not IaaS, it is PaaS. They switched to vcores instead of DTUs because of the difficulty in predicting performance as you mentioned. It will have much better performance that “regular” Azure SQL Database so give it a chance 🙂
Pingback:Public preview of Azure SQL Database Managed Instance - SSWUG.ORG