Voltar
-
Título
Monitoring SQL Server Availability Groups vs Failover Clusters -
Descrição
How should SQL Server agents be configured for an Availability Group and a Failover Cluster? -
Causa
Databases in an availability group are called availability databases, and they fail over together as a group. Unlike a failover cluster, in an Always On Availability Group, storage is not shared because SQL Server uses log shipping to replicate data from the primary database to the secondary database instances. -
Resolução
To monitor a Failover Cluster, a single SQL Server agent should be added to monitor the instance using the virtual hostname. The agent installer will determine if there are multiple nodes and automatically create nodes for all of the available hosts in the cluster. Additional nodes can be added later by verifying the connection in the Agent Administration panel.
To monitor an Always On Availability Group, SQL Server agents should be created for each of the monitored instances. Monitoring the listener itself is not supported.