SQL 2016 AlwaysOn High Availability

Seminar / Firmentraining


Experienced DBAs, Windows Server pros, team leads. This is a lab intense course! We designed this course based on our experience of having taught hundreds of classes to literally thousands of students. We tried very hard to make the labs, of which there are over 30, very oriented to a single concept such as Adding a Replica or Transferring Logons. We did this because it is common in technical courses to write long labs with multiple exercises which in our opinion is not effective as they turn into ?click streams?. We assume the student is new to the technology and that the instructor is knowledgeable in it.


Before attending this course, students must have:

  • Experience as SQL DBA
  • Experience as Windows IT PRO



  • Understaand AlwasyOn High Availability
  • Employ Server 2016 Failover Clustering
  • Deploy SQL Failover Clusters
  • Work with Availability Groups
  • Perform maintenance
  • Monitor and Troubleshoot Availability Groups



Always-on and High-Availability Concepts and Terminology

Windows Server 2016 Failover Clustering

SQL 2016 Failover Cluster Instances

SQL 2016 Always-on Availability Groups

The Dasboard

Active Secondary Availability Group Actions


Monitoring and Troubleshooting Availability Groups