|
Note: The Availability Groups connection type requires SQL Server 2012 or above. The Availability Groups connection type was called High Availability in Spotlight on SQL Server releases prior to 11.1. |
An availability group is a set of user databases that fail over together. An availability group consists of a primary availability replica and one to four secondary replicas that are maintained through SQL Server log-based data movement for data protection without the need for shared storage. Each replica is hosted by an instance of SQL Server on a different node of the Windows Server Failover Cluster (WSFC). The availability group and a corresponding virtual network name are registered as resources in the WSFC.
Select Availability Group from Monitored connections to show performance statistics for connections of type Availability Group.
Icon | Help Reference | Description |
---|---|---|
Heat map | A display of monitored Availability Group connections focusing on those connections with the comparatively larger number and severity of alarms. | |
Spotlight today | A display of Availability Group alarms raised, alarms are organized according to priority. | |
Alarms by time | A display of Availability Group alarms raised, alarms are shown according to their duration and severity. | |
Alarm log | A display of Availability Group alarms raised, alarms are sorted in a tabular format. |
Expand the Availability Group connection type from Monitored connections to list connections by name.
Click on the connection name to show components, the replicas grid and databases grid for the Availability Group.
Component | Description | ||||||
---|---|---|---|---|---|---|---|
Status |
The status indicator is colored according to the highest raised alarm on the Availability Group. During a planned outage, all controls are disabled except Status. A Monitored Server - Planned Outage alarm is raised against the Status control. For more information, see Configure | Planned Outage. | ||||||
Synchronization Health |
The health rating of the Availability Group is excellent when all nodes are available and the preferred node is primary.
| ||||||
Primary Instance | The name of the node (instance) that is currently primary. | ||||||
Failover indicator |
The current failover availability:
| ||||||
Cluster | The name of the Windows Server Failover Cluster (WSFC). | ||||||
Quorum Rating | The Quorum rating of database availability. The DBA sets the quorum configuration in the SQL Server Management Studio. The Quorum rating determines the number of node failures that the cluster can sustain. |
Show data for each node in the Availability Group.
|
Note:
|
Show data for each database in the Availability Group.
|
Note:
|
© 2022 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy