SQL Managed Instance enabled by Azure Arc service tiers

As part of the family of Azure SQL products, SQL Managed Instance enabled by Azure Arc is available in two vCore service tiers.

  • General Purpose is a budget-friendly tier designed for most workloads with common performance and availability features.
  • Business Critical tier is designed for performance-sensitive workloads with higher availability features.

In Azure, storage and compute is provided by Microsoft with guaranteed service level agreements (SLAs) for performance, throughput, availability, and etc. across each of the service tiers. With Azure Arc-enabled data services, customers provide the storage and compute. Hence, there are no guaranteed SLAs provided to customers with Azure Arc-enabled data services. However, customers get the flexibility to bring their own performant hardware irrespective of the service tier.

Service tier comparison

Following is a description of the various capabilities available from Azure Arc-enabled data services across the two service tiers:

Area Business Critical General Purpose
SQL Feature set Same as SQL Server Enterprise Edition Same as SQL Server Standard Edition
CPU limit/instance Unlimited 24 cores
Memory limit/instance Unlimited 128 GB
Scale up/down Available Available
Monitoring Built-in available locally, and optionally export to Azure Monitor Built-in available locally, and optionally export to Azure Log Analytics
Logging Built-in available locally, and optionally export to Azure Log Analytics Built-in available locally, and optionally export to Azure Monitor
Point in time Restore Built-in Built-in
High availability Contained Availability groups over kubernetes redeployment Single instance w/ Kubernetes redeploy + shared storage.
Read scale out Availability group None
Disaster Recovery Available via Failover Groups Available via Failover Groups
AHB exchange rates for IP component of price 1:1 Enterprise Edition
4:1 Standard Edition
1:4 Enterprise Edition​
1:1 Standard Edition
Dev/Test pricing No cost No cost

How to choose between the service tiers

Since customers bring their own hardware with performance and availability requirements based on their business needs, the primary differentiators between the service tiers are what is provided at the software level.

Choose General Purpose if

  • CPU/memory requirements meet or are within the limits of the General Purpose service tier
  • The high availability options provided by Kubernetes, such as pod redeployments, is sufficient for the workload
  • Application does not need read scale out
  • The application does not require any of the features found in the Business Critical service tier (same as SQL Server Enterprise Edition)

Choose Business Critical if

  • CPU/memory requirements exceed the limits of the General Purpose service tier
  • Application requires a higher level of High Availability such as built-in Availability Groups to handle application failovers than what is offered by Kubernetes.
  • Application can take advantage of read scale out to offload read workloads to the secondary replicas
  • Application requires features found only in the Business Critical service tier (same as SQL Server Enterprise Edition)