Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Management Pack for SCOM User Guide

Spotlight Collections for Availability Groups

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.

The following collections are used for displays (alarms, home page components and drilldowns).

Note:

  • Background collection schedules (collected when no Spotlight client is displaying that collection) are configurable unless otherwise stated. Collections with Cfg=N are non configurable.
  • Some collections are used for multiple displays (home page components and drilldowns). Modifying a collection schedule may impact more than just one display.
  • To configure the collection schedule, see Configure | Scheduling.
  • Data collected by background collection schedules is stored in the Playback Database.

Table 17: Collections - About each alarm

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

Table 18: Collections - Availability Groups

Home Page Component Collection Name Cfg
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  
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating