| | 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 | AvailabilityHealth | 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. | Microsoft.SQLServer.Windows.DBEngine.Configuration.SPNStatusMonitor | Microsoft.SQLServer.Windows.LocalDBEngine | System.Health.ConfigurationState | AvailabilityHealth | True | | | 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 SQL Server Agent Service is not supported by any edition of SQL Server Express; there is no appropriate discovered object. This monitor is disabled by default. Please use overrides to enable it when necessary. | 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 | PerformanceHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.Windows.MonitorType.SqlServiceStatus | True | Public | |
| Job Duration | Monitors Agent Job Duration.
Note that SQL Server Agent Windows Service is not supported by any edition of SQL Server Express; there is no appropriate discovered object. | Microsoft.SQLServer.Windows.Monitor.AgentJob.Duration | Microsoft.SQLServer.Windows.AgentJob | System.Health.PerformanceState | PerformanceCollection | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Windows.MonitorType.AgentJob.Duration | True | Public | |
| Last Run Status | SQL Agent Job on Windows Last Run State Monitor. Monitors the last run state of an SQL Agent Job.
Note that SQL Server Agent Windows Service is not supported by any edition of SQL Server Express; there is no appropriate discovered object. | 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 Group Health Policy | Two-state monitor with 'Error' critical state used particularly for reflecting state of Custom User Policies, which 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 | Availability Replicas Connection | Microsoft.SQLServer.Windows.Monitor.AvailabilityGroupHealth.AllAvailabilityReplicasAreConnected | Microsoft.SQLServer.Windows.AvailabilityGroupHealth | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | True | Microsoft.SQLServer.Windows.MonitorType.AlwaysOnSystemPolicy | True | Public | |
| Availability Group Automatic Failover monitor | Availability Group Automatic Failover | Microsoft.SQLServer.Windows.Monitor.AvailabilityGroupHealth.AutomaticFailoverReadiness | Microsoft.SQLServer.Windows.AvailabilityGroupHealth | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | True | Microsoft.SQLServer.Windows.MonitorType.AlwaysOnSystemPolicy | 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.AlwaysOnSystemPolicy | True | Public | |
| Availability Replicas Role monitor | Availability Replicas Role | Microsoft.SQLServer.Windows.Monitor.AvailabilityGroupHealth.AvailabilityReplicaRoleState | Microsoft.SQLServer.Windows.AvailabilityGroupHealth | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | True | Microsoft.SQLServer.Windows.MonitorType.AlwaysOnSystemPolicy | True | Public | |
| Synchronous Replicas Data Synchronization monitor | Synchronous Replicas Data Synchronization | Microsoft.SQLServer.Windows.Monitor.AvailabilityGroupHealth.AvailabilityReplicasSynchronizationState | Microsoft.SQLServer.Windows.AvailabilityGroupHealth | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | True | Microsoft.SQLServer.Windows.MonitorType.AlwaysOnSystemPolicy | True | Public | |
| Availability Replicas Data Synchronization monitor | Availability Replicas Data Synchronization | Microsoft.SQLServer.Windows.Monitor.AvailabilityGroupHealth.AvailabilityReplicasSynchronizing | Microsoft.SQLServer.Windows.AvailabilityGroupHealth | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | True | Microsoft.SQLServer.Windows.MonitorType.AlwaysOnSystemPolicy | True | Public | |
| Availability Group Health Policy | Two-state monitor with 'Warning' critical state used particularly for reflecting state of Custom User Policies, which 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 | False | | | 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 | False | | | True | Microsoft.SQLServer.Windows.MonitorType.AlwaysOnSystemPolicy | True | Public | |
| Availability Replica Join State | This monitor checks the join state of availability replica. The monitor is unhealthy when the availability replica is added to the availability group but not joined properly. The monitor is healthy otherwise. | Microsoft.SQLServer.Windows.Monitor.AvailabilityReplica.IsJoined | Microsoft.SQLServer.Windows.AvailabilityReplica | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | True | Microsoft.SQLServer.Windows.MonitorType.AlwaysOnSystemPolicy | True | Public | |
| Availability Replica Role | This monitor checks the state of role of availability replica. The monitor is unhealthy when the availability replica’s role is not primary or secondary. The monitor is healthy otherwise. | Microsoft.SQLServer.Windows.Monitor.AvailabilityReplica.RoleIsHealthy | Microsoft.SQLServer.Windows.AvailabilityReplica | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | True | Microsoft.SQLServer.Windows.MonitorType.AlwaysOnSystemPolicy | True | Public | |
| Securables Configuration Status | This monitor checks the status of Always On securables access configuration on Windows. | Microsoft.SQLServer.Windows.Monitor.AvailabilityReplica.SecurablesConfigMonitor | Microsoft.SQLServer.Windows.AvailabilityReplica | System.Health.ConfigurationState | AvailabilityHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Windows.MonitorType.SecurablesConfig | True | Public | |
| Availability Replica Health Policy | Two-state monitor with 'Error' critical state used particularly for reflecting state of Custom User Policies, which 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 | Two-state monitor with 'Warning' critical state used particularly for reflecting state of Custom User Policies, which 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. | Microsoft.SQLServer.Windows.Monitor.Container.FreeSpacePercent | Microsoft.SQLServer.Windows.Container | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Windows.MonitorType.Container.FreeSpacePercent | True | Public | |
| Auto Close Configuration | Monitors the Auto Close setting for the database on Windows. Note: This monitor is disabled by default. Please 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: This monitor is disabled by default. Please 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: This monitor is disabled by default. Please 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 Atatistics Asynchronously setting for the database. Note: This monitor is disabled by default. Please 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: This monitor is disabled by default. Please 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: This monitor is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.Database.DBBackupStatus | Microsoft.SQLServer.Windows.Database | System.Health.AvailabilityState | AvailabilityHealth | True | | | 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: This monitor is disabled by default. Please 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 from all logical disks which host database files. | 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 from all logical disks which host database files. | 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 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 | Error | Normal | True | Microsoft.SQLServer.Windows.MonitorType.Database.DBStatus | True | Public | |
| Page Verify Configuration | Monitors the Page Verify setting for the database. Note: This monitor is disabled by default. Please 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: This monitor is disabled by default. Please 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 | |
| DB Free Space Left | Monitors the space available in the database and on the media hosting the database in percentage terms. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. This monitor does not count free space for FILESTREAM and Memory-Optimized Data file groups. | Microsoft.SQLServer.Windows.Monitor.Database.RowsSizePercent | 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 | |
| DB Space Percentage Change | Monitors for a significant decrease of database free space over a number of sample periods. Note: This monitor is disabled by default. Please 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 | |
| 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 | |
| Transaction Log Free Space (\%) | Transaction Log Free Space (\%) monitor for SQL DBs on Windows. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.Database.TransactionLogSpaceFreePercent | Microsoft.SQLServer.Windows.Database | Microsoft.SQLServer.Windows.Rollup.Database.DBSpace | PerformanceHealth | False | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Windows.MonitorType.Database.TransactionLogSpaceFreePercent | True | Public | |
| Trustworthy Configuration | Monitors the Trustworthy setting for the database. Note: This monitor is disabled by default. Please 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 | |
| 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 database replica. The monitor is unhealthy when the data synchronization state is NOT SYNCHRONIZING or the state is not SYNCHRONIZED for synchronous commit database replica. | Microsoft.SQLServer.Windows.Monitor.DatabaseReplica.DataSynchronizationState | Microsoft.SQLServer.Windows.DatabaseReplica | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | True | Microsoft.SQLServer.Windows.MonitorType.AlwaysOnSystemPolicy | True | Public | |
| Availability Database Join State | This monitor checks the join state of database replica. The monitor is unhealthy when the database replica is not joined. The monitor is in healthy state otherwise. | Microsoft.SQLServer.Windows.Monitor.DatabaseReplica.JoinState | Microsoft.SQLServer.Windows.DatabaseReplica | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | 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 | False | | | 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: This monitor is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.DBEngine.BlockingSessions | Microsoft.SQLServer.Windows.DBEngine | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | High | True | Microsoft.SQLServer.Windows.MonitorType.DBEngine.BlockingSessions | True | Public | |
| Buffer Cache Hit Ratio | Buffer Cache Hit Ratio for DB Engine | Microsoft.SQLServer.Windows.Monitor.DBEngine.BufferCacheHitRatio | Microsoft.SQLServer.Windows.DBEngine | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Windows.MonitorType.DBEngine.BufferCacheHitRatio | True | Public | |
| CPU Utilization (\%) | CPU Utilization (\%) for MSSQL DB Engine. | 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 | |
| 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. Please use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.DBEngine.FullTextServiceStatus | Microsoft.SQLServer.Windows.DBEngine | System.Health.AvailabilityState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.Windows.MonitorType.SqlServiceStatus | True | Public | |
| Page Life Expectancy | Page Life Expectancy (s) for DB Engine | Microsoft.SQLServer.Windows.Monitor.DBEngine.PageLifeExpectancy | Microsoft.SQLServer.Windows.DBEngine | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Windows.MonitorType.DBEngine.PageLifeExpectancy | True | Public | |
| Service Pack Compliance | Monitors the service pack level of the database engine against the compliant setting | 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 evaluates critical errors like lack of or invalid SQL Credentials, connectivity errors and reports the health of the system. | Microsoft.SQLServer.Windows.Monitor.DBEngine.SmartAdminSystemHealthPolicy | Microsoft.SQLServer.Windows.DBEngine | System.Health.AvailabilityState | AvailabilityHealth | True | | | 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 evaluates warnings such as corrupted backups, and such. | Microsoft.SQLServer.Windows.Monitor.DBEngine.SmartAdminUserActionHealthPolicy | Microsoft.SQLServer.Windows.DBEngine | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Windows.MonitorType.DBEngine.SmartAdminHealthPolicy | True | Public | |
| SQL Re-Compilation | SQL Re-Compilation for DB Engine. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.Monitor.DBEngine.SQLRecompilation | Microsoft.SQLServer.Windows.DBEngine | System.Health.PerformanceState | PerformanceHealth | True | | | 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 | Thread Count for DB Engine | 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. | Microsoft.SQLServer.Windows.Monitor.DBFile.DBFileSpace | Microsoft.SQLServer.Windows.DBFile | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | 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. | Microsoft.SQLServer.Windows.Monitor.DBFilegroupFd.GroupSpace | Microsoft.SQLServer.Windows.DBFilegroupFd | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Windows.MonitorType.DBFilegroupFd.GroupSpace | True | Public | |
| 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 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. | Microsoft.SQLServer.Windows.Monitor.DBLogFile.DBLogFileSpace | Microsoft.SQLServer.Windows.DBLogFile | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Windows.MonitorType.DBLogFile.DBLogFileSpace | 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 for all namespaces and classes used in the current management pack. | 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