Zone Redundancy for Azure SQL Managed Instance Business Critical service tier
Published Nov 16 2022 07:50 AM 1,352 Views

Now available in preview as part of the November 2022 feature wave, you can enable the zone redundant configuration for your new and existing Azure SQL Managed Instances that use the Business Critical service tier.  

 

Zone redundant configuration utilizes Azure Availability Zones to replicate your instances across multiple physical locations within an Azure region. By selecting zone redundant configuration, you can make your Business Critical managed instances resilient to a much larger set of failures, including catastrophic datacenter outages, without any changes of the application logic. For more information see Business Critical service tier zone redundant availability section in the Azure SQL documentation. 

 

How to enable the zone redundant configuration

Zone redundant configuration can be enabled for all Business Critical instances that have received the November 2022 feature wave update – to learn more about November 2022 feature wave, please consult this blog.

Once the zone redundant option is enabled, Azure SQL Managed Instance will automatically reconfigure the instance. You can configure this setting by using Portal or ARM API. The support for CLI and PowerShell will be coming in the next several months.

 

Configure Zone Redundancy using Azure Portal

The following workflow illustrates how to use Azure portal to configure a new Business Critical managed instance to use zone redundant configuration.

 

Step 1: Select Configure Managed Instance in the Create Azure SQL Managed Instance tab

VladimirIvanovic_0-1668607315197.png

 

 

Step 2: In the Compute + Storage page select Yes to make the instance zone redundant then click Apply

VladimirIvanovic_1-1668607315229.png

Step 3: Choose one of the compatible redundancy options for backup storage: 

  • ZRS (Zone Redundant Storage)
  • GZRS (Geo Zone Redundant Storage)

Learn more about different options for backup storage redundancy in this blog.

 

Configure Zone Redundancy using ARM

The following REST API commands can be used to enable the zone redundant configuration using the zoneRedundant {false, true} parameter.

 

Regional Availability

Zone redundant Azure SQL Managed Instance Business Critical tier is available in preview in the following regions:

  • Brazil South
  • East US
  • Japan East
  • Norway East
  • UAE North
  • South Africa North
  • Australia East
  • Korea Central

Additional regions will be added over time. For up-to-date information on regions that support Availability Zones in Azure, visit this documentation page.

 

Pricing

Zone Redundant SQL Managed Instances will be available with no additional charge until the end of February 2023. Starting from March 1st, 2023, we will start charging listed prices for these instances using the following pricing model for the zone-redundant managed instances:

  • No upcharge for the “SQL license” part of the price
  • 60% upcharge for the “compute” part of the price
  • 100% upcharge for the “storage” part of the price

Here’s a quick example using a 4 vCore Business Critical instance with standard-series hardware and 1 TB of reserved storage (East US region, pay as you go pricing model, monthly rates, US$)

Item

Non-ZR price

ZR price

ZR pricing delta

License cost

1095

1095

0%

Compute cost

888.96

1422.34

60%

Storage cost (1 TB total, first 32 GB free)

248

496

100%

Overall cost

2231.96

3013.34

35%

Pricing comparison for a non-ZR and ZR config  

Summary

In this article, we introduced the new zone redundancy option that makes your Azure SQL managed instances resilient to a much larger set of failures, including catastrophic datacenter outages, without any changes of the application logic

Next steps:

  • Get started with SQL Managed Instance with our Quick Start reference guide.
  • Learn more about Azure SQL Managed Instance zone redundancy and high availability.
  • Learn more about the latest innovation in Azure SQL Managed Instance announced in Nov 2022.
Co-Authors
Version history
Last update:
‎Nov 16 2022 09:26 AM
Updated by: