| | 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.2017.Windows.Rollup.Agent.AgentJobToAgentAvailability | Microsoft.SQLServer.2017.Windows.Agent | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServer.2017.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.2017.Windows.Rollup.Agent.AgentJobToAgentConfiguration | Microsoft.SQLServer.2017.Windows.Agent | System.Health.ConfigurationState | WorstOf | | System.Health.ConfigurationState | Microsoft.SQLServer.2017.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.2017.Windows.Rollup.Agent.AgentJobToAgentPerformance | Microsoft.SQLServer.2017.Windows.Agent | System.Health.PerformanceState | WorstOf | | System.Health.PerformanceState | Microsoft.SQLServer.2017.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.2017.Windows.Rollup.Agent.AgentJobToAgentSecurity | Microsoft.SQLServer.2017.Windows.Agent | System.Health.SecurityState | WorstOf | | System.Health.SecurityState | Microsoft.SQLServer.2017.Windows.AgentHostsAgentJob | SecurityHealth | True | False | | | False | True | Public |
| Database Critical Policies Availability | Rolls up all Database Critical Policies availability monitors to the Database. | Microsoft.SQLServer.2017.Windows.Rollup.Database.DatabaseErrorUserPolicyToDatabaseAvailability | Microsoft.SQLServer.2017.Windows.Database | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServer.2017.Windows.DatabaseHostsDBErrorUserPolicy | AvailabilityHealth | True | False | | | False | True | Public |
| Database Critical Policies Configuration | Rolls up all Database Critical Policies configuration monitors to the Database. | Microsoft.SQLServer.2017.Windows.Rollup.Database.DatabaseErrorUserPolicyToDatabaseConfiguration | Microsoft.SQLServer.2017.Windows.Database | System.Health.ConfigurationState | WorstOf | | System.Health.ConfigurationState | Microsoft.SQLServer.2017.Windows.DatabaseHostsDBErrorUserPolicy | ConfigurationHealth | True | False | | | False | True | Public |
| Database Critical Policies Performance | Rolls up all Database Critical Policies performance monitors to the Database. | Microsoft.SQLServer.2017.Windows.Rollup.Database.DatabaseErrorUserPolicyToDatabasePerformance | Microsoft.SQLServer.2017.Windows.Database | System.Health.PerformanceState | WorstOf | | System.Health.PerformanceState | Microsoft.SQLServer.2017.Windows.DatabaseHostsDBErrorUserPolicy | PerformanceHealth | True | False | | | False | True | Public |
| Database Critical Policies Security | Rolls up all Database Critical Policies security monitors to the Database. | Microsoft.SQLServer.2017.Windows.Rollup.Database.DatabaseErrorUserPolicyToDatabaseSecurity | Microsoft.SQLServer.2017.Windows.Database | System.Health.SecurityState | WorstOf | | System.Health.SecurityState | Microsoft.SQLServer.2017.Windows.DatabaseHostsDBErrorUserPolicy | SecurityHealth | True | False | | | False | True | Public |
| Database Warning Policies Availability | Rolls up all Database Warning Policies availability monitors to the Database. | Microsoft.SQLServer.2017.Windows.Rollup.Database.DatabaseWarningUserPolicyToDatabaseAvailability | Microsoft.SQLServer.2017.Windows.Database | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServer.2017.Windows.DatabaseHostsDBWarningUserPolicy | AvailabilityHealth | True | False | | | False | True | Public |
| Database Warning Policies Configuration | Rolls up all Database Warning Policies configuration monitors to the Database. | Microsoft.SQLServer.2017.Windows.Rollup.Database.DatabaseWarningUserPolicyToDatabaseConfiguration | Microsoft.SQLServer.2017.Windows.Database | System.Health.ConfigurationState | WorstOf | | System.Health.ConfigurationState | Microsoft.SQLServer.2017.Windows.DatabaseHostsDBWarningUserPolicy | ConfigurationHealth | True | False | | | False | True | Public |
| Database Warning Policies Performance | Rolls up all Database Warning Policies performance monitors to the Database. | Microsoft.SQLServer.2017.Windows.Rollup.Database.DatabaseWarningUserPolicyToDatabasePerformance | Microsoft.SQLServer.2017.Windows.Database | System.Health.PerformanceState | WorstOf | | System.Health.PerformanceState | Microsoft.SQLServer.2017.Windows.DatabaseHostsDBWarningUserPolicy | PerformanceHealth | True | False | | | False | True | Public |
| Database Warning Policies Security | Rolls up all Database Warning Policies security monitors to the Database. | Microsoft.SQLServer.2017.Windows.Rollup.Database.DatabaseWarningUserPolicyToDatabaseSecurity | Microsoft.SQLServer.2017.Windows.Database | System.Health.SecurityState | WorstOf | | System.Health.SecurityState | Microsoft.SQLServer.2017.Windows.DatabaseHostsDBWarningUserPolicy | SecurityHealth | True | False | | | False | True | Public |
| DB Memory-Optimized Data Filegroups Availability | Rolls up all DB Memory-Optimized Data Filegroups availability monitors to the Database. | Microsoft.SQLServer.2017.Windows.Rollup.Database.DBFilegroupFxToDatabaseAvailability | Microsoft.SQLServer.2017.Windows.Database | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServer.2017.Windows.DatabaseHostsDBFilegroupFx | AvailabilityHealth | True | False | | | False | True | Public |
| DB Memory-Optimized Data Filegroups Configuration | Rolls up all DB Memory-Optimized Data Filegroups configuration monitors to the Database. | Microsoft.SQLServer.2017.Windows.Rollup.Database.DBFilegroupFxToDatabaseConfiguration | Microsoft.SQLServer.2017.Windows.Database | System.Health.ConfigurationState | WorstOf | | System.Health.ConfigurationState | Microsoft.SQLServer.2017.Windows.DatabaseHostsDBFilegroupFx | ConfigurationHealth | True | False | | | False | True | Public |
| DB Memory-Optimized Data Filegroups Performance | Rolls up all DB Memory-Optimized Data Filegroups performance monitors to the Database. | Microsoft.SQLServer.2017.Windows.Rollup.Database.DBFilegroupFxToDatabasePerformance | Microsoft.SQLServer.2017.Windows.Database | System.Health.PerformanceState | WorstOf | | System.Health.PerformanceState | Microsoft.SQLServer.2017.Windows.DatabaseHostsDBFilegroupFx | PerformanceHealth | True | False | | | False | True | Public |
| DB Memory-Optimized Data Filegroups Security | Rolls up all DB Memory-Optimized Data Filegroups security monitors to the Database. | Microsoft.SQLServer.2017.Windows.Rollup.Database.DBFilegroupFxToDatabaseSecurity | Microsoft.SQLServer.2017.Windows.Database | System.Health.SecurityState | WorstOf | | System.Health.SecurityState | Microsoft.SQLServer.2017.Windows.DatabaseHostsDBFilegroupFx | SecurityHealth | True | False | | | False | True | Public |
| DB Filegroups Availability | Rolls up all DB Filegroups availability monitors to the Database. | Microsoft.SQLServer.2017.Windows.Rollup.Database.DBFilegroupToDatabaseAvailability | Microsoft.SQLServer.2017.Windows.Database | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServer.2017.Windows.DatabaseHostsDBFilegroup | AvailabilityHealth | True | False | | | False | True | Public |
| DB Filegroups Configuration | Rolls up all DB Filegroups configuration monitors to the Database. | Microsoft.SQLServer.2017.Windows.Rollup.Database.DBFilegroupToDatabaseConfiguration | Microsoft.SQLServer.2017.Windows.Database | System.Health.ConfigurationState | WorstOf | | System.Health.ConfigurationState | Microsoft.SQLServer.2017.Windows.DatabaseHostsDBFilegroup | ConfigurationHealth | True | False | | | False | True | Public |
| DB Filegroups Performance | Rolls up all DB Filegroups performance monitors to the Database. | Microsoft.SQLServer.2017.Windows.Rollup.Database.DBFilegroupToDatabasePerformance | Microsoft.SQLServer.2017.Windows.Database | System.Health.PerformanceState | WorstOf | | System.Health.PerformanceState | Microsoft.SQLServer.2017.Windows.DatabaseHostsDBFilegroup | PerformanceHealth | True | False | | | False | True | Public |
| DB Filegroups Security | Rolls up all DB Filegroups security monitors to the Database. | Microsoft.SQLServer.2017.Windows.Rollup.Database.DBFilegroupToDatabaseSecurity | Microsoft.SQLServer.2017.Windows.Database | System.Health.SecurityState | WorstOf | | System.Health.SecurityState | Microsoft.SQLServer.2017.Windows.DatabaseHostsDBFilegroup | SecurityHealth | True | False | | | False | True | Public |
| DB Log Files Availability | Rolls up all DB Log Files availability monitors to the Database. | Microsoft.SQLServer.2017.Windows.Rollup.Database.DBLogFileToDatabaseAvailability | Microsoft.SQLServer.2017.Windows.Database | System.Health.AvailabilityState | BestOf | | System.Health.AvailabilityState | Microsoft.SQLServer.2017.Windows.DatabaseHostsDBLogFile | AvailabilityHealth | True | False | | | False | True | Public |
| DB Log Files Configuration | Rolls up all DB Log Files configuration monitors to the Database. | Microsoft.SQLServer.2017.Windows.Rollup.Database.DBLogFileToDatabaseConfiguration | Microsoft.SQLServer.2017.Windows.Database | System.Health.ConfigurationState | BestOf | | System.Health.ConfigurationState | Microsoft.SQLServer.2017.Windows.DatabaseHostsDBLogFile | ConfigurationHealth | True | False | | | False | True | Public |
| DB Log Files Performance | Rolls up all DB Log Files performance monitors to the Database. | Microsoft.SQLServer.2017.Windows.Rollup.Database.DBLogFileToDatabasePerformance | Microsoft.SQLServer.2017.Windows.Database | System.Health.PerformanceState | BestOf | | System.Health.PerformanceState | Microsoft.SQLServer.2017.Windows.DatabaseHostsDBLogFile | PerformanceHealth | True | False | | | False | True | Public |
| DB Log Files Security | Rolls up all DB Log Files security monitors to the Database. | Microsoft.SQLServer.2017.Windows.Rollup.Database.DBLogFileToDatabaseSecurity | Microsoft.SQLServer.2017.Windows.Database | System.Health.SecurityState | BestOf | | System.Health.SecurityState | Microsoft.SQLServer.2017.Windows.DatabaseHostsDBLogFile | SecurityHealth | True | False | | | False | 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.2017.Windows.Rollup.Database.MemoryConsumption | Microsoft.SQLServer.2017.Windows.Database | System.Health.PerformanceState | WorstOf | | Microsoft.SQLServer.2017.Windows.Monitor.UserResourcePool.MemoryConsumption | Microsoft.SQLServer.2017.Windows.DatabaseReferencesUserResourcePool | PerformanceCollection | True | False | | | False | True | Public |
| Databases Availability | Rolls up all Databases availability monitors to the DB Engine. | Microsoft.SQLServer.2017.Windows.Rollup.DBEngine.DatabaseToDBEngineAvailability | Microsoft.SQLServer.2017.Windows.DBEngine | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServer.2017.Windows.DBEngineHostsDatabase | AvailabilityHealth | True | False | | | False | True | Public |
| Databases Configuration | Rolls up all Databases configuration monitors to the DB Engine. | Microsoft.SQLServer.2017.Windows.Rollup.DBEngine.DatabaseToDBEngineConfiguration | Microsoft.SQLServer.2017.Windows.DBEngine | System.Health.ConfigurationState | WorstOf | | System.Health.ConfigurationState | Microsoft.SQLServer.2017.Windows.DBEngineHostsDatabase | ConfigurationHealth | True | False | | | False | True | Public |
| Databases Performance | Rolls up all Databases performance monitors to the DB Engine. | Microsoft.SQLServer.2017.Windows.Rollup.DBEngine.DatabaseToDBEnginePerformance | Microsoft.SQLServer.2017.Windows.DBEngine | System.Health.PerformanceState | WorstOf | | System.Health.PerformanceState | Microsoft.SQLServer.2017.Windows.DBEngineHostsDatabase | PerformanceHealth | True | False | | | False | True | Public |
| Databases Security | Rolls up all Databases security monitors to the DB Engine. | Microsoft.SQLServer.2017.Windows.Rollup.DBEngine.DatabaseToDBEngineSecurity | Microsoft.SQLServer.2017.Windows.DBEngine | System.Health.SecurityState | WorstOf | | System.Health.SecurityState | Microsoft.SQLServer.2017.Windows.DBEngineHostsDatabase | SecurityHealth | True | False | | | False | True | Public |
| DB Files Availability | Rolls up all DB Files availability monitors to the DB Filegroup. | Microsoft.SQLServer.2017.Windows.Rollup.DBFilegroup.DBFileToDBFilegroupAvailability | Microsoft.SQLServer.2017.Windows.DBFilegroup | System.Health.AvailabilityState | BestOf | | System.Health.AvailabilityState | Microsoft.SQLServer.2017.Windows.DBFilegroupHostsDBFile | AvailabilityHealth | True | False | | | False | True | Public |
| DB Files Configuration | Rolls up all DB Files configuration monitors to the DB Filegroup. | Microsoft.SQLServer.2017.Windows.Rollup.DBFilegroup.DBFileToDBFilegroupConfiguration | Microsoft.SQLServer.2017.Windows.DBFilegroup | System.Health.ConfigurationState | BestOf | | System.Health.ConfigurationState | Microsoft.SQLServer.2017.Windows.DBFilegroupHostsDBFile | ConfigurationHealth | True | False | | | False | True | Public |
| DB Files Performance | Rolls up all DB Files performance monitors to the DB Filegroup. | Microsoft.SQLServer.2017.Windows.Rollup.DBFilegroup.DBFileToDBFilegroupPerformance | Microsoft.SQLServer.2017.Windows.DBFilegroup | System.Health.PerformanceState | BestOf | | System.Health.PerformanceState | Microsoft.SQLServer.2017.Windows.DBFilegroupHostsDBFile | PerformanceHealth | True | False | | | False | True | Public |
| DB Files Security | Rolls up all DB Files security monitors to the DB Filegroup. | Microsoft.SQLServer.2017.Windows.Rollup.DBFilegroup.DBFileToDBFilegroupSecurity | Microsoft.SQLServer.2017.Windows.DBFilegroup | System.Health.SecurityState | BestOf | | System.Health.SecurityState | Microsoft.SQLServer.2017.Windows.DBFilegroupHostsDBFile | SecurityHealth | True | False | | | False | True | Public |
| Containers Availability | Rolls up all Containers availability monitors to the DB Memory-Optimized Data Filegroup. | Microsoft.SQLServer.2017.Windows.Rollup.DBFilegroupFx.ContainerToDBFilegroupFxAvailability | Microsoft.SQLServer.2017.Windows.DBFilegroupFx | System.Health.AvailabilityState | BestOf | | System.Health.AvailabilityState | Microsoft.SQLServer.2017.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.2017.Windows.Rollup.DBFilegroupFx.ContainerToDBFilegroupFxConfiguration | Microsoft.SQLServer.2017.Windows.DBFilegroupFx | System.Health.ConfigurationState | BestOf | | System.Health.ConfigurationState | Microsoft.SQLServer.2017.Windows.DBFilegroupFxHostsContainer | ConfigurationHealth | True | False | | | False | True | Public |
| Containers Performance | Rolls up all Containers performance monitors to the DB Memory-Optimized Data Filegroup. | Microsoft.SQLServer.2017.Windows.Rollup.DBFilegroupFx.ContainerToDBFilegroupFxPerformance | Microsoft.SQLServer.2017.Windows.DBFilegroupFx | System.Health.PerformanceState | BestOf | | System.Health.PerformanceState | Microsoft.SQLServer.2017.Windows.DBFilegroupFxHostsContainer | PerformanceHealth | True | False | | | False | True | Public |
| Containers Security | Rolls up all Containers security monitors to the DB Memory-Optimized Data Filegroup. | Microsoft.SQLServer.2017.Windows.Rollup.DBFilegroupFx.ContainerToDBFilegroupFxSecurity | Microsoft.SQLServer.2017.Windows.DBFilegroupFx | System.Health.SecurityState | BestOf | | System.Health.SecurityState | Microsoft.SQLServer.2017.Windows.DBFilegroupFxHostsContainer | SecurityHealth | True | False | | | False | True | Public |
Home