Always On Availability Groups and Failover Clustering Internals

Windows Server Failover Clustering (WSFC) is the platform that makes SQL Server Always On Availability Groups highly available. There are external interactions between WSFC and SQL Server that you as a DBA cannot monitor from within SQL Server. You need to know the different components that make up the WSFC and how they work to properly deploy and manage Always On Availability Groups for high availability.

In this session, you will dive into the internals of the WSFC, the SQL Server cluster resource DLL, and how they work together to make your SQL Server databases highly available. You will analyze the cluster error log for identifying the root cause of an unexpected or planned failover. Finally, you will learn administrative tasks that you're not supposed to do outside of SQL Server.

This session aims to empower SQL Server database administrators and systems engineers managing Always On Availability Groups understand the inner workings of the Windows Server Failover Cluster and how SQL Server relies on it for high availability.