| | DisplayName | Description | ID | Target | Parent Monitor | Category | Enabled | Instance Name | Counter Name | Frequency | Alert Generate | Alert Severity | Alert Priority | Alert Auto Resolve | Monitor Type | Remotable | Accessibility | RunAs |
|---|
 | Source Log Shipping | This monitor detects when a log shipping source has not had its logs backed up within the threshold defined as a part of the log shipping configuration. Note that no Log Shipping is supported by any edition of SQL Server Express. | Microsoft.SQLServer.Windows.Database.LogShippingSourceMonitor | Microsoft.SQLServer.Windows.Database | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Windows.MonitorType.Database.LogShipping | True | Public | |
| Securables Configuration Status | This monitor checks the status of SQL Server securables access configuration on Windows. | Microsoft.SQLServer.Windows.DBEngine.Configuration.SecurablesConfigMonitor | Microsoft.SQLServer.Windows.DBEngine | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Windows.MonitorType.SecurablesConfig | True | Public | |
| Service Principal Name Configuration Status | This monitor checks the status of the Microsoft SQL Server instance Service Principal Name configuration. Note that the monitor is always in "Healthy" state for non-domain-joined machines. Note that this monitor is disabled by default. Use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.DBEngine.Configuration.SPNStatusMonitor | Microsoft.SQLServer.Windows.LocalDBEngine | System.Health.ConfigurationState | AvailabilityHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Windows.DBEngine.Configuration.SPNStatus | True | Public | |
| Destination Log Shipping | This monitor detects when a log-shipping destination has not had a log restored to it within the threshold defined as a part of the log-shipping configuration. Note that no Log Shipping is supported by any edition of SQL Server Express. | Microsoft.SQLServer.Windows.LogShippingDestinationMonitor | Microsoft.SQLServer.Windows.Database | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Windows.MonitorType.Database.LogShipping | True | Public | |
| Long Running Jobs | This monitor checks for long running SQL Agent jobs. Note that this monitor is disabled by default. Use overrides to enable it when necessary.
Note that SQL Server Agent Service is not supported by any edition of SQL Server Express. | Microsoft.SQLServer.Windows.Monitor.Agent.LongRunningJobs | Microsoft.SQLServer.Windows.Agent | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.Windows.MonitorType.Agent.LongRunningJobs | True | Public | |
| SQL Server Agent Service | This monitor checks the status of the SQL Agent service for this instance of SQL Server.
Note that SQL Server Agent Windows Service is not supported by any edition of SQL Server Express. | Microsoft.SQLServer.Windows.Monitor.Agent.ServiceStatus | Microsoft.SQLServer.Windows.Agent | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.Windows.MonitorType.SqlServiceStatus | True | Public | |
| Job Duration | This monitor checks the Agent Job Duration. Note that SQL Server Agent Windows Service is not supported by any edition of SQL Server Express. | Microsoft.SQLServer.Windows.Monitor.AgentJob.Duration | Microsoft.SQLServer.Windows.AgentJob | System.Health.PerformanceState | PerformanceCollection | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.Windows.MonitorType.AgentJob.Duration | True | Public | |
| Last Run Status | This monitor checks the last run state of the SQL Agent Job. Note that SQL Server Agent Windows Service is not supported by any edition of SQL Server Express. | Microsoft.SQLServer.Windows.Monitor.AgentJob.LastRunState | Microsoft.SQLServer.Windows.AgentJob | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Windows.MonitorType.AgentJob.LastRunState | True | Public | |
| Availability Database Backup Status | This monitor checks availability of a full database backup and its age as reported by Microsoft SQL Server, it does not apply any logic regarding the replicas preferred for the backup. Note that this monitor is disabled by default. Use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.AvailabilityDatabaseHealth.BackupStatus | Microsoft.SQLServer.Windows.AvailabilityDatabaseHealth | System.Health.AvailabilityState | AvailabilityHealth | False | | | 0 | False | | | True | Microsoft.SQLServer.Windows.MonitorType.AvailabilityDatabaseHealth.BackupStatus | True | Public | |
| Availability Database Log Backup Status | This monitor checks the status of the database log backup as reported by Microsoft SQL Server, it does not apply any logic regarding the replicas preferred for the backup. Note that this monitor is disabled by default. Use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.AvailabilityDatabaseHealth.DBLogBackupStatus | Microsoft.SQLServer.Windows.AvailabilityDatabaseHealth | System.Health.AvailabilityState | AvailabilityHealth | False | | | 0 | False | | | True | Microsoft.SQLServer.Windows.MonitorType.AvailabilityDatabaseHealth.DBLogBackupStatus | True | Public | |
| Availability Group Health Policy | This is a two-state monitor with the 'Error' critical state used for reflecting the state of Custom User Policies that have Availability Group as Facet and one of the predefined error categories as Policy Category. | Microsoft.SQLServer.Windows.Monitor.AvailabilityGroupErrorPolicy.State | Microsoft.SQLServer.Windows.AvailabilityGroupErrorUserPolicy | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | True | Microsoft.SQLServer.Windows.MonitorType.UserPolicy | True | Public | |
| Availability Replicas Connection monitor | 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. | Microsoft.SQLServer.Windows.Monitor.AvailabilityGroupHealth.AllAvailabilityReplicasAreConnected | Microsoft.SQLServer.Windows.AvailabilityGroupHealth | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | True | Microsoft.SQLServer.Windows.MonitorType.AlwaysOnSystemPolicyWithSampling | True | Public | |
| Availability Group Automatic Failover monitor | This monitor checks whether 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. | Microsoft.SQLServer.Windows.Monitor.AvailabilityGroupHealth.AutomaticFailoverReadiness | Microsoft.SQLServer.Windows.AvailabilityGroupHealth | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | True | Microsoft.SQLServer.Windows.MonitorType.AlwaysOnSystemPolicyWithSampling | True | Public | |
| Availability Group Online monitor | Availability Group Online | Microsoft.SQLServer.Windows.Monitor.AvailabilityGroupHealth.AvailabilityGroupOnline | Microsoft.SQLServer.Windows.AvailabilityGroupHealth | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | True | Microsoft.SQLServer.Windows.MonitorType.AlwaysOnSystemPolicyWithSampling | True | Public | |
| Availability Replicas Role monitor | 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. | Microsoft.SQLServer.Windows.Monitor.AvailabilityGroupHealth.AvailabilityReplicaRoleState | Microsoft.SQLServer.Windows.AvailabilityGroupHealth | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | True | Microsoft.SQLServer.Windows.MonitorType.AlwaysOnSystemPolicyWithSampling | True | Public | |
| Synchronous Replicas Data Synchronization monitor | 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. | Microsoft.SQLServer.Windows.Monitor.AvailabilityGroupHealth.AvailabilityReplicasSynchronizationState | Microsoft.SQLServer.Windows.AvailabilityGroupHealth | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | True | Microsoft.SQLServer.Windows.MonitorType.AlwaysOnSystemPolicyWithSampling | True | Public | |
| Availability Replicas Data Synchronization monitor | 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. | Microsoft.SQLServer.Windows.Monitor.AvailabilityGroupHealth.AvailabilityReplicasSynchronizing | Microsoft.SQLServer.Windows.AvailabilityGroupHealth | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | True | Microsoft.SQLServer.Windows.MonitorType.AlwaysOnSystemPolicyWithSampling | True | Public | |
| Availability Group Health Policy | This is a two-state monitor with the 'Warning' critical state used for reflecting the state of Custom User Policies that have Availability Group as Facet and one of the predefined warning categories as Policy Category. | Microsoft.SQLServer.Windows.Monitor.AvailabilityGroupWarningPolicy.State | Microsoft.SQLServer.Windows.AvailabilityGroupWarningUserPolicy | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | True | Microsoft.SQLServer.Windows.MonitorType.UserPolicy | True | Public | |
| Availability Replica Data Synchronization | This monitor rolls up the data synchronization state of all database replica in the availability replica. The monitor is unhealthy when any database replica is not in the expected data synchronization state. The monitor is healthy otherwise. | Microsoft.SQLServer.Windows.Monitor.AvailabilityReplica.DataSynchronizationHealth | Microsoft.SQLServer.Windows.AvailabilityReplica | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.Windows.MonitorType.AlwaysOnSystemPolicy | True | Public | |
| Availability Replica Connection | This monitor checks the connection state between Availability Replicas. The monitor is unhealthy when the Availability Replica’s connection state is DISCONNECTED. The monitor is healthy otherwise. | Microsoft.SQLServer.Windows.Monitor.AvailabilityReplica.IsConnected | Microsoft.SQLServer.Windows.AvailabilityReplica | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.Windows.MonitorType.AlwaysOnSystemPolicy | True | Public | |
| Availability Replica Role | This monitor checks the state of the role of Availability Replica. The monitor is unhealthy when the Availability Replica role is neither primary nor secondary. The monitor is healthy otherwise. | Microsoft.SQLServer.Windows.Monitor.AvailabilityReplica.RoleIsHealthy | Microsoft.SQLServer.Windows.AvailabilityReplica | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.Windows.MonitorType.AlwaysOnSystemPolicy | True | Public | |
| Availability Replica Health Policy | This is a two-state monitor with the 'Error' critical state used for reflecting the state of Custom User Policies that have Availability Replica as Facet and one of the predefined error categories as Policy Category. | Microsoft.SQLServer.Windows.Monitor.AvailabilityReplicaErrorPolicy.State | Microsoft.SQLServer.Windows.AvailabilityReplicaErrorUserPolicy | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | True | Microsoft.SQLServer.Windows.MonitorType.UserPolicy | True | Public | |
| Availability Replica Health Policy | This is a two-state monitor with the 'Warning' critical state used for reflecting the state of Custom User Policies that have Availability Replica as Facet and one of the predefined warning categories as Policy Category. | Microsoft.SQLServer.Windows.Monitor.AvailabilityReplicaWarningPolicy.State | Microsoft.SQLServer.Windows.AvailabilityReplicaWarningUserPolicy | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | True | Microsoft.SQLServer.Windows.MonitorType.UserPolicy | True | Public | |
| Memory-Optimized Data Filegroup Container Free Space | The monitor reports a warning when the available disk space for the Memory-Optimized data filegroup container drops below the Warning Threshold setting, expressed as percentage of the sum of the Memory-Optimized data filegroup container size plus disk free space. The monitor reports a critical alert when the free space drops below the Critical Threshold. Note that this monitor is disabled by default. Use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.Container.FreeSpacePercent | Microsoft.SQLServer.Windows.Container | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.Windows.MonitorType.Container.FreeSpacePercent | True | Public | |
| Auto Close Configuration | Monitors the Auto Close setting for the database on Windows. Note that this monitor is disabled by default. Use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.Database.AutoCloseConfiguration | Microsoft.SQLServer.Windows.Database | Microsoft.SQLServer.Windows.Rollup.Database.AutomaticConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Windows.MonitorType.Database.DBConfigurationStatus | True | Public | |
| Auto Create Statistics Configuration | Monitors the Auto Create Statistic setting for the database. Note that this monitor is disabled by default. Use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.Database.AutoCreateStatConfiguration | Microsoft.SQLServer.Windows.Database | Microsoft.SQLServer.Windows.Rollup.Database.AutomaticConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Windows.MonitorType.Database.DBConfigurationStatus | True | Public | |
| Auto Shrink Configuration | Monitors the Auto Shrink setting for the database. Note that this monitor is disabled by default. Use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.Database.AutoShrinkConfiguration | Microsoft.SQLServer.Windows.Database | Microsoft.SQLServer.Windows.Rollup.Database.AutomaticConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Windows.MonitorType.Database.DBConfigurationStatus | True | Public | |
| Auto Update Statistics Async Configuration | Monitors the Auto Update Statistics Asynchronously setting for the database. Note that this monitor is disabled by default. Use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.Database.AutoUpdateStatAsyncConfiguration | Microsoft.SQLServer.Windows.Database | Microsoft.SQLServer.Windows.Rollup.Database.AutomaticConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Windows.MonitorType.Database.DBConfigurationStatus | True | Public | |
| Auto Update Statistics Configuration | Monitors the Auto Update Statistics setting for the database. Note that this monitor is disabled by default. Use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.Database.AutoUpdateStatConfiguration | Microsoft.SQLServer.Windows.Database | Microsoft.SQLServer.Windows.Rollup.Database.AutomaticConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Windows.MonitorType.Database.DBConfigurationStatus | True | Public | |
| Database Backup Status | This monitor checks the status of the database backup as reported by Microsoft SQL Server. Note that this monitor is disabled by default. Use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.Database.DBBackupStatus | Microsoft.SQLServer.Windows.Database | System.Health.AvailabilityState | AvailabilityHealth | False | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Windows.MonitorType.Database.DBBackupStatus | True | Public | |
| DB Chaining Configuration | Monitors the Cross-database Ownership Chaining Enabled setting for the database. Note that this monitor is disabled by default. Use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.Database.DBChainingConfiguration | Microsoft.SQLServer.Windows.Database | Microsoft.SQLServer.Windows.Rollup.Database.ExternalAccessConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Windows.MonitorType.Database.DBConfigurationStatus | True | Public | |
| DB Disk Read Latency | Monitors the disk Read latency (ms) from all logical disks which host database files. Note that this monitor is disabled by default. Use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.Database.DBDiskReadLatency | Microsoft.SQLServer.Windows.Database | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | High | True | Microsoft.SQLServer.Windows.MonitorType.Database.DBDiskReadLatency | True | Public | |
| DB Disk Write Latency | Monitors the disk Write latency (ms) from all logical disks which host database files. Note that this monitor is disabled by default. Use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.Database.DBDiskWriteLatency | Microsoft.SQLServer.Windows.Database | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | High | True | Microsoft.SQLServer.Windows.MonitorType.Database.DBDiskWriteLatency | True | Public | |
| Database Log Backup Status | This monitor checks the status of the database log backup as reported by Microsoft SQL Server. Note that this monitor is disabled by default. Use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.Database.DBLogBackupStatus | Microsoft.SQLServer.Windows.Database | System.Health.AvailabilityState | AvailabilityHealth | False | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Windows.MonitorType.Database.DBLogBackupStatus | True | Public | |
| Database Status | This monitor checks the status of the database as reported by Microsoft SQL Server. | Microsoft.SQLServer.Windows.Monitor.Database.DBStatus | Microsoft.SQLServer.Windows.Database | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.Windows.MonitorType.Database.DBStatus | True | Public | |
| FILESTREAM Data Free Space Left | Monitors the space available in the database and on the media hosting the database in percentage term, capacity, or using both at the same time. This monitor does not count the available space for FILESTREAM and Memory-Optimized data filegroups. Note that this monitor is disabled by default. Use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.Database.FilestreamSizePercent | Microsoft.SQLServer.Windows.Database | Microsoft.SQLServer.Windows.Rollup.Database.DBSpace | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | High | True | Microsoft.SQLServer.Windows.MonitorType.Database.DBSize | True | Public | |
| In-Memory OLTP Data Free Space Left | Monitors the space available in the database and on the media hosting the database in percentage term, capacity, or using both at the same time. This monitor does not count the available space for FILESTREAM and In-Memory OLTP data filegroups. Note that this monitor is disabled by default. Use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.Database.InMemoryOltpSizePercent | Microsoft.SQLServer.Windows.Database | Microsoft.SQLServer.Windows.Rollup.Database.DBSpace | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | High | True | Microsoft.SQLServer.Windows.MonitorType.Database.DBSize | True | Public | |
| Page Verify Configuration | Monitors the Page Verify setting for the database. Note that this monitor is disabled by default. Use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.Database.PageVerifyConfiguration | Microsoft.SQLServer.Windows.Database | Microsoft.SQLServer.Windows.Rollup.Database.RecoveryConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Windows.MonitorType.Database.DBConfigurationStatus | True | Public | |
| Recovery Model Configuration | Monitors the Recovery model setting for the database. Note that this monitor is disabled by default. Use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.Database.RecoveryModelConfiguration | Microsoft.SQLServer.Windows.Database | Microsoft.SQLServer.Windows.Rollup.Database.RecoveryConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Windows.MonitorType.Database.DBConfigurationStatus | True | Public | |
| ROWS Data Free Space Left | Monitors the space available in the database and on the media hosting the database in the percentage term, capacity, or using both at the same time. This monitor does not count free space for FILESTREAM and In-Memory OLTP data filegroups. | Microsoft.SQLServer.Windows.Monitor.Database.RowsSizePercent | Microsoft.SQLServer.Windows.Database | Microsoft.SQLServer.Windows.Rollup.Database.DBSpace | PerformanceHealth | True | | | 0 | True | MatchMonitorHealth | High | True | Microsoft.SQLServer.Windows.MonitorType.Database.DBSize | True | Public | |
| ROWS Data Space Percentage Change | Monitors for a significant decrease of ROWS data free space over a number of sample periods. Note that this monitor is disabled by default. Use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.Database.RowsSizePercentageChange | Microsoft.SQLServer.Windows.Database | Microsoft.SQLServer.Windows.Rollup.Database.DBSpace | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.Windows.MonitorType.Database.DBPercentageChange | True | Public | |
| Securables Configuration Status | This monitor checks the status of SQL Server securables access configuration on Windows. | Microsoft.SQLServer.Windows.Monitor.Database.SecurablesDbConfig | Microsoft.SQLServer.Windows.Database | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Windows.MonitorType.Database.SecurablesDbConfig | True | Public | |
| MSSQL on Windows: SQL Server Windows Service | This monitor checks the status of the local SQL Server Database Engine service. | Microsoft.SQLServer.Windows.Monitor.Database.ServiceStatus | Microsoft.SQLServer.Windows.LocalDatabase | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | True | Microsoft.SQLServer.Windows.MonitorType.LocalDatabase.DBServiceStatus | True | Public | |
| TDE Certificate Backup Status | This monitor checks that the certificate used for encrypting the database encryption key hasn't been backed up. Note that this monitor is disabled by default. Use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.Database.TdeDekCertBackupStatus | Microsoft.SQLServer.Windows.Database | System.Health.SecurityState | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Windows.MonitorType.Database.TdeDekCertBackupStatus | True | Public | |
| LOG Free Space Left | Monitors the space available in the database transactional log in percentage term, capacity, or using both at the same time. | Microsoft.SQLServer.Windows.Monitor.Database.TransactionLogSpaceFreePercent | Microsoft.SQLServer.Windows.Database | Microsoft.SQLServer.Windows.Rollup.Database.DBSpace | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Windows.MonitorType.Database.TransactionLogSpaceFreePercent | True | Public | |
| Trustworthy Configuration | Monitors the Trustworthy setting for the database. Note that this monitor is disabled by default. Use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.Database.TrustWorthyConfiguration | Microsoft.SQLServer.Windows.Database | Microsoft.SQLServer.Windows.Rollup.Database.ExternalAccessConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Windows.MonitorType.Database.DBConfigurationStatus | True | Public | |
| Virtual Log File Count | Virtual Log File Count monitor for SQL DBs on Windows. Note that this monitor is disabled by default. Use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.Database.VLFCount | Microsoft.SQLServer.Windows.Database | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.Windows.MonitorType.Database.VLFCount | True | Public | |
| Database Health Policy | Two-state monitor with 'Error' critical state used particularly for reflecting state of Custom User Policies, which have Database as Facet and one of the predefined error categories as Policy Category. | Microsoft.SQLServer.Windows.Monitor.DatabaseErrorUserPolicy.DBErrorUserPolicyState | Microsoft.SQLServer.Windows.DatabaseErrorUserPolicy | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Windows.MonitorType.UserPolicy | True | Public | |
| Availability Database Data Synchronization | This monitor checks the data synchronization state of the database replica. The monitor is unhealthy when the data synchronization state is NOT SYNCHRONIZING or the state is not SYNCHRONIZED for a synchronous commit database replica. | Microsoft.SQLServer.Windows.Monitor.DatabaseReplica.DataSynchronizationState | Microsoft.SQLServer.Windows.DatabaseReplica | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.Windows.MonitorType.AlwaysOnSystemPolicy | True | Public | |
| Availability Database Suspension State | This monitor checks the state of data movement of the database replica. The monitor is unhealthy when the data movement is suspended. The monitor is healthy otherwise. | Microsoft.SQLServer.Windows.Monitor.DatabaseReplica.SuspendState | Microsoft.SQLServer.Windows.DatabaseReplica | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.Windows.MonitorType.AlwaysOnSystemPolicy | True | Public | |
| Database Replica Health Policy | Two-state monitor with 'Error' critical state used particularly for reflecting state of Custom User Policies, which have Database Replica State as Facet and one of the predefined error categories as Policy Category. | Microsoft.SQLServer.Windows.Monitor.DatabaseReplicaErrorPolicy.State | Microsoft.SQLServer.Windows.DatabaseReplicaErrorUserPolicy | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | True | Microsoft.SQLServer.Windows.MonitorType.UserPolicy | True | Public | |
| Database Replica Health Policy | Two-state monitor with 'Warning' critical state used particularly for reflecting state of Custom User Policies, which have Database Replica State as Facet and one of the predefined warning categories as Policy Category. | Microsoft.SQLServer.Windows.Monitor.DatabaseReplicaWarningPolicy.State | Microsoft.SQLServer.Windows.DatabaseReplicaWarningUserPolicy | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | True | Microsoft.SQLServer.Windows.MonitorType.UserPolicy | True | Public | |
| Database Health Policy | Two-state monitor with 'Warning' critical state used particularly for reflecting state of Custom User Policies, which have Database as Facet and one of the predefined warning categories as Policy Category. | Microsoft.SQLServer.Windows.Monitor.DatabaseWarningUserPolicy.DBWarningUserPolicyState | Microsoft.SQLServer.Windows.DatabaseWarningUserPolicy | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Windows.MonitorType.UserPolicy | True | Public | |
| Average Wait Time | Average Wait Time monitor for DBs | Microsoft.SQLServer.Windows.Monitor.DBEngine.AverageWaitTime | Microsoft.SQLServer.Windows.DBEngine | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Windows.MonitorType.DBEngine.AverageWaitTime | True | Public | |
| Blocking Sessions | Monitors blocked sessions for a SQL instance on Windows. Note that this monitor is disabled by default. Use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.DBEngine.BlockingSessions | Microsoft.SQLServer.Windows.DBEngine | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | Error | High | True | Microsoft.SQLServer.Windows.MonitorType.DBEngine.BlockingSessions | True | Public | |
| Buffer Cache Hit Ratio | Buffer Cache Hit Ratio for DB Engine. Note that this monitor is disabled by default. Use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.DBEngine.BufferCacheHitRatio | Microsoft.SQLServer.Windows.DBEngine | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Windows.MonitorType.DBEngine.BufferCacheHitRatio | True | Public | |
| CPU Utilization (\%) | CPU Utilization (\%) for MSSQL DB Engine. Note: there is a known issue with the CPU Utilization performance monitor, which can sometimes display values greater than 100. | Microsoft.SQLServer.Windows.Monitor.DBEngine.CPUUtilization | Microsoft.SQLServer.Windows.DBEngine | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Windows.MonitorType.DBEngine.CPUUtilization | True | Public | |
| DB Engine Health Status | This monitor checks the health state of the SQL Server DB Engine. | Microsoft.SQLServer.Windows.Monitor.DBEngine.DBEngineStatus | Microsoft.SQLServer.Windows.DBEngine | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Windows.MonitorType.DBEngine.DBEngineStatus | True | Public | |
| DB Engine Disk Read Latency | Targets to DB Engine and monitors the disk Read latency (ms) from all logical disks that host database files. Note that this monitor is disabled by default. Use overrides to enable it when necessary. Note that the Linux platform is not supported. | Microsoft.SQLServer.Windows.Monitor.DBEngine.DiskReadLatency | Microsoft.SQLServer.Windows.DBEngine | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | High | True | Microsoft.SQLServer.Windows.MonitorType.DBEngine.DiskLatency | True | Public | |
| DB Engine Disk Write Latency | Targets to DB Engine and monitors the disk Write latency (ms) from all logical disks that host database files. Note that this monitor is disabled by default. Use overrides to enable it when necessary. Note that the Linux platform is not supported. | Microsoft.SQLServer.Windows.Monitor.DBEngine.DiskWriteLatency | Microsoft.SQLServer.Windows.DBEngine | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | High | True | Microsoft.SQLServer.Windows.MonitorType.DBEngine.DiskLatency | True | Public | |
| SQL Full-text Filter Daemon Launcher Service | This monitor checks the status of the SQL Full-text Filter Daemon Launcher service. Note that SQL Full-text Search feature is not available in any edition of SQL Server Express, except SQL Server Express with Advanced Services. This monitor is disabled by default. Use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.DBEngine.FullTextServiceStatus | Microsoft.SQLServer.Windows.DBEngine | System.Health.AvailabilityState | AvailabilityHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.Windows.MonitorType.SqlServiceStatus | True | Public | |
| Page Life Expectancy | Page Life Expectancy (in seconds) for DB Engine. Note that this monitor is disabled by default. Use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.DBEngine.PageLifeExpectancy | Microsoft.SQLServer.Windows.DBEngine | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Windows.MonitorType.DBEngine.PageLifeExpectancy | True | Public | |
| Product Version Compliance | This monitor checks the product version number of the current SQL Server instance to determine the currently installed Cumulative Update. | Microsoft.SQLServer.Windows.Monitor.DBEngine.ServicePackLevel | Microsoft.SQLServer.Windows.DBEngine | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.Windows.MonitorType.DBEngine.ServicePackLevel | True | Public | |
| Managed Backup System Health Policy | The Managed Backup System Health Policy produces errors like lack of or invalid SQL Credentials, connectivity errors and reports the health of the system. Note that this monitor is disabled by default. Use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.DBEngine.SmartAdminSystemHealthPolicy | Microsoft.SQLServer.Windows.DBEngine | System.Health.AvailabilityState | AvailabilityHealth | False | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Windows.MonitorType.DBEngine.SmartAdminHealthPolicy | True | Public | |
| Managed Backup User Action Health Policy | The Managed Backup User Action Health Policy monitor produces warnings when corrupted backups are found. Note that this monitor is disabled by default. Use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.DBEngine.SmartAdminUserActionHealthPolicy | Microsoft.SQLServer.Windows.DBEngine | System.Health.AvailabilityState | AvailabilityHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Windows.MonitorType.DBEngine.SmartAdminHealthPolicy | True | Public | |
| SQL Re-Compilation | SQL Re-Compilation for DB Engine. Note that this monitor is disabled by default. Use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.DBEngine.SQLRecompilation | Microsoft.SQLServer.Windows.DBEngine | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Windows.MonitorType.DBEngine.SQLRecompilation | True | Public | |
| Stolen Server Memory | Stolen Server Memory for DB Engine | Microsoft.SQLServer.Windows.Monitor.DBEngine.StolenServerMemory | Microsoft.SQLServer.Windows.DBEngine | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Windows.MonitorType.DBEngine.StolenServerMemory | True | Public | |
| Thread Count | Monitors free thread count for Microsoft SQL Server instance on Windows. | Microsoft.SQLServer.Windows.Monitor.DBEngine.ThreadCount | Microsoft.SQLServer.Windows.DBEngine | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Windows.MonitorType.DBEngine.ThreadCount | True | Public | |
| DB File Free Space Left | The monitor reports a warning when the free space (including both already allocated space and free space on the media) drops below the Warning Threshold setting, expressed as percentage of the sum of data size plus disk free space. The monitor reports a critical alert when the free space drops below the Critical Threshold. Note that this monitor is disabled by default. Use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.DBFile.DBFileSpace | Microsoft.SQLServer.Windows.DBFile | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.Windows.MonitorType.DBFile.DBFileSpace | True | Public | |
| DB FILESTREAM Filegroup Free Space | The monitor reports a warning when the free space drops below the Warning Threshold setting, expressed as percentage of the sum of data size. The monitor reports a critical alert when the free space drops below the Critical Threshold. Note that this monitor is disabled by default. Use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.DBFilegroupFd.GroupSpace | Microsoft.SQLServer.Windows.DBFilegroupFd | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.Windows.MonitorType.DBFilegroupFd.GroupSpace | True | Public | |
| The average length of the row chains in the hash buckets | This monitor checks Hash Index Empty Buckets Count and Average Length of the Row Chains in the SQL Database. | Microsoft.SQLServer.Windows.Monitor.DBFilegroupFx.HashIndexAvgChainLength | Microsoft.SQLServer.Windows.DBFilegroupFx | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Windows.MonitorType.DBFilegroupFx.HashIndexAvgChainLength | True | Public | |
| Empty Bucket percent in the hash index | This monitor checks Hash Index Empty Buckets Count in the SQL Database. | Microsoft.SQLServer.Windows.Monitor.DBFilegroupFx.HashIndexEmptyBucketsCount | Microsoft.SQLServer.Windows.DBFilegroupFx | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Windows.MonitorType.DBFilegroupFx.HashIndexEmptyBucketsCount | True | Public | |
| Memory-Optimized Data Stale Checkpoint File Pairs Ratio | The monitor reports a warning state and raises an alert when the ratio of stale checkpoint file pairs in Memory-Optimized Data Filegroup is higher than the specified thresholds.
Please note that the alerts are raised only if the corresponding database is reasonably big (300 or more checkpoint files in total). | Microsoft.SQLServer.Windows.Monitor.DBFilegroupFx.StaleCFPs | Microsoft.SQLServer.Windows.DBFilegroupFx | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Windows.MonitorType.DBFilegroupFx.StaleCFPs | True | Public | |
| XTP Configuration | This monitor checks the status of the SQL Database XTP configuration. | Microsoft.SQLServer.Windows.Monitor.DBFilegroupFx.XTPConfigurationMonitor | Microsoft.SQLServer.Windows.DBFilegroupFx | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Windows.MonitorType.DBFilegroupFx.XTPConfiguration | True | Public | |
| DB Log File Free Space Left | The monitor reports a warning when the free space (including both already allocated space and free space on the media) drops below the Warning Threshold setting, expressed as percentage of the sum of data size plus disk free space. The monitor reports a critical alert when the free space drops below the Critical Threshold. Note that this monitor is disabled by default. Use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.DBLogFile.DBLogFileSpace | Microsoft.SQLServer.Windows.DBLogFile | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.Windows.MonitorType.DBLogFile.DBLogFileSpace | True | Public | |
| SQL Connection Encryption Certificate Status | This monitor checks the SQL connection encryption certificate. | Microsoft.SQLServer.Windows.Monitor.LocalDBEngine.ConnectionEncryptionCertificate | Microsoft.SQLServer.Windows.LocalDBEngine | System.Health.SecurityState | SecurityHealth | False | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Windows.MonitorType.LocalDBEngine.ConnectionEncryptionCertificate | True | Public | |
| SQL Server Windows Service | This monitor checks the status of the Local SQL Server Database Engine service. | Microsoft.SQLServer.Windows.Monitor.LocalDBEngine.ServiceStatus | Microsoft.SQLServer.Windows.LocalDBEngine | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Windows.MonitorType.LocalDBEngine.ServiceStatus | True | Public | |
| WMI Health State | This monitor checks the WMI health state in the context of access to namespaces and classes used for proper monitoring of SQL Server instances. | Microsoft.SQLServer.Windows.Monitor.LocalDBEngine.WmiHealth | Microsoft.SQLServer.Windows.LocalDBEngine | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Windows.MonitorType.LocalDBEngine.WmiHealth | True | Public | |
| Resource Pool Memory Consumption | 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. | Microsoft.SQLServer.Windows.Monitor.UserResourcePool.MemoryConsumption | Microsoft.SQLServer.Windows.UserResourcePool | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Windows.MonitorType.UserResourcePool.MemoryConsumption | True | Public | |
Home