Arc Enabled Data Services – 7

SQL Managed Instance

Views 1980

In our previous post, we mentioned the 2 types of data services that are supported and able to be managed by our newly deployed Data Controller:

  • Azure Arc-enabled SQL Managed Instance
  • Azure Arc-enabled PostgreSQL Hyperscale

In this pose we are going to have a look at the differences between an installation of Azure SQL Managed Instance and Azure Arc-enabled SQL Managed Instance.

Azure SQL Managed Instance is an intelligent, scalable cloud database service that combines the broadest SQL Server engine compatibility with all the benefits of a fully managed and evergreen platform as a service.

Azure Arc-enabled SQL Managed Instance provides nearly the same features, functionality and user experience as Azure SQL Managed Instance, except it runs on your chosen version-supported Kubernetes hardware, inside of your data center or multi-cloud environment.

Arc-enabled SQL MI has the following Features and Capabilities:

Like all things with the cloud versions or Box versions, Arc-enabled SQL Managed Instance is available in 2 vCore Service Tiers:

  • General Purpose – equivalent to Standard Edition
  • Business Critical – equivalent to Enterprise Edition

Based on your workloads and general requirements, just like you would decide between Standard Edition and Enterprise Edition, General Purpose Vs Business Critical Service tiers come with differing price points, features and resource limits.

You can take advantage of Azure Hybrid Benefits (AHB) with your current On-premises licenses when moving to Arc-enabled data services. You can see the differences above.

As you are deploying and managing on your chosen hardware in your chosen data center, your limit of scalability and High Availability comes down to the underlying hardware resources that you build your Kubernetes Cluster with.

 

In our next post we will have a look at deploying a Azure Arc-enabled SQL Managed Instance.

One response to “Arc Enabled Data Services – 7”

  1. […] Warwick Rudd continues an overview of Azure Arc-Enabled Data Services: […]

Leave a Reply

Your email address will not be published. Required fields are marked *

Warwick

I am a Microsoft Data Platform MVP as well as a Microsoft Certified Master working as the Principal Consultant here at SQL Masters Consulting. When I am not working with the SQL Server Stack I like to get away to the Snow and spend time Snowboarding.

Search