SQL Server Performance Tuning and Optimization

SQT12 Common Troubleshooting Techniques for Availability Groups and Failover Cluster Instances

11/19/2019

4:15pm - 5:30pm

Level: Intermediate

Allan Hirt

Founder

SQLHA, LLC

When things go wrong with Always On Availability Groups (AGs) or Always On Failover Cluster Instances (FCIs), it is not always apparent where to look and how to diagnose what happened. This session will help demystify where to look when you have a problem, as well as cover some of the more common issues you will see when implementing AGs and FCIs, whether you have them deployed on Windows Server or Linux.

You will learn:

  • Understand the tools available for diagnosing availability problems with AGs and FCIs
  • Understand how to troubleshoot FCIs
  • Understand how to troubleshoot AGs