| | 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 |
|---|
 | Long Running Jobs | This monitor checks for long running SQL Agent jobs.
Note that SQL Server Agent Windows 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.2016.Agent.LongRunningJobs | Microsoft.SQLServer.2016.Agent | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.2016.AgentLongRunningJobsProvider | True | Public | |
| SQL Server Agent Windows 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.2016.Agent.ServiceMonitor | Microsoft.SQLServer.2016.Agent | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.Windows.CheckNTServiceStateMonitorType | 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.2016.AgentJob.JobDuration | Microsoft.SQLServer.2016.AgentJob | System.Health.PerformanceState | PerformanceCollection | True | | | 0 | False | | | True | Microsoft.SQLServer.2016.AgentLongRunningJobsProviderPerJob | True | Public | |
| Last Run Status | SQL 2016 Agent Job 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.2016.AgentJob.JobLastRunState | Microsoft.SQLServer.2016.AgentJob | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | True | Microsoft.SQLServer.2016.AgentJobLastRunProvider | True | Public | |
| Auto Close Configuration | Monitors the Auto Close setting for the database. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.2016.Database.Configuration.AutoClose | Microsoft.SQLServer.2016.Database | Microsoft.SQLServer.2016.Database.AutomaticConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2016.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.2016.Database.Configuration.AutoCreateStat | Microsoft.SQLServer.2016.Database | Microsoft.SQLServer.2016.Database.AutomaticConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2016.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.2016.Database.Configuration.AutoShrink | Microsoft.SQLServer.2016.Database | Microsoft.SQLServer.2016.Database.AutomaticConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2016.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.2016.Database.Configuration.AutoUpdateSet | Microsoft.SQLServer.2016.Database | Microsoft.SQLServer.2016.Database.AutomaticConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2016.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.2016.Database.Configuration.AutoUpdateStatAsync | Microsoft.SQLServer.2016.Database | Microsoft.SQLServer.2016.Database.AutomaticConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2016.DBConfigurationStatus | 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.2016.Database.Configuration.DBChaining | Microsoft.SQLServer.2016.Database | Microsoft.SQLServer.2016.Database.ExternalAccessConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2016.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.2016.Database.Configuration.RecoveryModel | Microsoft.SQLServer.2016.Database | Microsoft.SQLServer.2016.Database.RecoveryConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2016.DBConfigurationStatus | 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.2016.Database.Configuration.TornPageDetection | Microsoft.SQLServer.2016.Database | Microsoft.SQLServer.2016.Database.RecoveryConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2016.DBConfigurationStatus | 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.2016.Database.Configuration.TrustWorthy | Microsoft.SQLServer.2016.Database | Microsoft.SQLServer.2016.Database.ExternalAccessConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2016.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.2016.Database.DBBackupStatusMonitor | Microsoft.SQLServer.2016.Database | System.Health.AvailabilityState | AvailabilityHealth | False | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2016.DBBackupStatus | True | Public | |
| DB Space Percentage Change | Monitors for a significant change 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.2016.Database.DBSizePercentageChangeMonitor | Microsoft.SQLServer.2016.Database | Microsoft.SQLServer.2016.Database.DBSpaceMonitor | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.2016.DBPercentageChange | 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.2016.Database.DBSizePercentMonitor | Microsoft.SQLServer.2016.Database | Microsoft.SQLServer.2016.Database.DBSpaceMonitor | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | High | True | Microsoft.SQLServer.2016.DBAndLogSizeMonitorType | True | Public | |
| Database Status | This monitor checks the status of the database as reported by Microsoft SQL Server. | Microsoft.SQLServer.2016.Database.DBStatusMonitor | Microsoft.SQLServer.2016.Database | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2016.DBStatus | True | Public | |
| Disk Read Latency | Disk Read Latency monitor for 2016 DBs. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.2016.Database.DiskReadLatencyMonitor | Microsoft.SQLServer.2016.Database | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2016.Database.DiskReadLatency.MonitorType | True | Public | |
| Disk Write Latency | Disk Write Latency monitor for 2016 DBs. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.2016.Database.DiskWriteLatencyMonitor | Microsoft.SQLServer.2016.Database | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2016.Database.DiskWriteLatency.MonitorType | 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 all Log Shipping is not supported by any edition of SQL Server Express. | Microsoft.SQLServer.2016.Database.LogShippingDestinationMonitor | Microsoft.SQLServer.2016.Database | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.Windows.2SingleEventLog2StateMonitorType | True | Public | |
| 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 all Log Shipping is not supported by any edition of SQL Server Express. | Microsoft.SQLServer.2016.Database.LogShippingSourceMonitor | Microsoft.SQLServer.2016.Database | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.Windows.2SingleEventLog2StateMonitorType | True | Public | |
| SQL Server Windows Service | This monitor checks the status of the SQL Database Engine service. | Microsoft.SQLServer.2016.Database.ServiceMonitor | Microsoft.SQLServer.2016.Database | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | True | Microsoft.SQLServer.2016.CheckDBEngineServiceStateMonitorType | True | Public | |
| Transaction Log Free Space (\%) | Transaction Log Free Space (\%) monitor for 2016 DBs. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.2016.Database.TransactionLogSpaceFreePercentMonitor | Microsoft.SQLServer.2016.Database | Microsoft.SQLServer.2016.Database.DBSpaceMonitor | PerformanceHealth | False | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2016.Database.TransactionLogSpaceFreePercent.MonitorType | True | Public | |
| Average Wait Time | Average Wait Time monitor for 2016 DBs | Microsoft.SQLServer.2016.DBEngine.AverageWaitTimeMonitor | Microsoft.SQLServer.2016.DBEngine | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2016.DBEngine.AverageWaitTime.MonitorType | True | Public | |
| Blocking Sessions | Monitors blocked sessions for a SQL instance. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.2016.DBEngine.BlockedSPIDsMonitor | Microsoft.SQLServer.2016.DBEngine | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | Error | High | True | Microsoft.SQLServer.2016.DBEngine.BlockedSPIDs | True | Public | |
| Buffer Cache Hit Ratio | Buffer Cache Hit Ratio for 2016 DB Engine | Microsoft.SQLServer.2016.DBEngine.BufferCacheHitRatioMonitor | Microsoft.SQLServer.2016.DBEngine | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2016.DBEngine.BufferCacheHitRatio.MonitorType | True | Public | |
| Service Pack Compliance | Monitors the service pack level of the database engine against the compliant setting | Microsoft.SQLServer.2016.DBEngine.Configuration.ServicePackLevel | Microsoft.SQLServer.2016.DBEngine | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.2016.ServicePackVersion | True | Public | |
| Service Principal Name Configuration Status | This monitor checks the status of the Microsoft SQL Server instance Service Principal Name configuration. | Microsoft.SQLServer.2016.DBEngine.Configuration.SPNStatusMonitor | Microsoft.SQLServer.2016.DBEngine | System.Health.ConfigurationState | AvailabilityHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2016.DBEngine.Configuration.SPNStatus | True | Public | |
| CPU Utilization (\%) | CPU Utilization (\%) for 2016 DB Engine | Microsoft.SQLServer.2016.DBEngine.CPUUsagePercentMonitor | Microsoft.SQLServer.2016.DBEngine | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2016.DBEngine.CPUUsagePercent.MonitorType | 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.2016.DBEngine.FullTextSearchServiceMonitor | Microsoft.SQLServer.2016.DBEngine | System.Health.AvailabilityState | AvailabilityHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.Windows.CheckNTServiceStateMonitorType | True | Public | |
| Page Life Expectancy | Page Life Expectancy (s) for 2016 DB Engine | Microsoft.SQLServer.2016.DBEngine.PageLifeExpectancyMonitor | Microsoft.SQLServer.2016.DBEngine | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2016.DBEngine.PageLifeExpectancy.MonitorType | True | Public | |
| SQL Server Windows Service | This monitor checks the status of the SQL Server Database Engine service. | Microsoft.SQLServer.2016.DBEngine.ServiceMonitor | Microsoft.SQLServer.2016.DBEngine | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2016.CheckWinServiceStateMonitorType | True | Public | |
| SQL Re-Compilation | SQL Re-Compilation for 2016 DB Engine. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.2016.DBEngine.SQLReCompilationMonitor | Microsoft.SQLServer.2016.DBEngine | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2016.DBEngine.SQLReCompilation.MonitorType | True | Public | |
| Stolen Server Memory | Stolen Server Memory for 2016 DB Engine | Microsoft.SQLServer.2016.DBEngine.StolenServerMemoryMonitor | Microsoft.SQLServer.2016.DBEngine | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2016.DBEngine.StolenServerMemory.MonitorType | True | Public | |
| Thread Count | Thread Count for 2016 DB Engine | Microsoft.SQLServer.2016.DBEngine.ThreadCountMonitor | Microsoft.SQLServer.2016.DBEngine | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2016.DBEngine.ThreadCount.MonitorType | 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.2016.DBErrorUserPolicyStateMonitor | Microsoft.SQLServer.2016.DatabaseErrorUserPolicy | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | True | Microsoft.SQLServer.2016.TwoStatePolicyMonitorType | 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.2016.DBWarningUserPolicyStateMonitor | Microsoft.SQLServer.2016.DatabaseWarningUserPolicy | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | True | Microsoft.SQLServer.2016.TwoStatePolicyMonitorType | 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.2016.Monitor.Container.FreeSpacePercent | Microsoft.SQLServer.2016.Container | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2016.MonitorType.Container.FreeSpacePercent | True | Public | |
| Garbage Collection | The monitor reports a Critical State and raises an alert if the amount of space used by active rows in Memory-Optimized Data files drops below the Threshold setting, expressed as a percentage of the size of data files. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.2016.Monitor.DBFileGroupFx.GarbageCollectionState | Microsoft.SQLServer.2016.DBFileGroupFx | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2016.MonitorType.DBFileGroupFx.GarbageCollectionState | 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.2016.Monitor.DBFileGroupFx.StaleCFPs | Microsoft.SQLServer.2016.DBFileGroupFx | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2016.DBFileGroupFx.StaleCFPs.MonitorType | 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.2016.Monitor.UserResourcePool.MemoryConsumption | Microsoft.SQLServer.2016.UserResourcePool | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2016.MonitorType.UserResourcePool.MemoryConsumption | 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.2016.Monitoring.DBFileSpaceMonitor | Microsoft.SQLServer.2016.DBFile | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2016.DBFileSizeMonitorType | 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.2016.Monitoring.DBFileStreamGroupSpaceMonitor | Microsoft.SQLServer.2016.DBFileGroupFd | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2016.DBFileStreamGroupSizeMonitorType | 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.2016.Monitoring.DBLogFileSpaceMonitor | Microsoft.SQLServer.2016.DBLogFile | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2016.DBLogFileSizeMonitorType | 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.2016.Monitoring.HashIndexAvgChainLengthMonitor | Microsoft.SQLServer.2016.DBFileGroupFx | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2016.Monitoring.HashIndexAvgChainLength.MonitorType | True | Public | |
| Empty Bucket percent in the hash index | This monitor checks Hash Index Empty Buckets Count in the SQL Database. | Microsoft.SQLServer.2016.Monitoring.HashIndexEmptyBucketsCountMonitor | Microsoft.SQLServer.2016.DBFileGroupFx | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2016.Monitoring.HashIndexEmptyBucketsCount.MonitorType | True | Public | |
| XTP Configuration | This monitor checks the status of the SQL Database XTP Configuration. | Microsoft.SQLServer.2016.Monitoring.XTPConfigurationMonitor | Microsoft.SQLServer.2016.DBFileGroupFx | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2016.Monitoring.XTPConfiguration.MonitorType | 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.2016.UnitMonitor.DBEngine.SmartAdminSystemHealthPolicy | Microsoft.SQLServer.2016.DBEngine | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2016.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.2016.UnitMonitor.DBEngine.SmartAdminUserActionHealthPolicy | Microsoft.SQLServer.2016.DBEngine | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2016.MonitorType.DBEngine.SmartAdminHealthPolicy | True | Public | |
Home