Making SQL sense

+44 (0)20 3051 3595

Making SQL sense

+44 (0)20 3051 3595


We're looking for people who share our commitment to excellence in Microsoft's data platform to join us consultants working on exciting business intelligence, analytics, and SQL Server projects on-premises and in the cloud.

Using an Azure cloud witness in your failover cluster

The Coeo Blog

I’ve blogged previously about the need to configure a quorum witness on failover clusters and now with Windows Server 2016 there’s a great new quorum option – a cloud witness.

The key scenario that a cloud witness simplifies is a multi-site failover cluster – a cluster with nodes in different datacentres. They are a common way to implement multi-site disaster recovery, particularly for SQL Server where the use of an Availability Group requires a failover cluster but doesn’t require shared storage to be presented.

Ideally, where you have a deployment across two datacentres you would have a third datacentre for a quorum witness so that you could lose either of the first two without impacting the quorum but it’s rare for companies to have access to three datacentres and you wouldn’t setup access to another traditional datacentre just for a quorum witness.

This is where the cloud witness feature fits neatly in, taking only a few minutes to setup and giving you access to that third site for a negligible investment.

A cloud witness isn’t just useful for multi-site clusters though -- any cluster where all the nodes have access to the internet (HTTPS) could be configured to use Azure for the witness. Most clusters that we’ve built in the past have used a file-share witness but I love the idea of off-loading the maintenance of those file shares to Microsoft and I’m looking forward to decommissioning those file servers that only exist to provide me with file-share witnesses.

Its shockingly simple to implement and the steps and detailed very well here:

Subscribe to Email Updates