The High Availability module is built around always on capabilities of SQL server. This module will display all associated always on information for the currently selected server.
The information is displayed by Availability Groups and allows drill down into each group separately.
The Availability Groups will be displayed for the selected server whether it acts as a secondary or primary server in the availability group.
Each Availability Group is comprised of 2 or more servers, one of which is the primary server, which are then comprised of the databases themselves.
Availability Group List Overview
| Legend | |
| 1 | Availability Group List – by default all groups are collapsed. To open an active group use the icon. |
| 2 | Active Availability Group – When an Availability Group is Enabled (has no issues) you may collapse or expand on it to view it’s database sync information (see next section: expanded availability group |
| 3 | Search + Filters.
Use the filters to focus on a specific group \ database or search for a particular state. Failover Mode – Automatic \ Manual Health Status – the health status of the group is comprised of the health status of the underlying databases.
|
Expanded Availability Group
| Legend | |||||||||||||||||
| 1 | Status over time – displays the health status changes of the group over the course of the selected timeframe. An empty “status over time” when having a “healthy” availability group is a good indicator. | ||||||||||||||||
| 2 | Sync Latency chart – displays gaps in sync latency over the selected timeframe. The closest the chart series are to 0 the better. | ||||||||||||||||
| 3 | Database list – the internal database list the comprises the availability group split into servers.
|
||||||||||||||||