liveBook · Manning

Availability zone

As explained in 100 SQL Server Mistakes and How to Avoid Them

An availability zone is an isolated physical location within a cloud region that provides independent infrastructure for improving workload resilience.

1. Mistake: treating zero downtime as a default. An availability zone is an isolated physical location within a cloud region; distributing infrastructure across zones can improve resilience, but the required level must justify its cost. section 13.2

Four nines in Azure

For four nines of availability, an Azure IaaS design requires two virtual machines split across two availability zones. Azure SQL Database can instead use the Business Critical or Premium tier. section 13.2

Table 13.1 Levels of availability (view table figure)

Level of availability

Downtime per week

Downtime per month

99%

1 hour, 40 minutes, 48 seconds

7 hours, 18 minutes, 17 seconds

99.9%

10 minutes, 4 seconds

43 minutes, 49 seconds

99.99%

1 minute

4 minutes, 23 seconds

99.999%

6 seconds

26 seconds

Compare availability targets with their allowed downtime before choosing a multi-zone or other high-availability design. section 13.2

Use this checklist before configuring a topology:

  • Clarify the application’s availability requirements. section 13.2
  • Compare the financial cost of downtime with the cost of the high-availability or disaster-recovery solution. section 13.2

How 100 SQL Server Mistakes and How to Avoid Them covers it

How deep it goes
Explains the four-nines Azure pattern but stops short of detailing the underlying high-availability or disaster-recovery topology.
Examples
Uses two Azure virtual machines across two zones and Azure SQL Database Business Critical or Premium tiers as four-nines examples.
What it assumes
Assumes the ability to discuss application requirements and weigh downtime costs against infrastructure benefits.
What you can do after
Evaluate availability requirements and choose a justified multi-zone or managed database configuration.
How it connects
Connects availability zones with high availability, disaster recovery, service-level agreements, virtual machines, and Azure SQL Database.

Also explained in

Compare how 4 books explain availability zone →

Related concepts

This explainer was generated by Manning's knowledge graph from the text of 100 SQL Server Mistakes and How to Avoid Them. The section links point to the parts of the book it draws on.