What is an Azure SQL Database Managed Instance?

Azure SQL Database Managed Instances provide the broadest SQL Server engine compatibility and native virtual network support. Microsoft states that Managed Instance is the best destination to move a large number of existing SQL Server databases from on-premises or virtual machines to Azure SQL Database.

Azure SQL Database Managed Instances key features

 

Easy to set up

You can create a new Azure SQL Database Managed Instance in 10 simple steps. What’s even more important is that you can set up various additional features in a matter of a few mouse clicks. For example, it’s easier than ever to set up your high availability with Always On Failover Clusters and Always On Availability Groups. Basically, select the deployment option – done! The same approach relates to the other database management options.

Service Tiers

You can opt for one of the two service tiers available for Azure SQL Database Managed Instances.

  • General Purpose service tier is designed for applications with typical performance and IO latency requirements.
  • Business Critical service tier is designed for applications with low IO latency requirements and minimal impact of underlying maintenance operations on the workload.

Both service tiers guarantee 99.99% availability and enable you to independently select storage size and compute capacity.

Advanced security

Azure SQL Database Managed Instances combine advanced security features provided by the Azure cloud and SQL Server Database Engine. Particularly, Managed Instances provide additional security isolation from other tenants in the Azure cloud, including:

  • Native virtual network implementation and connectivity to your on-premises environment using Azure Express Route or VPN Gateway
  • SQL endpoint is exposed only through a private IP address, allowing safe connectivity from private Azure or hybrid networks
  • Single-tenant with dedicated underlying infrastructure (compute, storage)

In addition to that, you can take advantage of the Azure SQL Database Security Features, including Managed Instance auditing, threat detection, and the following:

  • Data encryption in motion
  • Dynamic data masking
  • Row-level security
  • Transparent data encryption

 

Challenges we have seen moving to Azure SQL Database Managed Instances

While Microsoft claims that Azure SQL Database Managed Instances deliver “close to 100% compatibility”, the operative word in the quote is “close”. Likewise, you have the standard challenges when moving any SQL Server-based solution to Azure. Here are some of the challenges that we’ve experienced moving our customer’s workloads to Managed Instances and how we overcame them.

Over provisioning

Newer Azure hardware runs better than old on-premises servers, so you may be over provisioning your Azure SQL Database Managed Instance

Our Data Management Optimization service can help you choose the right size of your VM in the Azure cloud.

It all starts with an understanding of your current data estate. Our own DBMsys Platform will monitor your existing on-premises databases, as well as the hardware, software, CPU usage, memory, disk latency, and network bandwidth.

Then, based on the metrics collected by DBMSys and the actual performance of your current workload, our experts recommend the appropriate size of the Managed Instance.

Following this path, you can optimize licensing costs and improve the performance with a rationalized move to the cloud.

Close to 100% compatibility doesn't mean 100%

Understanding what works and what doesn't goes beyond a static analysis of your database. It's all about the applications.

Microsoft recommends using the Data Migration Assistant to move your on-premises workloads to the Azure SQL Database Managed Instances. However, before you start, you should check the list of what won’t work when you migrate over on the Azure SQL Database Managed Instance T-SQL differences from SQL Server page. Keep in mind that The Microsoft Data Migration Assistant (DMA) only performs a static analysis of your SQL Server instance and databases on that instance. So, there’s a lot of manual work waiting for you before you can run your databases in the Azure SQL Database Managed Instance.

Azure SQL Database Managed Instances compatibility

First of all, you will need to discover the unsupported statements and manually update them. For example, you can opt to trace SQL statements using server-side tracing or Extended Events, but you risk adding an additional load to your production servers.

The DB Best approach starts with a thorough analysis of your existing database applications. Our own SQL Sniffer technology can look for incompatible code coming from your applications. Based on the results of this analysis, our experts will provide you with a migration plan that is right for your applications.

Moving your SQL Server 2008 and 2008 R2 database to Azure is more than lift and shift

While Microsoft is offering reduced licensing incentives to simply move your databases to Managed Instances until you can upgrade on your own time, there are many factors to consider when moving to Azure.

These factors include:

  • How do you move your Windows Active Directory, or SQL Server Logins to Azure Active Directory?
  • How do you configure the Azure Virtual Private Network to be comparable with your data center’s network so that your applications still work?

Our experienced consultants, processes, and tools can help you actually achieve a seamless lift and shift experience to minimize your downtime and get your databases on to Azure SQL Database Managed Instance. Moreover, you will be sure that your new database platform meets all your compliance requirements.

Learn more about Azure SQL Database Managed Instances
Contact us

Getting started offers

The operational and financial benefits of an intelligent, fully managed service look undoubtful. To start moving your workloads to Azure SQL Database Managed Instances, you should first run a thorough assessment. This will help choose the optimal size of Database Managed Instance to meet your needs.

We recommend starting with our state-of-the-art DBMSys platform. It helps examine each aspect of your database and determine where you’re able to cut costs, consolidate servers, and how best to manage your data. Then, based on the assessment results, you can opt for Database Management Optimization service, Migration to Azure offer or even Future-state architectural design engagement. And, of course, it’s worth it to consider Azure SQL Database Managed Instances when upgrading your running out of support SQL Server databases.

Let's get together to talk about Azure SQL Database Managed Instances
Contact us today

Learn more

Blog posts

Top 5 reasons for migrating to Azure SQL Database Managed Instances now!
2 October 2018 Bill Ramos

Microsoft is doubling down on Azure SQL Database Managed Instances (DMI) this year. There are some amazing Microsoft offers to provide a Platform-as-a-Service for running SQL Server on...

Azure SQL Database Migration to Embrace Cloud Benefits
6 April 2017 Stanislav Andrenko

One of the leading medical software providers maintained their complex healthcare system with thousands of unique users. Developing over time, this system became overloaded and unsaf...

Faster, Cheaper, Better: Upgrade SQL Server 2008 NOW
17 July 2018 Bill Ramos

So Long, Microsoft SQL Server 2008 I think that you’re supposed to know when it’s time to say goodbye. - Judy Sheindlin We get it. You’ve been running your SQL Server 2008 for te...

Reference data sheet

Making the move to Azure SQL Database Managed Instances Datasheet
30 August 2018 admin

Read our Azure SQL Database Managed Instances datasheet to find out why Platform-as-a-Service (PaaS) offerings are very appealing to businesses of all sizes. For example, PaaS offering...

SQL Server Database Upgrade Datasheet
30 August 2018 admin

We get it: You’ve been running your SQL Server 2008/R2 for ten years now, and its performance has made you very happy. It’s been as steady as a rock and helped guide your business ...

Let us help you with your project!
Contact us for a FREE quote today.
Request a quote