AlwaysOn Best Practices and Troubleshooting

Links to important best practice, configuration and troubleshooting documents

Prerequisites, Restrictions, Recommendations - Always On Availability Groups – This covers a lot of territory on how to set up availability groups.

AlwaysOn guidance from Brent Ozar Unlimited – this link points to multiple documents, some of which are contained in Brent’s First Responder Kit.  Contains checklists, guidance, and caveats.

Connection Timeouts in Multi-subnet Availability Group  - if you are going to span multiple subnets, you are going to need to make some configuration changes.

Recommendations for Index Maintenance with AlwaysOn Availability Groups – because index rebuilds are propagated between replicas, you are going to have to make some compromises.  This document explains it.

Configure Heartbeat and DNS Settings in a Multi-Site Failover Cluster – Expands on the previous item.

Recommendations for Index Maintenance with AlwaysOn Availability Groups – because index rebuilds are propagated between replicas, you are going to have to make some compromises.  This document explains it.

Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery – Good overview.  Also available as a PDF eBook.

SQL Server 2016 Always On Availability Groups Enhancements – PDF document by MCM Jimmy May.  Presented at 24 Hours of PASS. Good high-level interview and explanation of internals.  Valuable best practices information.

SQL Server 2016 Always On AGs Perf, Internals, & Lessons Learned  Another presentation by MCM/MVP Jimmy May.  Presented at SQLSaturday Denver 9/16/2017.  Rich performance tuning information.  Need to have PASS account to download.