Monitoring in the SQL Server AlwaysOn Availability Group configuration

Job Management Partner 1 Version 10, Job Management Partner 1/Performance Management - Remote Monitor for Microsoft(R) SQL Server Description, User's Guide and Reference

PFM - RM for Microsoft SQL Server collects information about the databases (primary database and secondary database) configured by using the SQL Server AlwaysOn Availability Group functionality. For the secondary database, information is collected only when all connections to it are permitted.

The following figure shows an example of the SQL Server AlwaysOn Availability Group configuration when not all of the connections to the secondary database are permitted.

Figure 2-8 Example of monitoring in the SQL Server AlwaysOn Availability Group configuration

[Figure]

For details about operation during or after failover of the primary database and secondary database, see 2.5 Failover in the mirroring configuration.

Organization of this section: 2.6.1 Monitoring during failover in the SQL Server AlwaysOn Availability Group configuration; 2.6.2 Monitoring after failover in the SQL Server AlwaysOn Availability Group configuration

2.6 Monitoring in the SQL Server AlwaysOn Availability Group configuration