Book Image

Professional SQL Server High Availability and Disaster Recovery

By : Ahmad Osama
Book Image

Professional SQL Server High Availability and Disaster Recovery

By: Ahmad Osama

Overview of this book

Professional SQL Server High Availability and Disaster Recovery explains the high availability and disaster recovery technologies available in SQL Server: Replication, AlwaysOn, and Log Shipping. You’ll learn what they are, how to monitor them, and how to troubleshoot any related problems. You will be introduced to the availability groups of AlwaysOn and learn how to configure them to extend your database mirroring. Through this book, you will be able to explore the technical implementations of high availability and disaster recovery technologies that you can use when you create a highly available infrastructure, including hybrid topologies. Note that this course does not cover SQL Server Failover Cluster Installation with shared storage. By the end of the book, you’ll be equipped with all that you need to know to develop robust and high performance infrastructure.
Table of Contents (9 chapters)
Professional SQL Server High Availability and Disaster Recovery
Preface

Monitoring AlwaysOn Availability Groups


Monitoring an AlwaysOn availability group is important to quickly find problems before or when they occur, and then take corrective actions. Monitoring an AlwaysOn AG can be done using the AlwaysOn dashboard, T-SQL, PowerShell, Performance Monitor, or other third-party monitoring tools.

In this section, we'll learn how to use different methods to monitor AGs and configure monitoring alerts.

The AlwaysOn AG Dashboard

In the previous lesson, we have seen how to use the dashboard to monitor the AlwaysOn AG, listener, replica, and synchronization status. However, the dashboard can be used to monitor the real-time health metrics of an AlwaysOn AG too.

The dashboard has hidden columns that can be used to get details on an AlwaysOn AG. The hidden columns are added by selecting the Add/Remove Columns link next to the Group by section on the dashboard:

Figure 5.54: The Add/Remove Columns link

The following hidden columns are available to add to the dashboard:

Figure...