Monitor

To monitor the properties and state of an Always On availability group you can use the

following tools.

System Center

Monitoring

pack for SQL

Server

The Monitoring pack for SQL Server (SQLMP) is

the recommended solution for monitoring

availability groups, availability replicas and

availability databases for IT administrators.

Monitoring features that are particularly relevant

to Always On availability groups include the

following:

Automatic discoverability of availability groups,

availability replicas, and availability database

from among hundreds of computers. This

enables you to easily keep track of your Always

On availability groups inventory.

Fully capable System Center Operations

Manager (SCOM) alerting and ticketing. These

features provide detailed knowledge that

enables faster resolution to a problem.

A custom extension to Always On Health

monitoring using Policy Based management

(PBM).

Health roll ups from availability databases to

availability replicas.

Custom tasks that manage Always On availability

groups from the System Center Operations

Manager console.

To download the monitoring pack

(SQLServerMP.msi) and

Management Pack Guide for System

Center Operations Manager

(SQLServerMPGuide.doc), see:

System Center Monitoring pack for

Transact-SQL

Always On availability groups catalog and

dynamic management views provide a wealth of

information about your availability groups and

Monitor Availability Groups

(Transact-SQL)

ﾉ

Expand table