| | 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.2017.Windows.Database.LogShippingSourceMonitor | Microsoft.SQLServer.2017.Windows.Database | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2017.Windows.MonitorType.Database.LogShipping | True | Public | |
| DMV Configuration Status | This monitor checks the status of DMV access configuration on Windows. | Microsoft.SQLServer.2017.Windows.DBEngine.Configuration.DMVConfigMonitor | Microsoft.SQLServer.2017.Windows.DBEngine | System.Health.ConfigurationState | AvailabilityHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2017.Windows.DBEngine.Configuration.DMVConfig | 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.2017.Windows.DBEngine.Configuration.SPNStatusMonitor | Microsoft.SQLServer.2017.Windows.LocalDBEngine | System.Health.ConfigurationState | AvailabilityHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2017.Windows.DBEngine.Configuration.SPNStatus | 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.2017.Windows.Monitor.Agent.LongRunningJobs | Microsoft.SQLServer.2017.Windows.Agent | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.2017.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.2017.Windows.Monitor.Agent.ServiceStatus | Microsoft.SQLServer.2017.Windows.Agent | System.Health.AvailabilityState | PerformanceHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.2017.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.2017.Windows.Monitor.AgentJob.Duration | Microsoft.SQLServer.2017.Windows.AgentJob | System.Health.PerformanceState | PerformanceCollection | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2017.Windows.MonitorType.AgentJob.Duration | True | Public | |
| Last Run Status | SQL 2017 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.2017.Windows.Monitor.AgentJob.LastRunState | Microsoft.SQLServer.2017.Windows.AgentJob | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2017.Windows.MonitorType.AgentJob.LastRunState | 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.2017.Windows.Monitor.Container.FreeSpacePercent | Microsoft.SQLServer.2017.Windows.Container | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2017.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.2017.Windows.Monitor.Database.AutoCloseConfiguration | Microsoft.SQLServer.2017.Windows.Database | Microsoft.SQLServer.2017.Windows.Rollup.Database.AutomaticConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2017.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.2017.Windows.Monitor.Database.AutoCreateStatConfiguration | Microsoft.SQLServer.2017.Windows.Database | Microsoft.SQLServer.2017.Windows.Rollup.Database.AutomaticConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2017.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.2017.Windows.Monitor.Database.AutoShrinkConfiguration | Microsoft.SQLServer.2017.Windows.Database | Microsoft.SQLServer.2017.Windows.Rollup.Database.AutomaticConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2017.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.2017.Windows.Monitor.Database.AutoUpdateStatAsyncConfiguration | Microsoft.SQLServer.2017.Windows.Database | Microsoft.SQLServer.2017.Windows.Rollup.Database.AutomaticConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2017.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.2017.Windows.Monitor.Database.AutoUpdateStatConfiguration | Microsoft.SQLServer.2017.Windows.Database | Microsoft.SQLServer.2017.Windows.Rollup.Database.AutomaticConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2017.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.2017.Windows.Monitor.Database.DBBackupStatus | Microsoft.SQLServer.2017.Windows.Database | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2017.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.2017.Windows.Monitor.Database.DBChainingConfiguration | Microsoft.SQLServer.2017.Windows.Database | Microsoft.SQLServer.2017.Windows.Rollup.Database.ExternalAccessConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2017.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.2017.Windows.Monitor.Database.DBDiskReadLatency | Microsoft.SQLServer.2017.Windows.Database | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | High | True | Microsoft.SQLServer.2017.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.2017.Windows.Monitor.Database.DBDiskWriteLatency | Microsoft.SQLServer.2017.Windows.Database | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | High | True | Microsoft.SQLServer.2017.Windows.MonitorType.Database.DBDiskWriteLatency | True | Public | |
| Database Status | This monitor checks the status of the database as reported by Microsoft SQL Server. | Microsoft.SQLServer.2017.Windows.Monitor.Database.DBStatus | Microsoft.SQLServer.2017.Windows.Database | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2017.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.2017.Windows.Monitor.Database.PageVerifyConfiguration | Microsoft.SQLServer.2017.Windows.Database | Microsoft.SQLServer.2017.Windows.Rollup.Database.RecoveryConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2017.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.2017.Windows.Monitor.Database.RecoveryModelConfiguration | Microsoft.SQLServer.2017.Windows.Database | Microsoft.SQLServer.2017.Windows.Rollup.Database.RecoveryConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2017.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.2017.Windows.Monitor.Database.RowsSizePercent | Microsoft.SQLServer.2017.Windows.Database | Microsoft.SQLServer.2017.Windows.Rollup.Database.DBSpace | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | High | True | Microsoft.SQLServer.2017.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.2017.Windows.Monitor.Database.RowsSizePercentageChange | Microsoft.SQLServer.2017.Windows.Database | Microsoft.SQLServer.2017.Windows.Rollup.Database.DBSpace | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.2017.Windows.MonitorType.Database.DBPercentageChange | True | Public | |
| MSSQL 2017 on Windows: SQL Server Windows Service | This monitor checks the status of the Local SQL Server 2017 Database Engine service. | Microsoft.SQLServer.2017.Windows.Monitor.Database.ServiceStatus | Microsoft.SQLServer.2017.Windows.LocalDatabase | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | True | Microsoft.SQLServer.2017.Windows.MonitorType.LocalDatabase.DBServiceStatus | True | Public | |
| Transaction Log Free Space (\%) | Transaction Log Free Space (\%) monitor for SQL 2017 DBs on Windows. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.2017.Windows.Monitor.Database.TransactionLogSpaceFreePercent | Microsoft.SQLServer.2017.Windows.Database | Microsoft.SQLServer.2017.Windows.Rollup.Database.DBSpace | PerformanceHealth | False | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2017.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.2017.Windows.Monitor.Database.TrustWorthyConfiguration | Microsoft.SQLServer.2017.Windows.Database | Microsoft.SQLServer.2017.Windows.Rollup.Database.ExternalAccessConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2017.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.2017.Windows.Monitor.DatabaseErrorUserPolicy.DBErrorUserPolicyState | Microsoft.SQLServer.2017.Windows.DatabaseErrorUserPolicy | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2017.Windows.MonitorType.Policy.TwoStatePolicy | 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.2017.Windows.Monitor.DatabaseWarningUserPolicy.DBWarningUserPolicyState | Microsoft.SQLServer.2017.Windows.DatabaseWarningUserPolicy | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2017.Windows.MonitorType.Policy.TwoStatePolicy | True | Public | |
| Average Wait Time | Average Wait Time monitor for 2017 DBs | Microsoft.SQLServer.2017.Windows.Monitor.DBEngine.AverageWaitTime | Microsoft.SQLServer.2017.Windows.DBEngine | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2017.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.2017.Windows.Monitor.DBEngine.BlockingSessions | Microsoft.SQLServer.2017.Windows.DBEngine | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | High | True | Microsoft.SQLServer.2017.Windows.MonitorType.DBEngine.BlockingSessions | True | Public | |
| Buffer Cache Hit Ratio | Buffer Cache Hit Ratio for 2017 DB Engine | Microsoft.SQLServer.2017.Windows.Monitor.DBEngine.BufferCacheHitRatio | Microsoft.SQLServer.2017.Windows.DBEngine | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2017.Windows.MonitorType.DBEngine.BufferCacheHitRatio | True | Public | |
| CPU Utilization (\%) | CPU Utilization (\%) for MSSQL 2017 DB Engine. | Microsoft.SQLServer.2017.Windows.Monitor.DBEngine.CPUUtilization | Microsoft.SQLServer.2017.Windows.DBEngine | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2017.Windows.MonitorType.DBEngine.CPUUtilization | True | Public | |
| DB Engine Health Status | This monitor checks the health state of the SQL Server 2017 DB Engine. | Microsoft.SQLServer.2017.Windows.Monitor.DBEngine.DBEngineStatus | Microsoft.SQLServer.2017.Windows.DBEngine | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2017.Windows.MonitorType.DBEngine.DBEngineStatus | True | Public | |
| SQL Full-text Filter Daemon Launcher Service | This monitor checks the status of the SQL 2017 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.2017.Windows.Monitor.DBEngine.FullTextServiceStatus | Microsoft.SQLServer.2017.Windows.DBEngine | System.Health.AvailabilityState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.2017.Windows.MonitorType.SqlServiceStatus | True | Public | |
| Page Life Expectancy | Page Life Expectancy (s) for 2017 DB Engine | Microsoft.SQLServer.2017.Windows.Monitor.DBEngine.PageLifeExpectancy | Microsoft.SQLServer.2017.Windows.DBEngine | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2017.Windows.MonitorType.DBEngine.PageLifeExpectancy | True | Public | |
| Service Pack Compliance | Monitors the service pack level of the database engine against the compliant setting | Microsoft.SQLServer.2017.Windows.Monitor.DBEngine.ServicePackLevel | Microsoft.SQLServer.2017.Windows.DBEngine | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.2017.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.2017.Windows.Monitor.DBEngine.SmartAdminSystemHealthPolicy | Microsoft.SQLServer.2017.Windows.DBEngine | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2017.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.2017.Windows.Monitor.DBEngine.SmartAdminUserActionHealthPolicy | Microsoft.SQLServer.2017.Windows.DBEngine | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2017.Windows.MonitorType.DBEngine.SmartAdminHealthPolicy | True | Public | |
| SQL Re-Compilation | SQL Re-Compilation for 2017 DB Engine. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.2017.Windows.Monitor.DBEngine.SQLRecompilation | Microsoft.SQLServer.2017.Windows.DBEngine | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2017.Windows.MonitorType.DBEngine.SQLRecompilation | True | Public | |
| Stolen Server Memory | Stolen Server Memory for 2017 DB Engine | Microsoft.SQLServer.2017.Windows.Monitor.DBEngine.StolenServerMemory | Microsoft.SQLServer.2017.Windows.DBEngine | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2017.Windows.MonitorType.DBEngine.StolenServerMemory | True | Public | |
| Thread Count | Thread Count for 2017 DB Engine | Microsoft.SQLServer.2017.Windows.Monitor.DBEngine.ThreadCount | Microsoft.SQLServer.2017.Windows.DBEngine | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2017.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.2017.Windows.Monitor.DBFile.DBFileSpace | Microsoft.SQLServer.2017.Windows.DBFile | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2017.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.2017.Windows.Monitor.DBFilegroupFd.GroupSpace | Microsoft.SQLServer.2017.Windows.DBFilegroupFd | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2017.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.2017.Windows.Monitor.DBFilegroupFx.HashIndexAvgChainLength | Microsoft.SQLServer.2017.Windows.DBFilegroupFx | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2017.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.2017.Windows.Monitor.DBFilegroupFx.HashIndexEmptyBucketsCount | Microsoft.SQLServer.2017.Windows.DBFilegroupFx | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2017.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.2017.Windows.Monitor.DBFilegroupFx.StaleCFPs | Microsoft.SQLServer.2017.Windows.DBFilegroupFx | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2017.Windows.MonitorType.DBFilegroupFx.StaleCFPs | 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.2017.Windows.Monitor.DBLogFile.DBLogFileSpace | Microsoft.SQLServer.2017.Windows.DBLogFile | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2017.Windows.MonitorType.DBLogFile.DBLogFileSpace | True | Public | |
| SQL Server Windows Service | This monitor checks the status of the Local SQL Server 2017 Database Engine service. | Microsoft.SQLServer.2017.Windows.Monitor.LocalDBEngine.ServiceStatus | Microsoft.SQLServer.2017.Windows.LocalDBEngine | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2017.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.2017.Windows.Monitor.LocalDBEngine.WmiHealth | Microsoft.SQLServer.2017.Windows.LocalDBEngine | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2017.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.2017.Windows.Monitor.UserResourcePool.MemoryConsumption | Microsoft.SQLServer.2017.Windows.UserResourcePool | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2017.Windows.MonitorType.UserResourcePool.MemoryConsumption | 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.SQLServer.2017.Windows.LogShippingDestinationMonitor | Microsoft.SQLServer.2017.Windows.Database | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2017.Windows.MonitorType.Database.LogShipping | True | Public | |
Home