All Unit Monitors in Microsoft.SQLServer.2016.Monitoring Management Pack

 DisplayNameDescriptionIDTargetParent MonitorCategoryEnabledInstance NameCounter NameFrequencyAlert GenerateAlert SeverityAlert PriorityAlert Auto ResolveMonitor TypeRemotableAccessibilityRunAs
Microsoft.SQLServer.2016.Agent.LongRunningJobsLong Running JobsThis 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.LongRunningJobsMicrosoft.SQLServer.2016.AgentSystem.Health.PerformanceStatePerformanceHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2016.AgentLongRunningJobsProviderTruePublic
Microsoft.SQLServer.2016.Agent.ServiceMonitorSQL Server Agent Windows ServiceThis 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.ServiceMonitorMicrosoft.SQLServer.2016.AgentSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2016.CheckWinServiceStateMonitorTypeTruePublic
Microsoft.SQLServer.2016.AgentJob.JobDurationJob DurationMonitors 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.JobDurationMicrosoft.SQLServer.2016.AgentJobSystem.Health.PerformanceStatePerformanceCollectionTrue0FalseTrueMicrosoft.SQLServer.2016.AgentLongRunningJobsProviderPerJobTruePublic
Microsoft.SQLServer.2016.AgentJob.JobLastRunStateLast Run StatusSQL 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.JobLastRunStateMicrosoft.SQLServer.2016.AgentJobSystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseTrueMicrosoft.SQLServer.2016.AgentJobLastRunProviderTruePublic
Microsoft.SQLServer.2016.Database.Configuration.AutoCloseAuto Close ConfigurationMonitors 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.AutoCloseMicrosoft.SQLServer.2016.DatabaseMicrosoft.SQLServer.2016.Database.AutomaticConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2016.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2016.Database.Configuration.AutoCreateStatAuto Create Statistics ConfigurationMonitors 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.AutoCreateStatMicrosoft.SQLServer.2016.DatabaseMicrosoft.SQLServer.2016.Database.AutomaticConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2016.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2016.Database.Configuration.AutoShrinkAuto Shrink ConfigurationMonitors 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.AutoShrinkMicrosoft.SQLServer.2016.DatabaseMicrosoft.SQLServer.2016.Database.AutomaticConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2016.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2016.Database.Configuration.AutoUpdateSetAuto Update Statistics ConfigurationMonitors 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.AutoUpdateSetMicrosoft.SQLServer.2016.DatabaseMicrosoft.SQLServer.2016.Database.AutomaticConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2016.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2016.Database.Configuration.AutoUpdateStatAsyncAuto Update Statistics Async ConfigurationMonitors 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.AutoUpdateStatAsyncMicrosoft.SQLServer.2016.DatabaseMicrosoft.SQLServer.2016.Database.AutomaticConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2016.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2016.Database.Configuration.DBChainingDB Chaining ConfigurationMonitors 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.DBChainingMicrosoft.SQLServer.2016.DatabaseMicrosoft.SQLServer.2016.Database.ExternalAccessConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2016.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2016.Database.Configuration.RecoveryModelRecovery Model ConfigurationMonitors 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.RecoveryModelMicrosoft.SQLServer.2016.DatabaseMicrosoft.SQLServer.2016.Database.RecoveryConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2016.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2016.Database.Configuration.TornPageDetectionPage Verify ConfigurationMonitors 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.TornPageDetectionMicrosoft.SQLServer.2016.DatabaseMicrosoft.SQLServer.2016.Database.RecoveryConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2016.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2016.Database.Configuration.TrustWorthyTrustworthy ConfigurationMonitors 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.TrustWorthyMicrosoft.SQLServer.2016.DatabaseMicrosoft.SQLServer.2016.Database.ExternalAccessConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2016.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2016.Database.DBBackupStatusMonitorDatabase Backup StatusThis monitor checks the status of the database backup as reported by Microsoft SQL Server. Note that the monitor ignores Always On databases. Therefore, it is always "green" for those databases. For backups of Always On databases, use the dedicated monitors at the Availability Group. Note: This monitor is disabled by default. Please use overrides to enable it when necessary.Microsoft.SQLServer.2016.Database.DBBackupStatusMonitorMicrosoft.SQLServer.2016.DatabaseSystem.Health.AvailabilityStateAvailabilityHealthFalse0TrueErrorNormalTrueMicrosoft.SQLServer.2016.DBBackupStatusTruePublic
Microsoft.SQLServer.2016.Database.DBSizePercentageChangeMonitorDB Space Percentage ChangeMonitors 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.2016.Database.DBSizePercentageChangeMonitorMicrosoft.SQLServer.2016.DatabaseMicrosoft.SQLServer.2016.Database.DBSpaceMonitorPerformanceHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2016.DBPercentageChangeTruePublic
Microsoft.SQLServer.2016.Database.DBSizePercentMonitorDB Free Space LeftMonitors 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.DBSizePercentMonitorMicrosoft.SQLServer.2016.DatabaseMicrosoft.SQLServer.2016.Database.DBSpaceMonitorPerformanceHealthFalse0TrueMatchMonitorHealthHighTrueMicrosoft.SQLServer.2016.DBAndLogSizeMonitorTypeTruePublic
Microsoft.SQLServer.2016.Database.DBStatusMonitorDatabase StatusThis monitor checks the status of the database as reported by Microsoft SQL Server.Microsoft.SQLServer.2016.Database.DBStatusMonitorMicrosoft.SQLServer.2016.DatabaseSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2016.DBStatusTruePublic
Microsoft.SQLServer.2016.Database.DiskReadLatencyMonitorDisk Read LatencyDisk Read Latency monitor for 2016 databases. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. Note: This monitor is disabled by default. Please use overrides to enable it when necessary.Microsoft.SQLServer.2016.Database.DiskReadLatencyMonitorMicrosoft.SQLServer.2016.DatabaseSystem.Health.PerformanceStatePerformanceHealthFalse0TrueErrorNormalTrueMicrosoft.SQLServer.2016.Database.DiskReadLatency.MonitorTypeTruePublic
Microsoft.SQLServer.2016.Database.DiskWriteLatencyMonitorDisk Write LatencyDisk Write Latency monitor for 2016 databases. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. Note: This monitor is disabled by default. Please use overrides to enable it when necessary.Microsoft.SQLServer.2016.Database.DiskWriteLatencyMonitorMicrosoft.SQLServer.2016.DatabaseSystem.Health.PerformanceStatePerformanceHealthFalse0TrueErrorNormalTrueMicrosoft.SQLServer.2016.Database.DiskWriteLatency.MonitorTypeTruePublic
Microsoft.SQLServer.2016.Database.LogShippingDestinationMonitorDestination Log ShippingThis 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.LogShippingDestinationMonitorMicrosoft.SQLServer.2016.DatabaseSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.2SingleEventLog2StateMonitorTypeTruePublic
Microsoft.SQLServer.2016.Database.LogShippingSourceMonitorSource Log ShippingThis 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.LogShippingSourceMonitorMicrosoft.SQLServer.2016.DatabaseSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.2SingleEventLog2StateMonitorTypeTruePublic
Microsoft.SQLServer.2016.Database.ServiceMonitorSQL Server Windows ServiceThis monitor checks the status of the SQL Database Engine service.Microsoft.SQLServer.2016.Database.ServiceMonitorMicrosoft.SQLServer.2016.DatabaseSystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseTrueMicrosoft.SQLServer.2016.CheckDBEngineServiceStateMonitorTypeTruePublic
Microsoft.SQLServer.2016.Database.TransactionLogSpaceFreePercentMonitorTransaction Log Free Space (\%)Transaction Log Free Space (\%) monitor for 2016 databases. Note: This monitor is disabled by default. Please use overrides to enable it when necessary.Microsoft.SQLServer.2016.Database.TransactionLogSpaceFreePercentMonitorMicrosoft.SQLServer.2016.DatabaseMicrosoft.SQLServer.2016.Database.DBSpaceMonitorPerformanceHealthFalse0TrueErrorNormalTrueMicrosoft.SQLServer.2016.Database.TransactionLogSpaceFreePercent.MonitorTypeTruePublic
Microsoft.SQLServer.2016.DBEngine.AverageWaitTimeMonitorAverage Wait TimeAverage Wait Time monitor for 2016 databases.Microsoft.SQLServer.2016.DBEngine.AverageWaitTimeMonitorMicrosoft.SQLServer.2016.DBEngineSystem.Health.PerformanceStatePerformanceHealthTrue0TrueWarningNormalTrueMicrosoft.SQLServer.2016.DBEngine.AverageWaitTime.MonitorTypeTruePublic
Microsoft.SQLServer.2016.DBEngine.BlockedSPIDsMonitorBlocking SessionsMonitors 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.BlockedSPIDsMonitorMicrosoft.SQLServer.2016.DBEngineSystem.Health.PerformanceStatePerformanceHealthFalse0TrueErrorHighTrueMicrosoft.SQLServer.2016.DBEngine.BlockedSPIDsTruePublic
Microsoft.SQLServer.2016.DBEngine.BufferCacheHitRatioMonitorBuffer Cache Hit RatioBuffer Cache Hit Ratio for 2016 DB EngineMicrosoft.SQLServer.2016.DBEngine.BufferCacheHitRatioMonitorMicrosoft.SQLServer.2016.DBEngineSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2016.DBEngine.BufferCacheHitRatio.MonitorTypeTruePublic
Microsoft.SQLServer.2016.DBEngine.Configuration.ServicePackLevelService Pack ComplianceMonitors the service pack level of the database engine against the compliant settingMicrosoft.SQLServer.2016.DBEngine.Configuration.ServicePackLevelMicrosoft.SQLServer.2016.DBEngineSystem.Health.ConfigurationStateConfigurationHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2016.ServicePackVersionTruePublic
Microsoft.SQLServer.2016.DBEngine.Configuration.SPNStatusMonitorService Principal Name Configuration StatusThis 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.2016.DBEngine.Configuration.SPNStatusMonitorMicrosoft.SQLServer.2016.DBEngineSystem.Health.ConfigurationStateAvailabilityHealthTrue0TrueWarningNormalTrueMicrosoft.SQLServer.2016.DBEngine.Configuration.SPNStatusTruePublic
Microsoft.SQLServer.2016.DBEngine.CPUUsagePercentMonitorCPU Utilization (\%)CPU Utilization (\%) for 2016 DB EngineMicrosoft.SQLServer.2016.DBEngine.CPUUsagePercentMonitorMicrosoft.SQLServer.2016.DBEngineSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2016.DBEngine.CPUUsagePercent.MonitorTypeTruePublic
Microsoft.SQLServer.2016.DBEngine.FullTextSearchServiceMonitorSQL Full-text Filter Daemon Launcher ServiceThis 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.FullTextSearchServiceMonitorMicrosoft.SQLServer.2016.DBEngineSystem.Health.AvailabilityStateAvailabilityHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.Windows.CheckNTServiceStateMonitorTypeTruePublic
Microsoft.SQLServer.2016.DBEngine.PageLifeExpectancyMonitorPage Life ExpectancyPage Life Expectancy (s) for 2016 DB EngineMicrosoft.SQLServer.2016.DBEngine.PageLifeExpectancyMonitorMicrosoft.SQLServer.2016.DBEngineSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2016.DBEngine.PageLifeExpectancy.MonitorTypeTruePublic
Microsoft.SQLServer.2016.DBEngine.ServiceMonitorSQL Server Windows ServiceThis monitor checks the status of the SQL Server Database Engine service.Microsoft.SQLServer.2016.DBEngine.ServiceMonitorMicrosoft.SQLServer.2016.DBEngineSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2016.CheckWinServiceStateMonitorTypeTruePublic
Microsoft.SQLServer.2016.DBEngine.SQLReCompilationMonitorSQL Re-CompilationSQL 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.SQLReCompilationMonitorMicrosoft.SQLServer.2016.DBEngineSystem.Health.PerformanceStatePerformanceHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2016.DBEngine.SQLReCompilation.MonitorTypeTruePublic
Microsoft.SQLServer.2016.DBEngine.StolenServerMemoryMonitorStolen Server MemoryStolen Server Memory for 2016 DB EngineMicrosoft.SQLServer.2016.DBEngine.StolenServerMemoryMonitorMicrosoft.SQLServer.2016.DBEngineSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2016.DBEngine.StolenServerMemory.MonitorTypeTruePublic
Microsoft.SQLServer.2016.DBEngine.ThreadCountMonitorThread CountThread Count for 2016 DB EngineMicrosoft.SQLServer.2016.DBEngine.ThreadCountMonitorMicrosoft.SQLServer.2016.DBEngineSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2016.DBEngine.ThreadCount.MonitorTypeTruePublic
Microsoft.SQLServer.2016.DBErrorUserPolicyStateMonitorDatabase Health PolicyTwo 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.DBErrorUserPolicyStateMonitorMicrosoft.SQLServer.2016.DatabaseErrorUserPolicySystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseTrueMicrosoft.SQLServer.2016.TwoStatePolicyMonitorTypeTruePublic
Microsoft.SQLServer.2016.DBWarningUserPolicyStateMonitorDatabase Health PolicyTwo 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.DBWarningUserPolicyStateMonitorMicrosoft.SQLServer.2016.DatabaseWarningUserPolicySystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseTrueMicrosoft.SQLServer.2016.TwoStatePolicyMonitorTypeTruePublic
Microsoft.SQLServer.2016.Monitor.Container.FreeSpacePercentMemory-Optimized Data Filegroup Container Free SpaceThe 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.FreeSpacePercentMicrosoft.SQLServer.2016.ContainerSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2016.MonitorType.Container.FreeSpacePercentTruePublic
Microsoft.SQLServer.2016.Monitor.DBFileGroupFx.GarbageCollectionState[Deprecated] Garbage CollectionThe 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.GarbageCollectionStateMicrosoft.SQLServer.2016.DBFileGroupFxSystem.Health.PerformanceStatePerformanceHealthFalse0TrueErrorNormalTrueMicrosoft.SQLServer.2016.MonitorType.DBFileGroupFx.GarbageCollectionStateTruePublic
Microsoft.SQLServer.2016.Monitor.DBFileGroupFx.StaleCFPsMemory-Optimized Data Stale Checkpoint File Pairs RatioThe 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.StaleCFPsMicrosoft.SQLServer.2016.DBFileGroupFxSystem.Health.PerformanceStatePerformanceHealthTrue0TrueWarningNormalTrueMicrosoft.SQLServer.2016.DBFileGroupFx.StaleCFPs.MonitorTypeTruePublic
Microsoft.SQLServer.2016.Monitor.UserResourcePool.MemoryConsumptionResource Pool Memory ConsumptionThe 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.MemoryConsumptionMicrosoft.SQLServer.2016.UserResourcePoolSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2016.MonitorType.UserResourcePool.MemoryConsumptionTruePublic
Microsoft.SQLServer.2016.Monitoring.DBFileSpaceMonitorDB File Free Space LeftThe 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.DBFileSpaceMonitorMicrosoft.SQLServer.2016.DBFileSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2016.DBFileSizeMonitorTypeTruePublic
Microsoft.SQLServer.2016.Monitoring.DBFileStreamGroupSpaceMonitorDB FILESTREAM Filegroup Free SpaceThe 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.DBFileStreamGroupSpaceMonitorMicrosoft.SQLServer.2016.DBFileGroupFdSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2016.DBFileStreamGroupSizeMonitorTypeTruePublic
Microsoft.SQLServer.2016.Monitoring.DBLogFileSpaceMonitorDB Log File Free Space LeftThe 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.DBLogFileSpaceMonitorMicrosoft.SQLServer.2016.DBLogFileSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2016.DBLogFileSizeMonitorTypeTruePublic
Microsoft.SQLServer.2016.Monitoring.HashIndexAvgChainLengthMonitorAverage length of the row chains in the hash bucketsThis monitor checks Hash Index Empty Buckets Count and Average Length of the Row Chains in the SQL Database.Microsoft.SQLServer.2016.Monitoring.HashIndexAvgChainLengthMonitorMicrosoft.SQLServer.2016.DBFileGroupFxSystem.Health.ConfigurationStateConfigurationHealthTrue0TrueWarningNormalTrueMicrosoft.SQLServer.2016.Monitoring.HashIndexAvgChainLength.MonitorTypeTruePublic
Microsoft.SQLServer.2016.Monitoring.HashIndexEmptyBucketsCountMonitorEmpty Bucket percent in the hash indexThis monitor checks Hash Index Empty Buckets Count in the SQL Database.Microsoft.SQLServer.2016.Monitoring.HashIndexEmptyBucketsCountMonitorMicrosoft.SQLServer.2016.DBFileGroupFxSystem.Health.ConfigurationStateConfigurationHealthTrue0TrueWarningNormalTrueMicrosoft.SQLServer.2016.Monitoring.HashIndexEmptyBucketsCount.MonitorTypeTruePublic
Microsoft.SQLServer.2016.Monitoring.XTPConfigurationMonitorXTP ConfigurationThis monitor checks the status of the SQL Database XTP Configuration. Note that this monitor works only with Enterprise, Developer, and Evaluation editions of Microsoft SQL Server. With other editions, the monitor will always be in healthy state.Microsoft.SQLServer.2016.Monitoring.XTPConfigurationMonitorMicrosoft.SQLServer.2016.DBFileGroupFxSystem.Health.ConfigurationStateConfigurationHealthTrue0TrueWarningNormalTrueMicrosoft.SQLServer.2016.Monitoring.XTPConfiguration.MonitorTypeTruePublic
Microsoft.SQLServer.2016.UnitMonitor.DBEngine.SmartAdminSystemHealthPolicyManaged Backup System Health PolicyThe 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.SmartAdminSystemHealthPolicyMicrosoft.SQLServer.2016.DBEngineSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2016.MonitorType.DBEngine.SmartAdminHealthPolicyTruePublic
Microsoft.SQLServer.2016.UnitMonitor.DBEngine.SmartAdminUserActionHealthPolicyManaged Backup User Action Health PolicyThe Managed Backup User Action Health Policy evaluates warnings such as corrupted backups, etc. These warnings may not require any action but just a warning of an event.Microsoft.SQLServer.2016.UnitMonitor.DBEngine.SmartAdminUserActionHealthPolicyMicrosoft.SQLServer.2016.DBEngineSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueWarningNormalTrueMicrosoft.SQLServer.2016.MonitorType.DBEngine.SmartAdminHealthPolicyTruePublic