liveBook · Manning

Five nines

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

Five-nines availability is a service availability target of 99.999 percent uptime over a defined measurement period.

Five-nines availability means keeping an application available 99.999% of the measurement period. That allows only 6 seconds of downtime per week or 26 seconds per month, so accepting the target without examining its consequences is a serious architecture mistake. section 13.2

The network-blip test

A five-nines target can be consumed by a simple 6-second network blip. Meeting it may require costly, geographically dispersed redundant infrastructure and redundant private links; a stand-alone Azure server was described as having only a 95% monthly uptime SLA at the time of writing. section 13.2

Use the target as a requirements and cost decision, not as an automatic promise:

  • Estimate tangible and intangible downtime costs, then compare them with high-availability and disaster-recovery costs. section 13.2
  • Do not let the application owner define availability in isolation; validate the requirement with architecture and analysis. section 13.2

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

How deep it goes
Defines the percentage, converts it to downtime, and compares infrastructure costs without detailing implementation internals.
Examples
Uses a 6-second network blip, an Azure stand-alone server, and geographically redundant infrastructure as concrete illustrations.
What you can do after
Evaluate/understand whether five nines justifies its high availability and disaster recovery cost.
How it connects
Connects availability with architecture, high availability, disaster recovery, infrastructure redundancy, and cost of downtime.

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.