Share via

Azure SQL zone redundancy pricing with DTU purchase model

metalheart 411 Reputation points
2022-09-14T14:37:15.903+00:00

On the Azure SQL Database pricing page I can see there is a price difference between locally redundant and zone redundant database with the vCore purchase model.

However, I cannot identify the difference with DTU-based model.

My question is: given a SQL Database with Standard S4: 200 DTUs without availability zones, how would the price differ if I chose to enable zone redundancy?

Azure SQL Database
0 comments
Accepted answer
  1. Alberto Morillo 34,926 Reputation points MVP Volunteer Moderator
    2022-09-14T15:35:11.103+00:00

    It is not available for Standard and Basic tiers on DTU-model. You will not find this feature available on S4. Only premium tiers on DTU model have available the zone redundant feature. That feature is free of additional charges on Premium tiers.

    Why is free? With the introduction of Azure Availability Zones, SQL Database can place different replicas of the Premium database to different availability zones in the same region. To eliminate a single point of failure, the control ring is also duplicated across multiple zones as three gateway rings (GW). The routing to a specific gateway ring is controlled by Azure Traffic Manager (ATM). Because the zone-redundant configuration in the Premium (DTU model) service tiers does not create additional database redundancy, you can enable it at no extra cost

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 21,111 Reputation points Microsoft Employee Moderator
    2022-09-16T21:11:02.753+00:00

    Hi @metalheart Thank you for posting your question on Microsoft Q&A and for using Azure services.
    As per my understanding you are trying to identify the price difference between locally redundant and zone redundant for DTUs purchasing model which does not show in the Azure Database pricing page.
    • In the DTU purchasing model, enabling Zone Redundancy is supported only for Premium service tier and not available for Standard tier as @Alberto Morillo mentioned.
    • Moreover, Zone Redundancy for Premium tier comes at no extra cost and that’s why there is no price point available in pricing page. We will add a note in pricing page to clarify this.
    • Today, pricing card in portal doesn’t display backup charges. We will add that soon.

    Thank you for your question and for helping us update our documentation.

    Please do not forget to mark as accept answer wherever information provided were helpful so it will be beneficial for other community members facing the same.

    Regards,
    Oury

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.