Page History
...
AlwaysOn Availability Groups are part of an integrated solution, introduced in SQL Server 2012 with the goal of achieving the highest level of data availability and disaster recovery for organizations. Availability Groups grant DBAs the ability to automatically or manually failover a group of databases as a single unit with support for up to four secondary replicas. For additional information on availability groups, see the Microsoft document,
. Newtablink alias Overview of AlwaysOn Availability Groups (SQL Server) url https://msdndocs.microsoft.com/en-us/library/ff877884.aspx/sql/database-engine/availability-groups/windows/overview-of-always-on-availability-groups-sql-server?view=sql-server-ver15
Access the AlwaysOn Availability Groups view
You can To open the AlwaysOn Availability Groups view by clicking click the appropriate monitored SQL Server instance, and then clicking Databases > select Databases, and click Availability Group.
Database AlwaysOn Availability Groups statistics
...
Description of the database state of the availability replica. Possible values include: online, restoring, recovering, recovery_pending, suspect, emergency, and offline.
Suspended Status
An AlwaysOn availability database is suspended. Possible values are true or false.
Last Hardened Time
Indicates the time when the log-block identifier was received for the last hardened LSN on the secondary replica.
...
The AlwaysOn Availability Groups view includes charts that display the queue size and transfer rates of different availability groups.
Queue Size chart
Provides users with graphical details about queues in the AlwaysOn Availability Groups feature. This chart is a stacked bar chart for the "Log Send Queue Size" and "Redo Queue Size."
...
To view a list of all available alerts, see Metric alerts.
Understand the view colors
The AlwaysOn Availability Groups view uses a color-based alert system. The following colors are associated with a status and action within SQL Diagnostic Manager:
Color | Alert Status | Action |
---|---|---|
Green | OK | Acceptable threshold where SQL Diagnostic Manager does not generate an alert. |
Blue | Informational | Informational threshold where SQL Diagnostic Manager generates an informational alert. |
Yellow | Warning | Warning threshold where SQL Diagnostic Manager generates a warning alert. |
Red | Critical | Critical threshold where SQL Diagnostic Manager generates a critical alert. |
Scroll pdf ignore | ||||||
---|---|---|---|---|---|---|
Newtabfooter |
|
...
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
...