| | 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. | 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. The 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 | Monitors 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 | SQL Agent Job on Windows Last Run State Monitor. Monitors 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. | 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 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 | 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 | 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: 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: 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: 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: 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: 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: 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: 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: 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. | 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. | 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: 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 terms. This monitor does not count the available space for FILESTREAM and Memory-Optimized Data filegroups. Note: 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 terms. This monitor does not count free space for In-Memory OLTP and In-Memory OLTP Data filegroups. | 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: 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: 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 percentage terms. 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: 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 | |
| LOG Free Space Left | Monitors the space available in the database transactional log in percentage terms. | 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: 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: 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: 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 | 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. | 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. 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 | 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 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 | 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 evaluates warnings such as corrupted backups, and such. | 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: 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 | 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. Note: 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: 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: 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 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