| DisplayName | Description | ID | Target | Parent Monitor | Algorithm | Algorithm Parameter | Source Monitor | Relationship | Category | Enabled | Alert Generate | Alert Severity | Alert Priority | Alert Auto Resolve | Remotable | Accessibility |
| Agent Jobs Availability | Rolls up all Agent Jobs availability monitors to the SQL Server Agent. | Microsoft.SQLServer.Windows.Rollup.Agent.AgentJobToAgentAvailability | Microsoft.SQLServer.Windows.Agent | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServer.Windows.AgentHostsAgentJob | AvailabilityHealth | True | False | | | False | True | Public |
| Agent Jobs Configuration | Rolls up all Agent Jobs configuration monitors to the SQL Server Agent. | Microsoft.SQLServer.Windows.Rollup.Agent.AgentJobToAgentConfiguration | Microsoft.SQLServer.Windows.Agent | System.Health.ConfigurationState | WorstOf | | System.Health.ConfigurationState | Microsoft.SQLServer.Windows.AgentHostsAgentJob | ConfigurationHealth | True | False | | | False | True | Public |
| Agent Jobs Performance | Rolls up all Agent Jobs performance monitors to the SQL Server Agent. | Microsoft.SQLServer.Windows.Rollup.Agent.AgentJobToAgentPerformance | Microsoft.SQLServer.Windows.Agent | System.Health.PerformanceState | WorstOf | | System.Health.PerformanceState | Microsoft.SQLServer.Windows.AgentHostsAgentJob | PerformanceHealth | True | False | | | False | True | Public |
| Agent Jobs Security | Rolls up all Agent Jobs security monitors to the SQL Server Agent. | Microsoft.SQLServer.Windows.Rollup.Agent.AgentJobToAgentSecurity | Microsoft.SQLServer.Windows.Agent | System.Health.SecurityState | WorstOf | | System.Health.SecurityState | Microsoft.SQLServer.Windows.AgentHostsAgentJob | SecurityHealth | True | False | | | False | True | Public |
| Availability Database Backup Status (Windows rollup) | This monitor is a dependency (rollup) monitor. The monitor checks availability of a full database backup and its age as reported by Microsoft SQL Server. | Microsoft.SQLServer.Windows.Rollup.AvailabilityDatabase.BackupStatus | Microsoft.SQLServer.Core.AvailabilityDatabase | Microsoft.SQLServer.Core.Rollup.AvailabilityDatabase.BackupStatusAggregate | BestOf | | Microsoft.SQLServer.Windows.Monitor.AvailabilityDatabaseHealth.BackupStatus | Microsoft.SQLServer.Windows.AvailabilityDatabaseReferencesAvailabilityDatabaseHealth | AvailabilityHealth | True | False | | | False | True | Public |
| Availability Database Log Backup Status (Windows rollup) | This monitor is a dependency (rollup) monitor. The monitor checks availability of a database log backup and its age as reported by Microsoft SQL Server. | Microsoft.SQLServer.Windows.Rollup.AvailabilityDatabase.DBLogBackupStatus | Microsoft.SQLServer.Core.AvailabilityDatabase | Microsoft.SQLServer.Core.Rollup.AvailabilityDatabase.DBLogBackupStatusAggregate | BestOf | | Microsoft.SQLServer.Windows.Monitor.AvailabilityDatabaseHealth.DBLogBackupStatus | Microsoft.SQLServer.Windows.AvailabilityDatabaseReferencesAvailabilityDatabaseHealth | AvailabilityHealth | True | False | | | False | True | Public |
| Availability Replicas Connection (Windows rollup) | This monitor rolls up the connection state of all availability replicas and check whether any availability replica is DISCONNECTED. The monitor is unhealthy when any availability replica is DISCONNECTED. The monitor is healthy otherwise. This monitor is a dependency (rollup) monitor. | Microsoft.SQLServer.Windows.Rollup.AvailabilityGroup.AllAvailabilityReplicasAreConnected | Microsoft.SQLServer.Core.AvailabilityGroup | Microsoft.SQLServer.Core.Rollup.AvailabilityGroup.AllAvailabilityReplicasAreConnected | WorstOf | | Microsoft.SQLServer.Windows.Monitor.AvailabilityGroupHealth.AllAvailabilityReplicasAreConnected | Microsoft.SQLServer.Windows.AvailabilityGroupReferencesAvailabilityGroupHealth | AvailabilityHealth | True | False | | | True | True | Public |
| Availability Group Automatic Failover (Windows rollup) | This monitor checks if the availability group has at least one secondary replica which is failover ready. The monitor becomes unhealthy and alert is registered when the failover mode of primary replica is automatic but none of secondary replica in the availability group is automatic failover ready. The monitor is healthy when at least one secondary replica is automatic failover ready. This monitor is a dependency (rollup) monitor. | Microsoft.SQLServer.Windows.Rollup.AvailabilityGroup.AutomaticFailoverReadiness | Microsoft.SQLServer.Core.AvailabilityGroup | Microsoft.SQLServer.Core.Rollup.AvailabilityGroup.AutomaticFailoverReadiness | WorstOf | | Microsoft.SQLServer.Windows.Monitor.AvailabilityGroupHealth.AutomaticFailoverReadiness | Microsoft.SQLServer.Windows.AvailabilityGroupReferencesAvailabilityGroupHealth | AvailabilityHealth | True | False | | | True | True | Public |
| Availability Group Online (Windows rollup) | This monitor checks the online or offline state of availability group. The monitor is in unhealthy state and alert is raised when the availability group’s cluster resource is offline or the availability group does not have a primary replica. The monitor state is healthy when the cluster resource of availability group is online and the availability group has a primary replica. This monitor is a dependency (rollup) monitor. | Microsoft.SQLServer.Windows.Rollup.AvailabilityGroup.AvailabilityGroupOnline | Microsoft.SQLServer.Core.AvailabilityGroup | Microsoft.SQLServer.Core.Rollup.AvailabilityGroup.AvailabilityGroupOnline | WorstOf | | Microsoft.SQLServer.Windows.Monitor.AvailabilityGroupHealth.AvailabilityGroupOnline | Microsoft.SQLServer.Windows.AvailabilityGroupReferencesAvailabilityGroupHealth | AvailabilityHealth | True | False | | | True | True | Public |
| Availability Group Extended Health State (Windows rollup) | This is the rollup monitor for all extended health monitors. Extended health monitors are automatically generated by discovering the existing health policies in SQL server instances on Windows. | Microsoft.SQLServer.Windows.Rollup.AvailabilityGroup.AvailabilityGroupUserPolicyState | Microsoft.SQLServer.Core.AvailabilityGroup | Microsoft.SQLServer.Core.Rollup.AvailabilityGroup.AvailabilityGroupUserPolicyState | WorstOf | | Microsoft.SQLServer.Windows.Rollup.AvailabilityGroupHealth.UserPolicyAggregate | Microsoft.SQLServer.Windows.AvailabilityGroupReferencesAvailabilityGroupHealth | AvailabilityHealth | True | False | | | True | True | Public |
| Availability Replicas Role (Windows rollup) | This monitor rolls up the state of role of all availability replicas and checks whether any availability replica is not in a healthy role. The monitor is unhealthy when any availability replica is neither primary nor secondary. The monitor is healthy state otherwise. This monitor is a dependency (rollup) monitor. | Microsoft.SQLServer.Windows.Rollup.AvailabilityGroup.AvailabilityReplicaRoleState | Microsoft.SQLServer.Core.AvailabilityGroup | Microsoft.SQLServer.Core.Rollup.AvailabilityGroup.AvailabilityReplicaRoleState | WorstOf | | Microsoft.SQLServer.Windows.Monitor.AvailabilityGroupHealth.AvailabilityReplicaRoleState | Microsoft.SQLServer.Windows.AvailabilityGroupReferencesAvailabilityGroupHealth | AvailabilityHealth | True | False | | | True | True | Public |
| Synchronous Replicas Data Synchronization (Windows rollup) | This monitor rolls up the data synchronization state of all availability replicas and checks whether any availability replica is not in the expected synchronization state. The monitor is unhealthy when any asynchronous replica is not in SYNCHRONIZING state and any synchronous replica is not in SYNCHRONIZED state. The monitor state is healthy otherwise. This monitor is a dependency (rollup) monitor. | Microsoft.SQLServer.Windows.Rollup.AvailabilityGroup.AvailabilityReplicasSynchronizationState | Microsoft.SQLServer.Core.AvailabilityGroup | Microsoft.SQLServer.Core.Rollup.AvailabilityGroup.AvailabilityReplicasSynchronizationState | WorstOf | | Microsoft.SQLServer.Windows.Monitor.AvailabilityGroupHealth.AvailabilityReplicasSynchronizationState | Microsoft.SQLServer.Windows.AvailabilityGroupReferencesAvailabilityGroupHealth | AvailabilityHealth | True | False | | | True | True | Public |
| Availability Replicas Data Synchronization (Windows rollup) | This monitor rolls up the data synchronization state of all availability replicas and checks whether any availability replica is not in the expected synchronization state. The monitor is unhealthy when any asynchronous replica is not in SYNCHRONIZING state and any synchronous replica is not in SYNCHRONIZED state. The monitor state is healthy otherwise. This monitor is a dependency (rollup) monitor. | Microsoft.SQLServer.Windows.Rollup.AvailabilityGroup.AvailabilityReplicasSynchronizing | Microsoft.SQLServer.Core.AvailabilityGroup | Microsoft.SQLServer.Core.Rollup.AvailabilityGroup.AvailabilityReplicasSynchronizing | WorstOf | | Microsoft.SQLServer.Windows.Monitor.AvailabilityGroupHealth.AvailabilityReplicasSynchronizing | Microsoft.SQLServer.Windows.AvailabilityGroupReferencesAvailabilityGroupHealth | AvailabilityHealth | True | False | | | True | True | Public |
| Availability Group Critical Policies (rollup) | This monitor is the rollup monitor for all Custom User Policies, which have Availability Group as Facet and one of the predefined error categories as Policy Category. | Microsoft.SQLServer.Windows.Rollup.AvailabilityGroupHealth.ErrorUserPolicyState | Microsoft.SQLServer.Windows.AvailabilityGroupHealth | Microsoft.SQLServer.Windows.Rollup.AvailabilityGroupHealth.UserPolicyAggregate | WorstOf | | Microsoft.SQLServer.Windows.Monitor.AvailabilityGroupErrorPolicy.State | Microsoft.SQLServer.Windows.AvailabilityGroupHealthHostsAvailabilityGroupErrorUserPolicy | AvailabilityHealth | True | False | | | True | True | Public |
| Availability Group Warning Policies (rollup) | This monitor is the rollup monitor for all Custom User Policies, which have Availability Group as Facet and one of the predefined warning categories as Policy Category. | Microsoft.SQLServer.Windows.Rollup.AvailabilityGroupHealth.WarningUserPolicyState | Microsoft.SQLServer.Windows.AvailabilityGroupHealth | Microsoft.SQLServer.Windows.Rollup.AvailabilityGroupHealth.UserPolicyAggregate | WorstOf | | Microsoft.SQLServer.Windows.Monitor.AvailabilityGroupWarningPolicy.State | Microsoft.SQLServer.Windows.AvailabilityGroupHealthHostsAvailabilityGroupWarningUserPolicy | AvailabilityHealth | True | False | | | True | True | Public |
| Availability Replica Critical Policies Availability | Rolls up all Availability Replica Critical Policies availability monitors to the Availability Replica. | Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaErrorUserPolicyToAvailabilityReplicaAvailability | Microsoft.SQLServer.Windows.AvailabilityReplica | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServer.Windows.AvailabilityReplicaHostsAvailabilityReplicaErrorUserPolicy | AvailabilityHealth | True | False | | | True | True | Public |
| Availability Replica Critical Policies Configuration | Rolls up all Availability Replica Critical Policies configuration monitors to the Availability Replica. | Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaErrorUserPolicyToAvailabilityReplicaConfiguration | Microsoft.SQLServer.Windows.AvailabilityReplica | System.Health.ConfigurationState | WorstOf | | System.Health.ConfigurationState | Microsoft.SQLServer.Windows.AvailabilityReplicaHostsAvailabilityReplicaErrorUserPolicy | ConfigurationHealth | True | False | | | True | True | Public |
| Availability Replica Critical Policies Performance | Rolls up all Availability Replica Critical Policies performance monitors to the Availability Replica. | Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaErrorUserPolicyToAvailabilityReplicaPerformance | Microsoft.SQLServer.Windows.AvailabilityReplica | System.Health.PerformanceState | WorstOf | | System.Health.PerformanceState | Microsoft.SQLServer.Windows.AvailabilityReplicaHostsAvailabilityReplicaErrorUserPolicy | PerformanceHealth | True | False | | | True | True | Public |
| Availability Replica Critical Policies Security | Rolls up all Availability Replica Critical Policies security monitors to the Availability Replica. | Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaErrorUserPolicyToAvailabilityReplicaSecurity | Microsoft.SQLServer.Windows.AvailabilityReplica | System.Health.SecurityState | WorstOf | | System.Health.SecurityState | Microsoft.SQLServer.Windows.AvailabilityReplicaHostsAvailabilityReplicaErrorUserPolicy | SecurityHealth | True | False | | | True | True | Public |
| Availability Replica Warning Policies Availability | Rolls up all Availability Replica Warning Policies availability monitors to the Availability Replica. | Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaWarningUserPolicyToAvailabilityReplicaAvailability | Microsoft.SQLServer.Windows.AvailabilityReplica | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServer.Windows.AvailabilityReplicaHostsAvailabilityReplicaWarningUserPolicy | AvailabilityHealth | True | False | | | True | True | Public |
| Availability Replica Warning Policies Configuration | Rolls up all Availability Replica Warning Policies configuration monitors to the Availability Replica. | Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaWarningUserPolicyToAvailabilityReplicaConfiguration | Microsoft.SQLServer.Windows.AvailabilityReplica | System.Health.ConfigurationState | WorstOf | | System.Health.ConfigurationState | Microsoft.SQLServer.Windows.AvailabilityReplicaHostsAvailabilityReplicaWarningUserPolicy | ConfigurationHealth | True | False | | | True | True | Public |
| Availability Replica Warning Policies Performance | Rolls up all Availability Replica Warning Policies performance monitors to the Availability Replica. | Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaWarningUserPolicyToAvailabilityReplicaPerformance | Microsoft.SQLServer.Windows.AvailabilityReplica | System.Health.PerformanceState | WorstOf | | System.Health.PerformanceState | Microsoft.SQLServer.Windows.AvailabilityReplicaHostsAvailabilityReplicaWarningUserPolicy | PerformanceHealth | True | False | | | True | True | Public |
| Availability Replica Warning Policies Security | Rolls up all Availability Replica Warning Policies security monitors to the Availability Replica. | Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaWarningUserPolicyToAvailabilityReplicaSecurity | Microsoft.SQLServer.Windows.AvailabilityReplica | System.Health.SecurityState | WorstOf | | System.Health.SecurityState | Microsoft.SQLServer.Windows.AvailabilityReplicaHostsAvailabilityReplicaWarningUserPolicy | SecurityHealth | True | False | | | True | True | Public |
| Database Replicas Availability | Rolls up all Database Replicas availability monitors to the Availability Replica. | Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.DatabaseReplicaToAvailabilityReplicaAvailability | Microsoft.SQLServer.Windows.AvailabilityReplica | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServer.Windows.AvailabilityReplicaHostsDatabaseReplica | AvailabilityHealth | True | False | | | True | True | Public |
| Database Replicas Configuration | Rolls up all Database Replicas configuration monitors to the Availability Replica. | Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.DatabaseReplicaToAvailabilityReplicaConfiguration | Microsoft.SQLServer.Windows.AvailabilityReplica | System.Health.ConfigurationState | WorstOf | | System.Health.ConfigurationState | Microsoft.SQLServer.Windows.AvailabilityReplicaHostsDatabaseReplica | ConfigurationHealth | True | False | | | True | True | Public |
| Database Replicas Performance | Rolls up all Database Replicas performance monitors to the Availability Replica. | Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.DatabaseReplicaToAvailabilityReplicaPerformance | Microsoft.SQLServer.Windows.AvailabilityReplica | System.Health.PerformanceState | WorstOf | | System.Health.PerformanceState | Microsoft.SQLServer.Windows.AvailabilityReplicaHostsDatabaseReplica | PerformanceHealth | True | False | | | True | True | Public |
| Database Replicas Security | Rolls up all Database Replicas security monitors to the Availability Replica. | Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.DatabaseReplicaToAvailabilityReplicaSecurity | Microsoft.SQLServer.Windows.AvailabilityReplica | System.Health.SecurityState | WorstOf | | System.Health.SecurityState | Microsoft.SQLServer.Windows.AvailabilityReplicaHostsDatabaseReplica | SecurityHealth | True | False | | | True | True | Public |
| Database Critical Policies Availability | Rolls up all Database Critical Policies availability monitors to the Database. | Microsoft.SQLServer.Windows.Rollup.Database.DatabaseErrorUserPolicyToDatabaseAvailability | Microsoft.SQLServer.Windows.Database | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServer.Windows.DatabaseHostsDBErrorUserPolicy | AvailabilityHealth | True | False | | | True | True | Public |
| Database Critical Policies Configuration | Rolls up all Database Critical Policies configuration monitors to the Database. | Microsoft.SQLServer.Windows.Rollup.Database.DatabaseErrorUserPolicyToDatabaseConfiguration | Microsoft.SQLServer.Windows.Database | System.Health.ConfigurationState | WorstOf | | System.Health.ConfigurationState | Microsoft.SQLServer.Windows.DatabaseHostsDBErrorUserPolicy | ConfigurationHealth | True | False | | | True | True | Public |
| Database Critical Policies Performance | Rolls up all Database Critical Policies performance monitors to the Database. | Microsoft.SQLServer.Windows.Rollup.Database.DatabaseErrorUserPolicyToDatabasePerformance | Microsoft.SQLServer.Windows.Database | System.Health.PerformanceState | WorstOf | | System.Health.PerformanceState | Microsoft.SQLServer.Windows.DatabaseHostsDBErrorUserPolicy | PerformanceHealth | True | False | | | True | True | Public |
| Database Critical Policies Security | Rolls up all Database Critical Policies security monitors to the Database. | Microsoft.SQLServer.Windows.Rollup.Database.DatabaseErrorUserPolicyToDatabaseSecurity | Microsoft.SQLServer.Windows.Database | System.Health.SecurityState | WorstOf | | System.Health.SecurityState | Microsoft.SQLServer.Windows.DatabaseHostsDBErrorUserPolicy | SecurityHealth | True | False | | | True | True | Public |
| Database Warning Policies Availability | Rolls up all Database Warning Policies availability monitors to the Database. | Microsoft.SQLServer.Windows.Rollup.Database.DatabaseWarningUserPolicyToDatabaseAvailability | Microsoft.SQLServer.Windows.Database | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServer.Windows.DatabaseHostsDBWarningUserPolicy | AvailabilityHealth | True | False | | | True | True | Public |
| Database Warning Policies Configuration | Rolls up all Database Warning Policies configuration monitors to the Database. | Microsoft.SQLServer.Windows.Rollup.Database.DatabaseWarningUserPolicyToDatabaseConfiguration | Microsoft.SQLServer.Windows.Database | System.Health.ConfigurationState | WorstOf | | System.Health.ConfigurationState | Microsoft.SQLServer.Windows.DatabaseHostsDBWarningUserPolicy | ConfigurationHealth | True | False | | | True | True | Public |
| Database Warning Policies Performance | Rolls up all Database Warning Policies performance monitors to the Database. | Microsoft.SQLServer.Windows.Rollup.Database.DatabaseWarningUserPolicyToDatabasePerformance | Microsoft.SQLServer.Windows.Database | System.Health.PerformanceState | WorstOf | | System.Health.PerformanceState | Microsoft.SQLServer.Windows.DatabaseHostsDBWarningUserPolicy | PerformanceHealth | True | False | | | True | True | Public |
| Database Warning Policies Security | Rolls up all Database Warning Policies security monitors to the Database. | Microsoft.SQLServer.Windows.Rollup.Database.DatabaseWarningUserPolicyToDatabaseSecurity | Microsoft.SQLServer.Windows.Database | System.Health.SecurityState | WorstOf | | System.Health.SecurityState | Microsoft.SQLServer.Windows.DatabaseHostsDBWarningUserPolicy | SecurityHealth | True | False | | | True | True | Public |
| DB FILESTREAM Filegroups Availability | Rolls up all DB FILESTREAM Filegroups availability monitors to the Database. | Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupFdToDatabaseAvailability | Microsoft.SQLServer.Windows.Database | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServer.Windows.DatabaseHostsDBFilegroupFd | AvailabilityHealth | True | False | | | True | True | Public |
| DB FILESTREAM Filegroups Configuration | Rolls up all DB FILESTREAM Filegroups configuration monitors to the Database. | Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupFdToDatabaseConfiguration | Microsoft.SQLServer.Windows.Database | System.Health.ConfigurationState | WorstOf | | System.Health.ConfigurationState | Microsoft.SQLServer.Windows.DatabaseHostsDBFilegroupFd | ConfigurationHealth | True | False | | | True | True | Public |
| DB FILESTREAM Filegroups Performance | Rolls up all DB FILESTREAM Filegroups performance monitors to the Database. | Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupFdToDatabasePerformance | Microsoft.SQLServer.Windows.Database | System.Health.PerformanceState | WorstOf | | System.Health.PerformanceState | Microsoft.SQLServer.Windows.DatabaseHostsDBFilegroupFd | PerformanceHealth | True | False | | | True | True | Public |
| DB FILESTREAM Filegroups Security | Rolls up all DB FILESTREAM Filegroups security monitors to the Database. | Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupFdToDatabaseSecurity | Microsoft.SQLServer.Windows.Database | System.Health.SecurityState | WorstOf | | System.Health.SecurityState | Microsoft.SQLServer.Windows.DatabaseHostsDBFilegroupFd | SecurityHealth | True | False | | | True | True | Public |
| DB Memory-Optimized Data Filegroups Availability | Rolls up all DB Memory-Optimized data filegroups availability monitors to the database. | Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupFxToDatabaseAvailability | Microsoft.SQLServer.Windows.Database | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServer.Windows.DatabaseHostsDBFilegroupFx | AvailabilityHealth | True | False | | | True | True | Public |
| DB Memory-Optimized Data Filegroups Configuration | Rolls up all DB Memory-Optimized data filegroups configuration monitors to the database. | Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupFxToDatabaseConfiguration | Microsoft.SQLServer.Windows.Database | System.Health.ConfigurationState | WorstOf | | System.Health.ConfigurationState | Microsoft.SQLServer.Windows.DatabaseHostsDBFilegroupFx | ConfigurationHealth | True | False | | | True | True | Public |
| DB Memory-Optimized Data Filegroups Performance | Rolls up all DB Memory-Optimized data filegroups performance monitors to the database. | Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupFxToDatabasePerformance | Microsoft.SQLServer.Windows.Database | System.Health.PerformanceState | WorstOf | | System.Health.PerformanceState | Microsoft.SQLServer.Windows.DatabaseHostsDBFilegroupFx | PerformanceHealth | True | False | | | True | True | Public |
| DB Memory-Optimized Data Filegroups Security | Rolls up all DB Memory-Optimized data filegroups security monitors to the database. | Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupFxToDatabaseSecurity | Microsoft.SQLServer.Windows.Database | System.Health.SecurityState | WorstOf | | System.Health.SecurityState | Microsoft.SQLServer.Windows.DatabaseHostsDBFilegroupFx | SecurityHealth | True | False | | | True | True | Public |
| DB Filegroups Availability | Rolls up all DB Filegroups availability monitors to the Database. | Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupToDatabaseAvailability | Microsoft.SQLServer.Windows.Database | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServer.Windows.DatabaseHostsDBFilegroup | AvailabilityHealth | True | False | | | True | True | Public |
| DB Filegroups Configuration | Rolls up all DB Filegroups configuration monitors to the Database. | Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupToDatabaseConfiguration | Microsoft.SQLServer.Windows.Database | System.Health.ConfigurationState | WorstOf | | System.Health.ConfigurationState | Microsoft.SQLServer.Windows.DatabaseHostsDBFilegroup | ConfigurationHealth | True | False | | | True | True | Public |
| DB Filegroups Performance | Rolls up all DB Filegroups performance monitors to the Database. | Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupToDatabasePerformance | Microsoft.SQLServer.Windows.Database | System.Health.PerformanceState | WorstOf | | System.Health.PerformanceState | Microsoft.SQLServer.Windows.DatabaseHostsDBFilegroup | PerformanceHealth | True | False | | | True | True | Public |
| DB Filegroups Security | Rolls up all DB Filegroups security monitors to the Database. | Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupToDatabaseSecurity | Microsoft.SQLServer.Windows.Database | System.Health.SecurityState | WorstOf | | System.Health.SecurityState | Microsoft.SQLServer.Windows.DatabaseHostsDBFilegroup | SecurityHealth | True | False | | | True | True | Public |
| DB Log Files Availability | Rolls up all DB Log files availability monitors to the database. | Microsoft.SQLServer.Windows.Rollup.Database.DBLogFileToDatabaseAvailability | Microsoft.SQLServer.Windows.Database | System.Health.AvailabilityState | BestOf | | System.Health.AvailabilityState | Microsoft.SQLServer.Windows.DatabaseHostsDBLogFile | AvailabilityHealth | True | False | | | True | True | Public |
| DB Log Files Configuration | Rolls up all DB Log files configuration monitors to the database. | Microsoft.SQLServer.Windows.Rollup.Database.DBLogFileToDatabaseConfiguration | Microsoft.SQLServer.Windows.Database | System.Health.ConfigurationState | BestOf | | System.Health.ConfigurationState | Microsoft.SQLServer.Windows.DatabaseHostsDBLogFile | ConfigurationHealth | True | False | | | True | True | Public |
| DB Log Files Performance | Rolls up all DB Log files performance monitors to the database. | Microsoft.SQLServer.Windows.Rollup.Database.DBLogFileToDatabasePerformance | Microsoft.SQLServer.Windows.Database | System.Health.PerformanceState | BestOf | | System.Health.PerformanceState | Microsoft.SQLServer.Windows.DatabaseHostsDBLogFile | PerformanceHealth | True | True | MatchMonitorHealth | Normal | True | True | Public |
| DB Log Files Security | Rolls up all DB Log files security monitors to the database. | Microsoft.SQLServer.Windows.Rollup.Database.DBLogFileToDatabaseSecurity | Microsoft.SQLServer.Windows.Database | System.Health.SecurityState | BestOf | | System.Health.SecurityState | Microsoft.SQLServer.Windows.DatabaseHostsDBLogFile | SecurityHealth | True | False | | | True | True | Public |
| Resources Pool Memory Consumption (rollup) | The monitor reports a critical state and raises an alert when the amount of memory used by the resource pool is greater than the Threshold setting, expressed as a percentage of memory available for Memory-Optimized Data tables for the given resource pool. This monitor is a dependency (rollup) monitor. | Microsoft.SQLServer.Windows.Rollup.Database.MemoryConsumption | Microsoft.SQLServer.Windows.Database | System.Health.PerformanceState | WorstOf | | Microsoft.SQLServer.Windows.Monitor.UserResourcePool.MemoryConsumption | Microsoft.SQLServer.Windows.DatabaseReferencesUserResourcePool | PerformanceCollection | True | False | | | False | True | Public |
| Database Replica Critical Policies Availability | Rolls up all Database Replica Critical Policies availability monitors to the Database Replica. | Microsoft.SQLServer.Windows.Rollup.DatabaseReplica.DatabaseReplicaErrorUserPolicyToDatabaseReplicaAvailability | Microsoft.SQLServer.Windows.DatabaseReplica | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServer.Windows.DatabaseReplicaHostsDatabaseReplicaErrorUserPolicy | AvailabilityHealth | True | False | | | True | True | Public |
| Database Replica Critical Policies Configuration | Rolls up all Database Replica Critical Policies configuration monitors to the Database Replica. | Microsoft.SQLServer.Windows.Rollup.DatabaseReplica.DatabaseReplicaErrorUserPolicyToDatabaseReplicaConfiguration | Microsoft.SQLServer.Windows.DatabaseReplica | System.Health.ConfigurationState | WorstOf | | System.Health.ConfigurationState | Microsoft.SQLServer.Windows.DatabaseReplicaHostsDatabaseReplicaErrorUserPolicy | ConfigurationHealth | True | False | | | True | True | Public |
| Database Replica Critical Policies Performance | Rolls up all Database Replica Critical Policies performance monitors to the Database Replica. | Microsoft.SQLServer.Windows.Rollup.DatabaseReplica.DatabaseReplicaErrorUserPolicyToDatabaseReplicaPerformance | Microsoft.SQLServer.Windows.DatabaseReplica | System.Health.PerformanceState | WorstOf | | System.Health.PerformanceState | Microsoft.SQLServer.Windows.DatabaseReplicaHostsDatabaseReplicaErrorUserPolicy | PerformanceHealth | True | False | | | True | True | Public |
| Database Replica Critical Policies Security | Rolls up all Database Replica Critical Policies security monitors to the Database Replica. | Microsoft.SQLServer.Windows.Rollup.DatabaseReplica.DatabaseReplicaErrorUserPolicyToDatabaseReplicaSecurity | Microsoft.SQLServer.Windows.DatabaseReplica | System.Health.SecurityState | WorstOf | | System.Health.SecurityState | Microsoft.SQLServer.Windows.DatabaseReplicaHostsDatabaseReplicaErrorUserPolicy | SecurityHealth | True | False | | | True | True | Public |
| Database Replica Warning Policies Availability | Rolls up all Database Replica Warning Policies availability monitors to the Database Replica. | Microsoft.SQLServer.Windows.Rollup.DatabaseReplica.DatabaseReplicaWarningUserPolicyToDatabaseReplicaAvailability | Microsoft.SQLServer.Windows.DatabaseReplica | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServer.Windows.DatabaseReplicaHostsDatabaseReplicaWarningUserPolicy | AvailabilityHealth | True | False | | | True | True | Public |
| Database Replica Warning Policies Configuration | Rolls up all Database Replica Warning Policies configuration monitors to the Database Replica. | Microsoft.SQLServer.Windows.Rollup.DatabaseReplica.DatabaseReplicaWarningUserPolicyToDatabaseReplicaConfiguration | Microsoft.SQLServer.Windows.DatabaseReplica | System.Health.ConfigurationState | WorstOf | | System.Health.ConfigurationState | Microsoft.SQLServer.Windows.DatabaseReplicaHostsDatabaseReplicaWarningUserPolicy | ConfigurationHealth | True | False | | | True | True | Public |
| Database Replica Warning Policies Performance | Rolls up all Database Replica Warning Policies performance monitors to the Database Replica. | Microsoft.SQLServer.Windows.Rollup.DatabaseReplica.DatabaseReplicaWarningUserPolicyToDatabaseReplicaPerformance | Microsoft.SQLServer.Windows.DatabaseReplica | System.Health.PerformanceState | WorstOf | | System.Health.PerformanceState | Microsoft.SQLServer.Windows.DatabaseReplicaHostsDatabaseReplicaWarningUserPolicy | PerformanceHealth | True | False | | | True | True | Public |
| Database Replica Warning Policies Security | Rolls up all Database Replica Warning Policies security monitors to the Database Replica. | Microsoft.SQLServer.Windows.Rollup.DatabaseReplica.DatabaseReplicaWarningUserPolicyToDatabaseReplicaSecurity | Microsoft.SQLServer.Windows.DatabaseReplica | System.Health.SecurityState | WorstOf | | System.Health.SecurityState | Microsoft.SQLServer.Windows.DatabaseReplicaHostsDatabaseReplicaWarningUserPolicy | SecurityHealth | True | False | | | True | True | Public |
| Databases Availability | Rolls up all Databases availability monitors to the DB Engine. | Microsoft.SQLServer.Windows.Rollup.DBEngine.DatabaseToDBEngineAvailability | Microsoft.SQLServer.Windows.DBEngine | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServer.Windows.DBEngineHostsDatabase | AvailabilityHealth | True | False | | | True | True | Public |
| Databases Configuration | Rolls up all Databases configuration monitors to the DB Engine. | Microsoft.SQLServer.Windows.Rollup.DBEngine.DatabaseToDBEngineConfiguration | Microsoft.SQLServer.Windows.DBEngine | System.Health.ConfigurationState | WorstOf | | System.Health.ConfigurationState | Microsoft.SQLServer.Windows.DBEngineHostsDatabase | ConfigurationHealth | True | False | | | True | True | Public |
| Databases Performance | Rolls up all Databases performance monitors to the DB Engine. | Microsoft.SQLServer.Windows.Rollup.DBEngine.DatabaseToDBEnginePerformance | Microsoft.SQLServer.Windows.DBEngine | System.Health.PerformanceState | WorstOf | | System.Health.PerformanceState | Microsoft.SQLServer.Windows.DBEngineHostsDatabase | PerformanceHealth | True | False | | | True | True | Public |
| Databases Security | Rolls up all Databases security monitors to the DB Engine. | Microsoft.SQLServer.Windows.Rollup.DBEngine.DatabaseToDBEngineSecurity | Microsoft.SQLServer.Windows.DBEngine | System.Health.SecurityState | WorstOf | | System.Health.SecurityState | Microsoft.SQLServer.Windows.DBEngineHostsDatabase | SecurityHealth | True | False | | | True | True | Public |
| DB Files Availability | Rolls up all DB files availability monitors to the DB filegroup. | Microsoft.SQLServer.Windows.Rollup.DBFilegroup.DBFileToDBFilegroupAvailability | Microsoft.SQLServer.Windows.DBFilegroup | System.Health.AvailabilityState | BestOf | | System.Health.AvailabilityState | Microsoft.SQLServer.Windows.DBFilegroupHostsDBFile | AvailabilityHealth | True | False | | | True | True | Public |
| DB Files Configuration | Rolls up all DB files configuration monitors to the DB filegroup. | Microsoft.SQLServer.Windows.Rollup.DBFilegroup.DBFileToDBFilegroupConfiguration | Microsoft.SQLServer.Windows.DBFilegroup | System.Health.ConfigurationState | BestOf | | System.Health.ConfigurationState | Microsoft.SQLServer.Windows.DBFilegroupHostsDBFile | ConfigurationHealth | True | False | | | True | True | Public |
| DB Files Performance | Rolls up all DB files performance monitors to the DB filegroup. | Microsoft.SQLServer.Windows.Rollup.DBFilegroup.DBFileToDBFilegroupPerformance | Microsoft.SQLServer.Windows.DBFilegroup | System.Health.PerformanceState | BestOf | | System.Health.PerformanceState | Microsoft.SQLServer.Windows.DBFilegroupHostsDBFile | PerformanceHealth | True | True | MatchMonitorHealth | Normal | True | True | Public |
| DB Files Security | Rolls up all DB files security monitors to the DB filegroup. | Microsoft.SQLServer.Windows.Rollup.DBFilegroup.DBFileToDBFilegroupSecurity | Microsoft.SQLServer.Windows.DBFilegroup | System.Health.SecurityState | BestOf | | System.Health.SecurityState | Microsoft.SQLServer.Windows.DBFilegroupHostsDBFile | SecurityHealth | True | False | | | True | True | Public |
| Containers Availability | Rolls up all containers availability monitors to the DB Memory-Optimized data filegroup. | Microsoft.SQLServer.Windows.Rollup.DBFilegroupFx.ContainerToDBFilegroupFxAvailability | Microsoft.SQLServer.Windows.DBFilegroupFx | System.Health.AvailabilityState | BestOf | | System.Health.AvailabilityState | Microsoft.SQLServer.Windows.DBFilegroupFxHostsContainer | AvailabilityHealth | True | False | | | False | True | Public |
| Containers Configuration | Rolls up all containers configuration monitors to the DB Memory-Optimized data filegroup. | Microsoft.SQLServer.Windows.Rollup.DBFilegroupFx.ContainerToDBFilegroupFxConfiguration | Microsoft.SQLServer.Windows.DBFilegroupFx | System.Health.ConfigurationState | BestOf | | System.Health.ConfigurationState | Microsoft.SQLServer.Windows.DBFilegroupFxHostsContainer | ConfigurationHealth | True | False | | | True | True | Public |
| Containers Performance | Rolls up all containers performance monitors to the DB Memory-Optimized data filegroup. | Microsoft.SQLServer.Windows.Rollup.DBFilegroupFx.ContainerToDBFilegroupFxPerformance | Microsoft.SQLServer.Windows.DBFilegroupFx | System.Health.PerformanceState | BestOf | | System.Health.PerformanceState | Microsoft.SQLServer.Windows.DBFilegroupFxHostsContainer | PerformanceHealth | True | True | MatchMonitorHealth | Normal | True | True | Public |
| Containers Security | Rolls up all containers security monitors to the DB Memory-Optimized data filegroup. | Microsoft.SQLServer.Windows.Rollup.DBFilegroupFx.ContainerToDBFilegroupFxSecurity | Microsoft.SQLServer.Windows.DBFilegroupFx | System.Health.SecurityState | BestOf | | System.Health.SecurityState | Microsoft.SQLServer.Windows.DBFilegroupFxHostsContainer | SecurityHealth | True | False | | | True | True | Public |
| Availability State for Distributed Availability Group (Windows rollup) | This monitor checks if both replicas are available. The monitor becomes unhealthy when primary or secondary availability group is unhealthy. The monitor is healthy when both replicas are healthy. This monitor is a dependency (rollup) monitor. | Microsoft.SQLServer.Windows.Rollup.DistributedAvailabilityGroup.AGToDistributedAGAvailability | Microsoft.SQLServer.Core.DistributedAvailabilityGroup | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServer.Core.DistributedAvailabilityGroupContainsAvailabilityGroup | AvailabilityHealth | True | False | | | False | True | Public |