Data is collected from the SQL Server Availability Group connection from the following Spotlight collections.
How to configure Spotlight collections
Use a Spotlight Client to configure Spotlight collections. See Configure Scheduling
From the Spotlight Client
- Click Configure | Scheduling.
- Select template or connection to configure
- Select a collection to modify the collection schedule.
Alarms
Alarm | Collection Name |
---|---|
Availability Group - Failover Availability | Group States |
Availability Group - Failed Over | Availability Group Failover Detection |
Availability Group - Quorum Failure Imminent | Group States |
Availability Group - Synchronization Health | Availability Group States |
Spotlight Overview page
Component | Collection Name |
---|---|
Status | N/A |
Synchronization Health | Availability Group States |
Primary Instance | Availability Group States |
Failover Mode | Replicas |
Cluster Name | Cluster Details |
Cluster Mode | Cluster Details |
Replicas collected (grid) | Replicas |
Databases collected (grid) | Database Replicas |