Lesson 5

Managing AlwaysOn Availability Groups

Learning Objectives

By the end of this lesson, you will be able to do the following:

  • Perform automatic and manual failover
  • Perform various management tasks against an availability group
  • Monitor an AlwaysOn availability group
  • Detect common AlwaysOn availability group problems and implement their solutions

This lesson will show us how to manage and maintain an AlwaysOn AG. We will also learn how to troubleshoot an AG.


In the previous lesson, we configured a three-node AlwaysOn availability group (AG) with one primary and two secondary nodes.

However, configuring an AlwaysOn AG is half the task. In this lesson, we'll learn to manage and maintain AlwaysOn availability groups. We'll ...

Get Professional SQL Server High Availability and Disaster Recovery now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.