All Dependency Monitors in Microsoft.SQLServer.Windows.Monitoring Management Pack

 DisplayNameDescriptionIDTargetParent MonitorAlgorithmAlgorithm ParameterSource MonitorRelationshipCategoryEnabledAlert GenerateAlert SeverityAlert PriorityAlert Auto ResolveRemotableAccessibility
Microsoft.SQLServer.Windows.Rollup.Agent.AgentJobToAgentAvailabilityAgent Jobs AvailabilityRolls up all Agent Jobs availability monitors to the SQL Server Agent.Microsoft.SQLServer.Windows.Rollup.Agent.AgentJobToAgentAvailabilityMicrosoft.SQLServer.Windows.AgentSystem.Health.AvailabilityStateWorstOfSystem.Health.AvailabilityStateMicrosoft.SQLServer.Windows.AgentHostsAgentJobAvailabilityHealthTrueFalseFalseTruePublic
Microsoft.SQLServer.Windows.Rollup.Agent.AgentJobToAgentConfigurationAgent Jobs ConfigurationRolls up all Agent Jobs configuration monitors to the SQL Server Agent.Microsoft.SQLServer.Windows.Rollup.Agent.AgentJobToAgentConfigurationMicrosoft.SQLServer.Windows.AgentSystem.Health.ConfigurationStateWorstOfSystem.Health.ConfigurationStateMicrosoft.SQLServer.Windows.AgentHostsAgentJobConfigurationHealthTrueFalseFalseTruePublic
Microsoft.SQLServer.Windows.Rollup.Agent.AgentJobToAgentPerformanceAgent Jobs PerformanceRolls up all Agent Jobs performance monitors to the SQL Server Agent.Microsoft.SQLServer.Windows.Rollup.Agent.AgentJobToAgentPerformanceMicrosoft.SQLServer.Windows.AgentSystem.Health.PerformanceStateWorstOfSystem.Health.PerformanceStateMicrosoft.SQLServer.Windows.AgentHostsAgentJobPerformanceHealthTrueFalseFalseTruePublic
Microsoft.SQLServer.Windows.Rollup.Agent.AgentJobToAgentSecurityAgent Jobs SecurityRolls up all Agent Jobs security monitors to the SQL Server Agent.Microsoft.SQLServer.Windows.Rollup.Agent.AgentJobToAgentSecurityMicrosoft.SQLServer.Windows.AgentSystem.Health.SecurityStateWorstOfSystem.Health.SecurityStateMicrosoft.SQLServer.Windows.AgentHostsAgentJobSecurityHealthTrueFalseFalseTruePublic
Microsoft.SQLServer.Windows.Rollup.AvailabilityDatabase.BackupStatusAvailability 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.BackupStatusMicrosoft.SQLServer.Core.AvailabilityDatabaseMicrosoft.SQLServer.Core.Rollup.AvailabilityDatabase.BackupStatusAggregateBestOfMicrosoft.SQLServer.Windows.Monitor.AvailabilityDatabaseHealth.BackupStatusMicrosoft.SQLServer.Windows.AvailabilityDatabaseReferencesAvailabilityDatabaseHealthAvailabilityHealthTrueFalseFalseTruePublic
Microsoft.SQLServer.Windows.Rollup.AvailabilityGroup.AllAvailabilityReplicasAreConnectedAvailability 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.AllAvailabilityReplicasAreConnectedMicrosoft.SQLServer.Core.AvailabilityGroupMicrosoft.SQLServer.Core.Rollup.AvailabilityGroup.AllAvailabilityReplicasAreConnectedWorstOfMicrosoft.SQLServer.Windows.Monitor.AvailabilityGroupHealth.AllAvailabilityReplicasAreConnectedMicrosoft.SQLServer.Windows.AvailabilityGroupReferencesAvailabilityGroupHealthAvailabilityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.AvailabilityGroup.AutomaticFailoverReadinessAvailability 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.AutomaticFailoverReadinessMicrosoft.SQLServer.Core.AvailabilityGroupMicrosoft.SQLServer.Core.Rollup.AvailabilityGroup.AutomaticFailoverReadinessWorstOfMicrosoft.SQLServer.Windows.Monitor.AvailabilityGroupHealth.AutomaticFailoverReadinessMicrosoft.SQLServer.Windows.AvailabilityGroupReferencesAvailabilityGroupHealthAvailabilityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.AvailabilityGroup.AvailabilityGroupOnlineAvailability 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.AvailabilityGroupOnlineMicrosoft.SQLServer.Core.AvailabilityGroupMicrosoft.SQLServer.Core.Rollup.AvailabilityGroup.AvailabilityGroupOnlineWorstOfMicrosoft.SQLServer.Windows.Monitor.AvailabilityGroupHealth.AvailabilityGroupOnlineMicrosoft.SQLServer.Windows.AvailabilityGroupReferencesAvailabilityGroupHealthAvailabilityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.AvailabilityGroup.AvailabilityGroupUserPolicyStateAvailability 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.AvailabilityGroupUserPolicyStateMicrosoft.SQLServer.Core.AvailabilityGroupMicrosoft.SQLServer.Core.Rollup.AvailabilityGroup.AvailabilityGroupUserPolicyStateWorstOfMicrosoft.SQLServer.Windows.Rollup.AvailabilityGroupHealth.UserPolicyAggregateMicrosoft.SQLServer.Windows.AvailabilityGroupReferencesAvailabilityGroupHealthAvailabilityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.AvailabilityGroup.AvailabilityReplicaRoleStateAvailability 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.AvailabilityReplicaRoleStateMicrosoft.SQLServer.Core.AvailabilityGroupMicrosoft.SQLServer.Core.Rollup.AvailabilityGroup.AvailabilityReplicaRoleStateWorstOfMicrosoft.SQLServer.Windows.Monitor.AvailabilityGroupHealth.AvailabilityReplicaRoleStateMicrosoft.SQLServer.Windows.AvailabilityGroupReferencesAvailabilityGroupHealthAvailabilityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.AvailabilityGroup.AvailabilityReplicasSynchronizationStateSynchronous 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.AvailabilityReplicasSynchronizationStateMicrosoft.SQLServer.Core.AvailabilityGroupMicrosoft.SQLServer.Core.Rollup.AvailabilityGroup.AvailabilityReplicasSynchronizationStateWorstOfMicrosoft.SQLServer.Windows.Monitor.AvailabilityGroupHealth.AvailabilityReplicasSynchronizationStateMicrosoft.SQLServer.Windows.AvailabilityGroupReferencesAvailabilityGroupHealthAvailabilityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.AvailabilityGroup.AvailabilityReplicasSynchronizingAvailability 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.AvailabilityReplicasSynchronizingMicrosoft.SQLServer.Core.AvailabilityGroupMicrosoft.SQLServer.Core.Rollup.AvailabilityGroup.AvailabilityReplicasSynchronizingWorstOfMicrosoft.SQLServer.Windows.Monitor.AvailabilityGroupHealth.AvailabilityReplicasSynchronizingMicrosoft.SQLServer.Windows.AvailabilityGroupReferencesAvailabilityGroupHealthAvailabilityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.AvailabilityGroupHealth.ErrorUserPolicyStateAvailability 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.ErrorUserPolicyStateMicrosoft.SQLServer.Windows.AvailabilityGroupHealthMicrosoft.SQLServer.Windows.Rollup.AvailabilityGroupHealth.UserPolicyAggregateWorstOfMicrosoft.SQLServer.Windows.Monitor.AvailabilityGroupErrorPolicy.StateMicrosoft.SQLServer.Windows.AvailabilityGroupHealthHostsAvailabilityGroupErrorUserPolicyAvailabilityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.AvailabilityGroupHealth.WarningUserPolicyStateAvailability 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.WarningUserPolicyStateMicrosoft.SQLServer.Windows.AvailabilityGroupHealthMicrosoft.SQLServer.Windows.Rollup.AvailabilityGroupHealth.UserPolicyAggregateWorstOfMicrosoft.SQLServer.Windows.Monitor.AvailabilityGroupWarningPolicy.StateMicrosoft.SQLServer.Windows.AvailabilityGroupHealthHostsAvailabilityGroupWarningUserPolicyAvailabilityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaErrorUserPolicyToAvailabilityReplicaAvailabilityAvailability Replica Critical Policies AvailabilityRolls up all Availability Replica Critical Policies availability monitors to the Availability Replica.Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaErrorUserPolicyToAvailabilityReplicaAvailabilityMicrosoft.SQLServer.Windows.AvailabilityReplicaSystem.Health.AvailabilityStateWorstOfSystem.Health.AvailabilityStateMicrosoft.SQLServer.Windows.AvailabilityReplicaHostsAvailabilityReplicaErrorUserPolicyAvailabilityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaErrorUserPolicyToAvailabilityReplicaConfigurationAvailability Replica Critical Policies ConfigurationRolls up all Availability Replica Critical Policies configuration monitors to the Availability Replica.Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaErrorUserPolicyToAvailabilityReplicaConfigurationMicrosoft.SQLServer.Windows.AvailabilityReplicaSystem.Health.ConfigurationStateWorstOfSystem.Health.ConfigurationStateMicrosoft.SQLServer.Windows.AvailabilityReplicaHostsAvailabilityReplicaErrorUserPolicyConfigurationHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaErrorUserPolicyToAvailabilityReplicaPerformanceAvailability Replica Critical Policies PerformanceRolls up all Availability Replica Critical Policies performance monitors to the Availability Replica.Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaErrorUserPolicyToAvailabilityReplicaPerformanceMicrosoft.SQLServer.Windows.AvailabilityReplicaSystem.Health.PerformanceStateWorstOfSystem.Health.PerformanceStateMicrosoft.SQLServer.Windows.AvailabilityReplicaHostsAvailabilityReplicaErrorUserPolicyPerformanceHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaErrorUserPolicyToAvailabilityReplicaSecurityAvailability Replica Critical Policies SecurityRolls up all Availability Replica Critical Policies security monitors to the Availability Replica.Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaErrorUserPolicyToAvailabilityReplicaSecurityMicrosoft.SQLServer.Windows.AvailabilityReplicaSystem.Health.SecurityStateWorstOfSystem.Health.SecurityStateMicrosoft.SQLServer.Windows.AvailabilityReplicaHostsAvailabilityReplicaErrorUserPolicySecurityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaWarningUserPolicyToAvailabilityReplicaAvailabilityAvailability Replica Warning Policies AvailabilityRolls up all Availability Replica Warning Policies availability monitors to the Availability Replica.Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaWarningUserPolicyToAvailabilityReplicaAvailabilityMicrosoft.SQLServer.Windows.AvailabilityReplicaSystem.Health.AvailabilityStateWorstOfSystem.Health.AvailabilityStateMicrosoft.SQLServer.Windows.AvailabilityReplicaHostsAvailabilityReplicaWarningUserPolicyAvailabilityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaWarningUserPolicyToAvailabilityReplicaConfigurationAvailability Replica Warning Policies ConfigurationRolls up all Availability Replica Warning Policies configuration monitors to the Availability Replica.Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaWarningUserPolicyToAvailabilityReplicaConfigurationMicrosoft.SQLServer.Windows.AvailabilityReplicaSystem.Health.ConfigurationStateWorstOfSystem.Health.ConfigurationStateMicrosoft.SQLServer.Windows.AvailabilityReplicaHostsAvailabilityReplicaWarningUserPolicyConfigurationHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaWarningUserPolicyToAvailabilityReplicaPerformanceAvailability Replica Warning Policies PerformanceRolls up all Availability Replica Warning Policies performance monitors to the Availability Replica.Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaWarningUserPolicyToAvailabilityReplicaPerformanceMicrosoft.SQLServer.Windows.AvailabilityReplicaSystem.Health.PerformanceStateWorstOfSystem.Health.PerformanceStateMicrosoft.SQLServer.Windows.AvailabilityReplicaHostsAvailabilityReplicaWarningUserPolicyPerformanceHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaWarningUserPolicyToAvailabilityReplicaSecurityAvailability Replica Warning Policies SecurityRolls up all Availability Replica Warning Policies security monitors to the Availability Replica.Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaWarningUserPolicyToAvailabilityReplicaSecurityMicrosoft.SQLServer.Windows.AvailabilityReplicaSystem.Health.SecurityStateWorstOfSystem.Health.SecurityStateMicrosoft.SQLServer.Windows.AvailabilityReplicaHostsAvailabilityReplicaWarningUserPolicySecurityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.DatabaseReplicaToAvailabilityReplicaAvailabilityDatabase Replicas AvailabilityRolls up all Database Replicas availability monitors to the Availability Replica.Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.DatabaseReplicaToAvailabilityReplicaAvailabilityMicrosoft.SQLServer.Windows.AvailabilityReplicaSystem.Health.AvailabilityStateWorstOfSystem.Health.AvailabilityStateMicrosoft.SQLServer.Windows.AvailabilityReplicaHostsDatabaseReplicaAvailabilityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.DatabaseReplicaToAvailabilityReplicaConfigurationDatabase Replicas ConfigurationRolls up all Database Replicas configuration monitors to the Availability Replica.Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.DatabaseReplicaToAvailabilityReplicaConfigurationMicrosoft.SQLServer.Windows.AvailabilityReplicaSystem.Health.ConfigurationStateWorstOfSystem.Health.ConfigurationStateMicrosoft.SQLServer.Windows.AvailabilityReplicaHostsDatabaseReplicaConfigurationHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.DatabaseReplicaToAvailabilityReplicaPerformanceDatabase Replicas PerformanceRolls up all Database Replicas performance monitors to the Availability Replica.Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.DatabaseReplicaToAvailabilityReplicaPerformanceMicrosoft.SQLServer.Windows.AvailabilityReplicaSystem.Health.PerformanceStateWorstOfSystem.Health.PerformanceStateMicrosoft.SQLServer.Windows.AvailabilityReplicaHostsDatabaseReplicaPerformanceHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.DatabaseReplicaToAvailabilityReplicaSecurityDatabase Replicas SecurityRolls up all Database Replicas security monitors to the Availability Replica.Microsoft.SQLServer.Windows.Rollup.AvailabilityReplica.DatabaseReplicaToAvailabilityReplicaSecurityMicrosoft.SQLServer.Windows.AvailabilityReplicaSystem.Health.SecurityStateWorstOfSystem.Health.SecurityStateMicrosoft.SQLServer.Windows.AvailabilityReplicaHostsDatabaseReplicaSecurityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.Database.DatabaseErrorUserPolicyToDatabaseAvailabilityDatabase Critical Policies AvailabilityRolls up all Database Critical Policies availability monitors to the Database.Microsoft.SQLServer.Windows.Rollup.Database.DatabaseErrorUserPolicyToDatabaseAvailabilityMicrosoft.SQLServer.Windows.DatabaseSystem.Health.AvailabilityStateWorstOfSystem.Health.AvailabilityStateMicrosoft.SQLServer.Windows.DatabaseHostsDBErrorUserPolicyAvailabilityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.Database.DatabaseErrorUserPolicyToDatabaseConfigurationDatabase Critical Policies ConfigurationRolls up all Database Critical Policies configuration monitors to the Database.Microsoft.SQLServer.Windows.Rollup.Database.DatabaseErrorUserPolicyToDatabaseConfigurationMicrosoft.SQLServer.Windows.DatabaseSystem.Health.ConfigurationStateWorstOfSystem.Health.ConfigurationStateMicrosoft.SQLServer.Windows.DatabaseHostsDBErrorUserPolicyConfigurationHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.Database.DatabaseErrorUserPolicyToDatabasePerformanceDatabase Critical Policies PerformanceRolls up all Database Critical Policies performance monitors to the Database.Microsoft.SQLServer.Windows.Rollup.Database.DatabaseErrorUserPolicyToDatabasePerformanceMicrosoft.SQLServer.Windows.DatabaseSystem.Health.PerformanceStateWorstOfSystem.Health.PerformanceStateMicrosoft.SQLServer.Windows.DatabaseHostsDBErrorUserPolicyPerformanceHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.Database.DatabaseErrorUserPolicyToDatabaseSecurityDatabase Critical Policies SecurityRolls up all Database Critical Policies security monitors to the Database.Microsoft.SQLServer.Windows.Rollup.Database.DatabaseErrorUserPolicyToDatabaseSecurityMicrosoft.SQLServer.Windows.DatabaseSystem.Health.SecurityStateWorstOfSystem.Health.SecurityStateMicrosoft.SQLServer.Windows.DatabaseHostsDBErrorUserPolicySecurityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.Database.DatabaseWarningUserPolicyToDatabaseAvailabilityDatabase Warning Policies AvailabilityRolls up all Database Warning Policies availability monitors to the Database.Microsoft.SQLServer.Windows.Rollup.Database.DatabaseWarningUserPolicyToDatabaseAvailabilityMicrosoft.SQLServer.Windows.DatabaseSystem.Health.AvailabilityStateWorstOfSystem.Health.AvailabilityStateMicrosoft.SQLServer.Windows.DatabaseHostsDBWarningUserPolicyAvailabilityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.Database.DatabaseWarningUserPolicyToDatabaseConfigurationDatabase Warning Policies ConfigurationRolls up all Database Warning Policies configuration monitors to the Database.Microsoft.SQLServer.Windows.Rollup.Database.DatabaseWarningUserPolicyToDatabaseConfigurationMicrosoft.SQLServer.Windows.DatabaseSystem.Health.ConfigurationStateWorstOfSystem.Health.ConfigurationStateMicrosoft.SQLServer.Windows.DatabaseHostsDBWarningUserPolicyConfigurationHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.Database.DatabaseWarningUserPolicyToDatabasePerformanceDatabase Warning Policies PerformanceRolls up all Database Warning Policies performance monitors to the Database.Microsoft.SQLServer.Windows.Rollup.Database.DatabaseWarningUserPolicyToDatabasePerformanceMicrosoft.SQLServer.Windows.DatabaseSystem.Health.PerformanceStateWorstOfSystem.Health.PerformanceStateMicrosoft.SQLServer.Windows.DatabaseHostsDBWarningUserPolicyPerformanceHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.Database.DatabaseWarningUserPolicyToDatabaseSecurityDatabase Warning Policies SecurityRolls up all Database Warning Policies security monitors to the Database.Microsoft.SQLServer.Windows.Rollup.Database.DatabaseWarningUserPolicyToDatabaseSecurityMicrosoft.SQLServer.Windows.DatabaseSystem.Health.SecurityStateWorstOfSystem.Health.SecurityStateMicrosoft.SQLServer.Windows.DatabaseHostsDBWarningUserPolicySecurityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupFdToDatabaseAvailabilityDB FILESTREAM Filegroups AvailabilityRolls up all DB FILESTREAM Filegroups availability monitors to the Database.Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupFdToDatabaseAvailabilityMicrosoft.SQLServer.Windows.DatabaseSystem.Health.AvailabilityStateWorstOfSystem.Health.AvailabilityStateMicrosoft.SQLServer.Windows.DatabaseHostsDBFilegroupFdAvailabilityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupFdToDatabaseConfigurationDB FILESTREAM Filegroups ConfigurationRolls up all DB FILESTREAM Filegroups configuration monitors to the Database.Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupFdToDatabaseConfigurationMicrosoft.SQLServer.Windows.DatabaseSystem.Health.ConfigurationStateWorstOfSystem.Health.ConfigurationStateMicrosoft.SQLServer.Windows.DatabaseHostsDBFilegroupFdConfigurationHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupFdToDatabasePerformanceDB FILESTREAM Filegroups PerformanceRolls up all DB FILESTREAM Filegroups performance monitors to the Database.Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupFdToDatabasePerformanceMicrosoft.SQLServer.Windows.DatabaseSystem.Health.PerformanceStateWorstOfSystem.Health.PerformanceStateMicrosoft.SQLServer.Windows.DatabaseHostsDBFilegroupFdPerformanceHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupFdToDatabaseSecurityDB FILESTREAM Filegroups SecurityRolls up all DB FILESTREAM Filegroups security monitors to the Database.Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupFdToDatabaseSecurityMicrosoft.SQLServer.Windows.DatabaseSystem.Health.SecurityStateWorstOfSystem.Health.SecurityStateMicrosoft.SQLServer.Windows.DatabaseHostsDBFilegroupFdSecurityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupFxToDatabaseAvailabilityDB Memory-Optimized Data Filegroups AvailabilityRolls up all DB Memory-Optimized Data Filegroups availability monitors to the Database.Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupFxToDatabaseAvailabilityMicrosoft.SQLServer.Windows.DatabaseSystem.Health.AvailabilityStateWorstOfSystem.Health.AvailabilityStateMicrosoft.SQLServer.Windows.DatabaseHostsDBFilegroupFxAvailabilityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupFxToDatabaseConfigurationDB Memory-Optimized Data Filegroups ConfigurationRolls up all DB Memory-Optimized Data Filegroups configuration monitors to the Database.Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupFxToDatabaseConfigurationMicrosoft.SQLServer.Windows.DatabaseSystem.Health.ConfigurationStateWorstOfSystem.Health.ConfigurationStateMicrosoft.SQLServer.Windows.DatabaseHostsDBFilegroupFxConfigurationHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupFxToDatabasePerformanceDB Memory-Optimized Data Filegroups PerformanceRolls up all DB Memory-Optimized Data Filegroups performance monitors to the Database.Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupFxToDatabasePerformanceMicrosoft.SQLServer.Windows.DatabaseSystem.Health.PerformanceStateWorstOfSystem.Health.PerformanceStateMicrosoft.SQLServer.Windows.DatabaseHostsDBFilegroupFxPerformanceHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupFxToDatabaseSecurityDB Memory-Optimized Data Filegroups SecurityRolls up all DB Memory-Optimized Data Filegroups security monitors to the Database.Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupFxToDatabaseSecurityMicrosoft.SQLServer.Windows.DatabaseSystem.Health.SecurityStateWorstOfSystem.Health.SecurityStateMicrosoft.SQLServer.Windows.DatabaseHostsDBFilegroupFxSecurityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupToDatabaseAvailabilityDB Filegroups AvailabilityRolls up all DB Filegroups availability monitors to the Database.Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupToDatabaseAvailabilityMicrosoft.SQLServer.Windows.DatabaseSystem.Health.AvailabilityStateWorstOfSystem.Health.AvailabilityStateMicrosoft.SQLServer.Windows.DatabaseHostsDBFilegroupAvailabilityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupToDatabaseConfigurationDB Filegroups ConfigurationRolls up all DB Filegroups configuration monitors to the Database.Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupToDatabaseConfigurationMicrosoft.SQLServer.Windows.DatabaseSystem.Health.ConfigurationStateWorstOfSystem.Health.ConfigurationStateMicrosoft.SQLServer.Windows.DatabaseHostsDBFilegroupConfigurationHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupToDatabasePerformanceDB Filegroups PerformanceRolls up all DB Filegroups performance monitors to the Database.Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupToDatabasePerformanceMicrosoft.SQLServer.Windows.DatabaseSystem.Health.PerformanceStateWorstOfSystem.Health.PerformanceStateMicrosoft.SQLServer.Windows.DatabaseHostsDBFilegroupPerformanceHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupToDatabaseSecurityDB Filegroups SecurityRolls up all DB Filegroups security monitors to the Database.Microsoft.SQLServer.Windows.Rollup.Database.DBFilegroupToDatabaseSecurityMicrosoft.SQLServer.Windows.DatabaseSystem.Health.SecurityStateWorstOfSystem.Health.SecurityStateMicrosoft.SQLServer.Windows.DatabaseHostsDBFilegroupSecurityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.Database.DBLogFileToDatabaseAvailabilityDB Log Files AvailabilityRolls up all DB Log Files availability monitors to the Database.Microsoft.SQLServer.Windows.Rollup.Database.DBLogFileToDatabaseAvailabilityMicrosoft.SQLServer.Windows.DatabaseSystem.Health.AvailabilityStateBestOfSystem.Health.AvailabilityStateMicrosoft.SQLServer.Windows.DatabaseHostsDBLogFileAvailabilityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.Database.DBLogFileToDatabaseConfigurationDB Log Files ConfigurationRolls up all DB Log Files configuration monitors to the Database.Microsoft.SQLServer.Windows.Rollup.Database.DBLogFileToDatabaseConfigurationMicrosoft.SQLServer.Windows.DatabaseSystem.Health.ConfigurationStateBestOfSystem.Health.ConfigurationStateMicrosoft.SQLServer.Windows.DatabaseHostsDBLogFileConfigurationHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.Database.DBLogFileToDatabasePerformanceDB Log Files PerformanceRolls up all DB Log Files performance monitors to the Database.Microsoft.SQLServer.Windows.Rollup.Database.DBLogFileToDatabasePerformanceMicrosoft.SQLServer.Windows.DatabaseSystem.Health.PerformanceStateBestOfSystem.Health.PerformanceStateMicrosoft.SQLServer.Windows.DatabaseHostsDBLogFilePerformanceHealthTrueTrueMatchMonitorHealthNormalTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.Database.DBLogFileToDatabaseSecurityDB Log Files SecurityRolls up all DB Log Files security monitors to the Database.Microsoft.SQLServer.Windows.Rollup.Database.DBLogFileToDatabaseSecurityMicrosoft.SQLServer.Windows.DatabaseSystem.Health.SecurityStateBestOfSystem.Health.SecurityStateMicrosoft.SQLServer.Windows.DatabaseHostsDBLogFileSecurityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.Database.MemoryConsumptionResources 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.MemoryConsumptionMicrosoft.SQLServer.Windows.DatabaseSystem.Health.PerformanceStateWorstOfMicrosoft.SQLServer.Windows.Monitor.UserResourcePool.MemoryConsumptionMicrosoft.SQLServer.Windows.DatabaseReferencesUserResourcePoolPerformanceCollectionTrueFalseFalseTruePublic
Microsoft.SQLServer.Windows.Rollup.DatabaseReplica.DatabaseReplicaErrorUserPolicyToDatabaseReplicaAvailabilityDatabase Replica Critical Policies AvailabilityRolls up all Database Replica Critical Policies availability monitors to the Database Replica.Microsoft.SQLServer.Windows.Rollup.DatabaseReplica.DatabaseReplicaErrorUserPolicyToDatabaseReplicaAvailabilityMicrosoft.SQLServer.Windows.DatabaseReplicaSystem.Health.AvailabilityStateWorstOfSystem.Health.AvailabilityStateMicrosoft.SQLServer.Windows.DatabaseReplicaHostsDatabaseReplicaErrorUserPolicyAvailabilityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.DatabaseReplica.DatabaseReplicaErrorUserPolicyToDatabaseReplicaConfigurationDatabase Replica Critical Policies ConfigurationRolls up all Database Replica Critical Policies configuration monitors to the Database Replica.Microsoft.SQLServer.Windows.Rollup.DatabaseReplica.DatabaseReplicaErrorUserPolicyToDatabaseReplicaConfigurationMicrosoft.SQLServer.Windows.DatabaseReplicaSystem.Health.ConfigurationStateWorstOfSystem.Health.ConfigurationStateMicrosoft.SQLServer.Windows.DatabaseReplicaHostsDatabaseReplicaErrorUserPolicyConfigurationHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.DatabaseReplica.DatabaseReplicaErrorUserPolicyToDatabaseReplicaPerformanceDatabase Replica Critical Policies PerformanceRolls up all Database Replica Critical Policies performance monitors to the Database Replica.Microsoft.SQLServer.Windows.Rollup.DatabaseReplica.DatabaseReplicaErrorUserPolicyToDatabaseReplicaPerformanceMicrosoft.SQLServer.Windows.DatabaseReplicaSystem.Health.PerformanceStateWorstOfSystem.Health.PerformanceStateMicrosoft.SQLServer.Windows.DatabaseReplicaHostsDatabaseReplicaErrorUserPolicyPerformanceHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.DatabaseReplica.DatabaseReplicaErrorUserPolicyToDatabaseReplicaSecurityDatabase Replica Critical Policies SecurityRolls up all Database Replica Critical Policies security monitors to the Database Replica.Microsoft.SQLServer.Windows.Rollup.DatabaseReplica.DatabaseReplicaErrorUserPolicyToDatabaseReplicaSecurityMicrosoft.SQLServer.Windows.DatabaseReplicaSystem.Health.SecurityStateWorstOfSystem.Health.SecurityStateMicrosoft.SQLServer.Windows.DatabaseReplicaHostsDatabaseReplicaErrorUserPolicySecurityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.DatabaseReplica.DatabaseReplicaWarningUserPolicyToDatabaseReplicaAvailabilityDatabase Replica Warning Policies AvailabilityRolls up all Database Replica Warning Policies availability monitors to the Database Replica.Microsoft.SQLServer.Windows.Rollup.DatabaseReplica.DatabaseReplicaWarningUserPolicyToDatabaseReplicaAvailabilityMicrosoft.SQLServer.Windows.DatabaseReplicaSystem.Health.AvailabilityStateWorstOfSystem.Health.AvailabilityStateMicrosoft.SQLServer.Windows.DatabaseReplicaHostsDatabaseReplicaWarningUserPolicyAvailabilityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.DatabaseReplica.DatabaseReplicaWarningUserPolicyToDatabaseReplicaConfigurationDatabase Replica Warning Policies ConfigurationRolls up all Database Replica Warning Policies configuration monitors to the Database Replica.Microsoft.SQLServer.Windows.Rollup.DatabaseReplica.DatabaseReplicaWarningUserPolicyToDatabaseReplicaConfigurationMicrosoft.SQLServer.Windows.DatabaseReplicaSystem.Health.ConfigurationStateWorstOfSystem.Health.ConfigurationStateMicrosoft.SQLServer.Windows.DatabaseReplicaHostsDatabaseReplicaWarningUserPolicyConfigurationHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.DatabaseReplica.DatabaseReplicaWarningUserPolicyToDatabaseReplicaPerformanceDatabase Replica Warning Policies PerformanceRolls up all Database Replica Warning Policies performance monitors to the Database Replica.Microsoft.SQLServer.Windows.Rollup.DatabaseReplica.DatabaseReplicaWarningUserPolicyToDatabaseReplicaPerformanceMicrosoft.SQLServer.Windows.DatabaseReplicaSystem.Health.PerformanceStateWorstOfSystem.Health.PerformanceStateMicrosoft.SQLServer.Windows.DatabaseReplicaHostsDatabaseReplicaWarningUserPolicyPerformanceHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.DatabaseReplica.DatabaseReplicaWarningUserPolicyToDatabaseReplicaSecurityDatabase Replica Warning Policies SecurityRolls up all Database Replica Warning Policies security monitors to the Database Replica.Microsoft.SQLServer.Windows.Rollup.DatabaseReplica.DatabaseReplicaWarningUserPolicyToDatabaseReplicaSecurityMicrosoft.SQLServer.Windows.DatabaseReplicaSystem.Health.SecurityStateWorstOfSystem.Health.SecurityStateMicrosoft.SQLServer.Windows.DatabaseReplicaHostsDatabaseReplicaWarningUserPolicySecurityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.DBEngine.DatabaseToDBEngineAvailabilityDatabases AvailabilityRolls up all Databases availability monitors to the DB Engine.Microsoft.SQLServer.Windows.Rollup.DBEngine.DatabaseToDBEngineAvailabilityMicrosoft.SQLServer.Windows.DBEngineSystem.Health.AvailabilityStateWorstOfSystem.Health.AvailabilityStateMicrosoft.SQLServer.Windows.DBEngineHostsDatabaseAvailabilityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.DBEngine.DatabaseToDBEngineConfigurationDatabases ConfigurationRolls up all Databases configuration monitors to the DB Engine.Microsoft.SQLServer.Windows.Rollup.DBEngine.DatabaseToDBEngineConfigurationMicrosoft.SQLServer.Windows.DBEngineSystem.Health.ConfigurationStateWorstOfSystem.Health.ConfigurationStateMicrosoft.SQLServer.Windows.DBEngineHostsDatabaseConfigurationHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.DBEngine.DatabaseToDBEnginePerformanceDatabases PerformanceRolls up all Databases performance monitors to the DB Engine.Microsoft.SQLServer.Windows.Rollup.DBEngine.DatabaseToDBEnginePerformanceMicrosoft.SQLServer.Windows.DBEngineSystem.Health.PerformanceStateWorstOfSystem.Health.PerformanceStateMicrosoft.SQLServer.Windows.DBEngineHostsDatabasePerformanceHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.DBEngine.DatabaseToDBEngineSecurityDatabases SecurityRolls up all Databases security monitors to the DB Engine.Microsoft.SQLServer.Windows.Rollup.DBEngine.DatabaseToDBEngineSecurityMicrosoft.SQLServer.Windows.DBEngineSystem.Health.SecurityStateWorstOfSystem.Health.SecurityStateMicrosoft.SQLServer.Windows.DBEngineHostsDatabaseSecurityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.DBFilegroup.DBFileToDBFilegroupAvailabilityDB Files AvailabilityRolls up all DB Files availability monitors to the DB Filegroup.Microsoft.SQLServer.Windows.Rollup.DBFilegroup.DBFileToDBFilegroupAvailabilityMicrosoft.SQLServer.Windows.DBFilegroupSystem.Health.AvailabilityStateBestOfSystem.Health.AvailabilityStateMicrosoft.SQLServer.Windows.DBFilegroupHostsDBFileAvailabilityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.DBFilegroup.DBFileToDBFilegroupConfigurationDB Files ConfigurationRolls up all DB Files configuration monitors to the DB Filegroup.Microsoft.SQLServer.Windows.Rollup.DBFilegroup.DBFileToDBFilegroupConfigurationMicrosoft.SQLServer.Windows.DBFilegroupSystem.Health.ConfigurationStateBestOfSystem.Health.ConfigurationStateMicrosoft.SQLServer.Windows.DBFilegroupHostsDBFileConfigurationHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.DBFilegroup.DBFileToDBFilegroupPerformanceDB Files PerformanceRolls up all DB Files performance monitors to the DB Filegroup.Microsoft.SQLServer.Windows.Rollup.DBFilegroup.DBFileToDBFilegroupPerformanceMicrosoft.SQLServer.Windows.DBFilegroupSystem.Health.PerformanceStateBestOfSystem.Health.PerformanceStateMicrosoft.SQLServer.Windows.DBFilegroupHostsDBFilePerformanceHealthTrueTrueMatchMonitorHealthNormalTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.DBFilegroup.DBFileToDBFilegroupSecurityDB Files SecurityRolls up all DB Files security monitors to the DB Filegroup.Microsoft.SQLServer.Windows.Rollup.DBFilegroup.DBFileToDBFilegroupSecurityMicrosoft.SQLServer.Windows.DBFilegroupSystem.Health.SecurityStateBestOfSystem.Health.SecurityStateMicrosoft.SQLServer.Windows.DBFilegroupHostsDBFileSecurityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.DBFilegroupFx.ContainerToDBFilegroupFxAvailabilityContainers AvailabilityRolls up all Containers availability monitors to the DB Memory-Optimized Data Filegroup.Microsoft.SQLServer.Windows.Rollup.DBFilegroupFx.ContainerToDBFilegroupFxAvailabilityMicrosoft.SQLServer.Windows.DBFilegroupFxSystem.Health.AvailabilityStateBestOfSystem.Health.AvailabilityStateMicrosoft.SQLServer.Windows.DBFilegroupFxHostsContainerAvailabilityHealthTrueFalseFalseTruePublic
Microsoft.SQLServer.Windows.Rollup.DBFilegroupFx.ContainerToDBFilegroupFxConfigurationContainers ConfigurationRolls up all Containers configuration monitors to the DB Memory-Optimized Data Filegroup.Microsoft.SQLServer.Windows.Rollup.DBFilegroupFx.ContainerToDBFilegroupFxConfigurationMicrosoft.SQLServer.Windows.DBFilegroupFxSystem.Health.ConfigurationStateBestOfSystem.Health.ConfigurationStateMicrosoft.SQLServer.Windows.DBFilegroupFxHostsContainerConfigurationHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.DBFilegroupFx.ContainerToDBFilegroupFxPerformanceContainers PerformanceRolls up all Containers performance monitors to the DB Memory-Optimized Data Filegroup.Microsoft.SQLServer.Windows.Rollup.DBFilegroupFx.ContainerToDBFilegroupFxPerformanceMicrosoft.SQLServer.Windows.DBFilegroupFxSystem.Health.PerformanceStateBestOfSystem.Health.PerformanceStateMicrosoft.SQLServer.Windows.DBFilegroupFxHostsContainerPerformanceHealthTrueTrueMatchMonitorHealthNormalTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.DBFilegroupFx.ContainerToDBFilegroupFxSecurityContainers SecurityRolls up all Containers security monitors to the DB Memory-Optimized Data Filegroup.Microsoft.SQLServer.Windows.Rollup.DBFilegroupFx.ContainerToDBFilegroupFxSecurityMicrosoft.SQLServer.Windows.DBFilegroupFxSystem.Health.SecurityStateBestOfSystem.Health.SecurityStateMicrosoft.SQLServer.Windows.DBFilegroupFxHostsContainerSecurityHealthTrueFalseTrueTruePublic
Microsoft.SQLServer.Windows.Rollup.DistributedAvailabilityGroup.AGToDistributedAGAvailabilityAvailability 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.AGToDistributedAGAvailabilityMicrosoft.SQLServer.Core.DistributedAvailabilityGroupSystem.Health.AvailabilityStateWorstOfSystem.Health.AvailabilityStateMicrosoft.SQLServer.Core.DistributedAvailabilityGroupContainsAvailabilityGroupAvailabilityHealthTrueFalseFalseTruePublic