Hitachi

JP1 Version 12 JP1/Performance Management - Remote Monitor for Microsoft(R) SQL Server Description, User's Guide and Reference


2.6 Monitoring in the SQL Server AlwaysOn Availability Group configuration

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.

For notes on monitoring the SQL Server AlwaysOn Availability Group configuration, see 2.9.2 Notes on monitoring Microsoft SQL Server.

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