• Adam Thurgar

Oncology app - the AG witness


One of the more interesting technical decisions with the whole SQL Server Availability Group set up for this application was the witness mechanism.

Before you start to even think about the witness, make sure you have a good grasp of all the concepts of an AG.

I recommend that following article:

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/overview-of-always-on-availability-groups-sql-server

Brent Ozar (Brent Ozar Unlimited https://www.brentozar.com/) had a free video by Kendra Little on where quorum is set up and explains witnesses, dynamic voting, and why your Windows version is so important.

https://www.brentozar.com/archive/2013/08/introduction-sql-server-failover-clusters-video/

For the oncology application we chose to use a File Share Witness (FSW) and combine this with Distributed File System Replication (DFSR https://msdn.microsoft.com/en-us/library/bb540025(v=vs.85).aspx) for high availability of the witness.


2 views

Recent Posts

See All

Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a compatibility level of 110 (SQL Server 2012), but when run unde

Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response from the software provider is always the same - you have index f

Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete from. They also knew that deleting large amounts of data causes t