Sql Azure Server and Availability Sets

  • Newbie here. Scenario: suppose we have a Sql Server "Virtual Machine" running on a HOST. Microsoft will patch the HOST as needed, and likely reboot the HOST too. So how is Sql Server "high availability" implemented in Azure? Some have suggested Availability Sets but I don't see how that will help unless it is assumed the Sql Servers are already clustered (another story in itself) and the cluster members added to an Availably Set. Any idea much appreciated.



  • "Availability Set" is an Azure concept. It allows you to groups of VMs that can operate as replicas.

    An Availability Set ensures that the VMs are hosted in different failure domains (racks) and upgrade domains (groups of hosts that .

    To use Availability Sets with SQL Server, you need to configure a SQL high availability solution (either AlwaysOn or Database Mirroring).

    Please take a look at the documentation (https://msdn.microsoft.com/en-us/library/azure/jj870962.aspx) or this TechEd session (https://channel9.msdn.com/Events/TechEd/NorthAmerica/2014/DBI-B314).

  • Luis --

    Thanks for the answer. A part of one sentence was not complete:

    "domains (racks) and upgrade domains (groups of hosts that . "


  • Groups of hosts that are updated at the same time by Azure.

    This guarantees that a failure or an Azure upgrade doesn't bring down more than one VM at the same time.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply