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

 DisplayNameDescriptionIDTargetParent MonitorCategoryEnabledInstance NameCounter NameFrequencyAlert GenerateAlert SeverityAlert PriorityAlert Auto ResolveMonitor TypeRemotableAccessibilityRunAs
Microsoft.SQLServer.Linux.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 no Log Shipping is supported by any edition of SQL Server Express.Microsoft.SQLServer.Linux.Database.LogShippingSourceMonitorMicrosoft.SQLServer.Linux.DatabaseSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.Linux.MonitorType.Database.LogShippingTruePublic
Microsoft.SQLServer.Linux.DBEngine.Configuration.SecurablesConfigMonitorSecurables Configuration StatusThis monitor checks the status of SQL Server securables access configuration on Linux.Microsoft.SQLServer.Linux.DBEngine.Configuration.SecurablesConfigMonitorMicrosoft.SQLServer.Linux.DBEngineSystem.Health.ConfigurationStateConfigurationHealthTrue0TrueWarningNormalTrueMicrosoft.SQLServer.Linux.MonitorType.SecurablesConfigTruePublic
Microsoft.SQLServer.Linux.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 no Log Shipping is supported by any edition of SQL Server Express.Microsoft.SQLServer.Linux.LogShippingDestinationMonitorMicrosoft.SQLServer.Linux.DatabaseSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.Linux.MonitorType.Database.LogShippingTruePublic
Microsoft.SQLServer.Linux.Monitor.Agent.LongRunningJobsLong Running JobsThis monitor checks for long running SQL Agent jobs. Note that this 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.Linux.Monitor.Agent.LongRunningJobsMicrosoft.SQLServer.Linux.AgentSystem.Health.PerformanceStatePerformanceHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.Linux.MonitorType.Agent.LongRunningJobsTruePublic
Microsoft.SQLServer.Linux.Monitor.Agent.ServiceStatusSQL Server Agent ServiceThis monitor checks the status of the SQL Agent service for this instance of SQL Server. Note that SQL Server Agent Linux Service is not supported by any edition of SQL Server Express.Microsoft.SQLServer.Linux.Monitor.Agent.ServiceStatusMicrosoft.SQLServer.Linux.AgentSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.Linux.MonitorType.SqlServiceStatusTruePublic
Microsoft.SQLServer.Linux.Monitor.AgentJob.DurationJob DurationThis monitor checks the Agent Job Duration. Note that SQL Server Agent Linux Service is not supported by any edition of SQL Server Express.Microsoft.SQLServer.Linux.Monitor.AgentJob.DurationMicrosoft.SQLServer.Linux.AgentJobSystem.Health.PerformanceStatePerformanceCollectionTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.Linux.MonitorType.AgentJob.DurationTruePublic
Microsoft.SQLServer.Linux.Monitor.AgentJob.LastRunStateLast Run StatusThis monitor checks the last run state of the SQL Agent Job. Note that SQL Server Agent Linux Service is not supported by any edition of SQL Server Express.Microsoft.SQLServer.Linux.Monitor.AgentJob.LastRunStateMicrosoft.SQLServer.Linux.AgentJobSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueWarningNormalTrueMicrosoft.SQLServer.Linux.MonitorType.AgentJob.LastRunStateTruePublic
Microsoft.SQLServer.Linux.Monitor.AvailabilityDatabaseHealth.BackupStatusAvailability Database Backup StatusThis 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. Note that this monitor is disabled by default. Use overrides to enable it when necessary.Microsoft.SQLServer.Linux.Monitor.AvailabilityDatabaseHealth.BackupStatusMicrosoft.SQLServer.Linux.AvailabilityDatabaseHealthSystem.Health.AvailabilityStateAvailabilityHealthFalse0FalseTrueMicrosoft.SQLServer.Linux.MonitorType.AvailabilityDatabaseHealth.BackupStatusTruePublic
Microsoft.SQLServer.Linux.Monitor.AvailabilityDatabaseHealth.DBLogBackupStatusAvailability Database Log Backup StatusThis monitor checks the status of the database log backup as reported by Microsoft SQL Server, it does not apply any logic regarding the replicas preferred for the backup. Note that this monitor is disabled by default. Use overrides to enable it when necessary.Microsoft.SQLServer.Linux.Monitor.AvailabilityDatabaseHealth.DBLogBackupStatusMicrosoft.SQLServer.Linux.AvailabilityDatabaseHealthSystem.Health.AvailabilityStateAvailabilityHealthFalse0FalseTrueMicrosoft.SQLServer.Linux.MonitorType.AvailabilityDatabaseHealth.DBLogBackupStatusTruePublic
Microsoft.SQLServer.Linux.Monitor.AvailabilityGroupErrorPolicy.StateAvailability Group Health PolicyThis 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.Linux.Monitor.AvailabilityGroupErrorPolicy.StateMicrosoft.SQLServer.Linux.AvailabilityGroupErrorUserPolicySystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseTrueMicrosoft.SQLServer.Linux.MonitorType.UserPolicyTruePublic
Microsoft.SQLServer.Linux.Monitor.AvailabilityGroupHealth.AllAvailabilityReplicasAreConnectedAvailability Replicas Connection monitorThis monitor rolls up the connection state of all availability replicas and check whether any availability replica is DISCONNECTED. The monitor is unhealthy when any availability replica is DISCONNECTED. The monitor is healthy otherwise.Microsoft.SQLServer.Linux.Monitor.AvailabilityGroupHealth.AllAvailabilityReplicasAreConnectedMicrosoft.SQLServer.Linux.AvailabilityGroupHealthSystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseTrueMicrosoft.SQLServer.Linux.MonitorType.AlwaysOnSystemPolicyWithSamplingTruePublic
Microsoft.SQLServer.Linux.Monitor.AvailabilityGroupHealth.AutomaticFailoverReadinessAvailability Group Automatic Failover monitorThis monitor checks whether the Availability Group has at least one secondary replica which is failover ready. The monitor becomes unhealthy and alert is registered when the failover mode of primary replica is automatic but none of secondary replica in the Availability Group is automatic failover ready. The monitor is healthy when at least one secondary replica is automatic failover ready.Microsoft.SQLServer.Linux.Monitor.AvailabilityGroupHealth.AutomaticFailoverReadinessMicrosoft.SQLServer.Linux.AvailabilityGroupHealthSystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseTrueMicrosoft.SQLServer.Linux.MonitorType.AlwaysOnSystemPolicyWithSamplingTruePublic
Microsoft.SQLServer.Linux.Monitor.AvailabilityGroupHealth.AvailabilityGroupOnlineAvailability Group Online monitorAvailability Group OnlineMicrosoft.SQLServer.Linux.Monitor.AvailabilityGroupHealth.AvailabilityGroupOnlineMicrosoft.SQLServer.Linux.AvailabilityGroupHealthSystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseTrueMicrosoft.SQLServer.Linux.MonitorType.AlwaysOnSystemPolicyWithSamplingTruePublic
Microsoft.SQLServer.Linux.Monitor.AvailabilityGroupHealth.AvailabilityReplicaRoleStateAvailability Replicas Role monitorThis monitor rolls up the state of role of all availability replicas and checks whether any availability replica is not in a healthy role. The monitor is unhealthy when any availability replica is neither primary nor secondary. The monitor is healthy state otherwise.Microsoft.SQLServer.Linux.Monitor.AvailabilityGroupHealth.AvailabilityReplicaRoleStateMicrosoft.SQLServer.Linux.AvailabilityGroupHealthSystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseTrueMicrosoft.SQLServer.Linux.MonitorType.AlwaysOnSystemPolicyWithSamplingTruePublic
Microsoft.SQLServer.Linux.Monitor.AvailabilityGroupHealth.AvailabilityReplicasSynchronizationStateSynchronous Replicas Data Synchronization monitorThis monitor rolls up the data synchronization state of all availability replicas and checks whether any availability replica is not in the expected synchronization state. The monitor is unhealthy when any asynchronous replica is not in SYNCHRONIZING state and any synchronous replica is not in SYNCHRONIZED state. The monitor state is healthy otherwise.Microsoft.SQLServer.Linux.Monitor.AvailabilityGroupHealth.AvailabilityReplicasSynchronizationStateMicrosoft.SQLServer.Linux.AvailabilityGroupHealthSystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseTrueMicrosoft.SQLServer.Linux.MonitorType.AlwaysOnSystemPolicyWithSamplingTruePublic
Microsoft.SQLServer.Linux.Monitor.AvailabilityGroupHealth.AvailabilityReplicasSynchronizingAvailability Replicas Data Synchronization monitorThis monitor rolls up the data synchronization state of all availability replicas and checks whether any availability replica is not in the expected synchronization state. The monitor is unhealthy when any asynchronous replica is not in SYNCHRONIZING state and any synchronous replica is not in SYNCHRONIZED state. The monitor state is healthy otherwise.Microsoft.SQLServer.Linux.Monitor.AvailabilityGroupHealth.AvailabilityReplicasSynchronizingMicrosoft.SQLServer.Linux.AvailabilityGroupHealthSystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseTrueMicrosoft.SQLServer.Linux.MonitorType.AlwaysOnSystemPolicyWithSamplingTruePublic
Microsoft.SQLServer.Linux.Monitor.AvailabilityGroupWarningPolicy.StateAvailability Group Health PolicyThis 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.Linux.Monitor.AvailabilityGroupWarningPolicy.StateMicrosoft.SQLServer.Linux.AvailabilityGroupWarningUserPolicySystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseTrueMicrosoft.SQLServer.Linux.MonitorType.UserPolicyTruePublic
Microsoft.SQLServer.Linux.Monitor.AvailabilityReplica.DataSynchronizationHealthAvailability Replica Data SynchronizationThis 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.Linux.Monitor.AvailabilityReplica.DataSynchronizationHealthMicrosoft.SQLServer.Linux.AvailabilityReplicaSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.Linux.MonitorType.AlwaysOnSystemPolicyTruePublic
Microsoft.SQLServer.Linux.Monitor.AvailabilityReplica.IsConnectedAvailability Replica ConnectionThis 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.Linux.Monitor.AvailabilityReplica.IsConnectedMicrosoft.SQLServer.Linux.AvailabilityReplicaSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.Linux.MonitorType.AlwaysOnSystemPolicyTruePublic
Microsoft.SQLServer.Linux.Monitor.AvailabilityReplica.RoleIsHealthyAvailability Replica RoleThis 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.Linux.Monitor.AvailabilityReplica.RoleIsHealthyMicrosoft.SQLServer.Linux.AvailabilityReplicaSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.Linux.MonitorType.AlwaysOnSystemPolicyTruePublic
Microsoft.SQLServer.Linux.Monitor.AvailabilityReplicaErrorPolicy.StateAvailability Replica Health PolicyThis 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.Linux.Monitor.AvailabilityReplicaErrorPolicy.StateMicrosoft.SQLServer.Linux.AvailabilityReplicaErrorUserPolicySystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseTrueMicrosoft.SQLServer.Linux.MonitorType.UserPolicyTruePublic
Microsoft.SQLServer.Linux.Monitor.AvailabilityReplicaWarningPolicy.StateAvailability Replica Health PolicyThis 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.Linux.Monitor.AvailabilityReplicaWarningPolicy.StateMicrosoft.SQLServer.Linux.AvailabilityReplicaWarningUserPolicySystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseTrueMicrosoft.SQLServer.Linux.MonitorType.UserPolicyTruePublic
Microsoft.SQLServer.Linux.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.Linux.Monitor.Container.FreeSpacePercentMicrosoft.SQLServer.Linux.ContainerSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.Linux.MonitorType.Container.FreeSpacePercentTruePublic
Microsoft.SQLServer.Linux.Monitor.Database.AutoCloseConfigurationAuto Close ConfigurationMonitors the Auto Close setting for the database on Linux. Note that this monitor is disabled by default. Use overrides to enable it when necessary.Microsoft.SQLServer.Linux.Monitor.Database.AutoCloseConfigurationMicrosoft.SQLServer.Linux.DatabaseMicrosoft.SQLServer.Linux.Rollup.Database.AutomaticConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.Linux.MonitorType.Database.DBConfigurationStatusTruePublic
Microsoft.SQLServer.Linux.Monitor.Database.AutoCreateStatConfigurationAuto Create Statistics ConfigurationMonitors the Auto Create Statistic setting for the database. Note that this monitor is disabled by default. Use overrides to enable it when necessary.Microsoft.SQLServer.Linux.Monitor.Database.AutoCreateStatConfigurationMicrosoft.SQLServer.Linux.DatabaseMicrosoft.SQLServer.Linux.Rollup.Database.AutomaticConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.Linux.MonitorType.Database.DBConfigurationStatusTruePublic
Microsoft.SQLServer.Linux.Monitor.Database.AutoShrinkConfigurationAuto Shrink ConfigurationMonitors the Auto Shrink setting for the database. Note that this monitor is disabled by default. Use overrides to enable it when necessary.Microsoft.SQLServer.Linux.Monitor.Database.AutoShrinkConfigurationMicrosoft.SQLServer.Linux.DatabaseMicrosoft.SQLServer.Linux.Rollup.Database.AutomaticConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.Linux.MonitorType.Database.DBConfigurationStatusTruePublic
Microsoft.SQLServer.Linux.Monitor.Database.AutoUpdateStatAsyncConfigurationAuto Update Statistics Async ConfigurationMonitors the Auto Update Statistics Asynchronously setting for the database. Note that this monitor is disabled by default. Use overrides to enable it when necessary.Microsoft.SQLServer.Linux.Monitor.Database.AutoUpdateStatAsyncConfigurationMicrosoft.SQLServer.Linux.DatabaseMicrosoft.SQLServer.Linux.Rollup.Database.AutomaticConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.Linux.MonitorType.Database.DBConfigurationStatusTruePublic
Microsoft.SQLServer.Linux.Monitor.Database.AutoUpdateStatConfigurationAuto Update Statistics ConfigurationMonitors the Auto Update Statistics setting for the database. Note that this monitor is disabled by default. Use overrides to enable it when necessary.Microsoft.SQLServer.Linux.Monitor.Database.AutoUpdateStatConfigurationMicrosoft.SQLServer.Linux.DatabaseMicrosoft.SQLServer.Linux.Rollup.Database.AutomaticConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.Linux.MonitorType.Database.DBConfigurationStatusTruePublic
Microsoft.SQLServer.Linux.Monitor.Database.DBBackupStatusDatabase Backup StatusThis monitor checks the status of the database backup as reported by Microsoft SQL Server. Note that this monitor is disabled by default. Use overrides to enable it when necessary.Microsoft.SQLServer.Linux.Monitor.Database.DBBackupStatusMicrosoft.SQLServer.Linux.DatabaseSystem.Health.AvailabilityStateAvailabilityHealthFalse0TrueErrorNormalTrueMicrosoft.SQLServer.Linux.MonitorType.Database.DBBackupStatusTruePublic
Microsoft.SQLServer.Linux.Monitor.Database.DBChainingConfigurationDB Chaining ConfigurationMonitors the Cross-database Ownership Chaining Enabled setting for the database. Note that this monitor is disabled by default. Use overrides to enable it when necessary.Microsoft.SQLServer.Linux.Monitor.Database.DBChainingConfigurationMicrosoft.SQLServer.Linux.DatabaseMicrosoft.SQLServer.Linux.Rollup.Database.ExternalAccessConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.Linux.MonitorType.Database.DBConfigurationStatusTruePublic
Microsoft.SQLServer.Linux.Monitor.Database.DBDiskReadLatencyDB Disk Read LatencyMonitors the disk Read latency (ms) from all logical disks which host database files. Note that this monitor is disabled by default. Use overrides to enable it when necessary.Microsoft.SQLServer.Linux.Monitor.Database.DBDiskReadLatencyMicrosoft.SQLServer.Linux.DatabaseSystem.Health.PerformanceStatePerformanceHealthFalse0TrueMatchMonitorHealthHighTrueMicrosoft.SQLServer.Linux.MonitorType.Database.DBDiskReadLatencyTruePublic
Microsoft.SQLServer.Linux.Monitor.Database.DBDiskWriteLatencyDB Disk Write LatencyMonitors the disk Write latency (ms) from all logical disks which host database files. Note that this monitor is disabled by default. Use overrides to enable it when necessary.Microsoft.SQLServer.Linux.Monitor.Database.DBDiskWriteLatencyMicrosoft.SQLServer.Linux.DatabaseSystem.Health.PerformanceStatePerformanceHealthFalse0TrueMatchMonitorHealthHighTrueMicrosoft.SQLServer.Linux.MonitorType.Database.DBDiskWriteLatencyTruePublic
Microsoft.SQLServer.Linux.Monitor.Database.DBLogBackupStatusDatabase Log Backup StatusThis monitor checks the status of the database log backup as reported by Microsoft SQL Server. Note that this monitor is disabled by default. Use overrides to enable it when necessary.Microsoft.SQLServer.Linux.Monitor.Database.DBLogBackupStatusMicrosoft.SQLServer.Linux.DatabaseSystem.Health.AvailabilityStateAvailabilityHealthFalse0TrueErrorNormalTrueMicrosoft.SQLServer.Linux.MonitorType.Database.DBLogBackupStatusTruePublic
Microsoft.SQLServer.Linux.Monitor.Database.DBStatusDatabase StatusThis monitor checks the status of the database as reported by Microsoft SQL Server.Microsoft.SQLServer.Linux.Monitor.Database.DBStatusMicrosoft.SQLServer.Linux.DatabaseSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.Linux.MonitorType.Database.DBStatusTruePublic
Microsoft.SQLServer.Linux.Monitor.Database.PageVerifyConfigurationPage Verify ConfigurationMonitors the Page Verify setting for the database. Note that this monitor is disabled by default. Use overrides to enable it when necessary.Microsoft.SQLServer.Linux.Monitor.Database.PageVerifyConfigurationMicrosoft.SQLServer.Linux.DatabaseMicrosoft.SQLServer.Linux.Rollup.Database.RecoveryConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.Linux.MonitorType.Database.DBConfigurationStatusTruePublic
Microsoft.SQLServer.Linux.Monitor.Database.RecoveryModelConfigurationRecovery Model ConfigurationMonitors the Recovery model setting for the database. Note that this monitor is disabled by default. Use overrides to enable it when necessary.Microsoft.SQLServer.Linux.Monitor.Database.RecoveryModelConfigurationMicrosoft.SQLServer.Linux.DatabaseMicrosoft.SQLServer.Linux.Rollup.Database.RecoveryConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.Linux.MonitorType.Database.DBConfigurationStatusTruePublic
Microsoft.SQLServer.Linux.Monitor.Database.SecurablesDbConfigSecurables Configuration StatusThis monitor checks the status of SQL Server securables access configuration on Linux.Microsoft.SQLServer.Linux.Monitor.Database.SecurablesDbConfigMicrosoft.SQLServer.Linux.DatabaseSystem.Health.ConfigurationStateConfigurationHealthTrue0TrueWarningNormalTrueMicrosoft.SQLServer.Linux.MonitorType.Database.SecurablesDbConfigTruePublic
Microsoft.SQLServer.Linux.Monitor.Database.TdeDekCertBackupStatusTDE Certificate Backup StatusThis monitor checks that the certificate used for encrypting the database encryption key hasn't been backed up. Note that this monitor is disabled by default. Use overrides to enable it when necessary.Microsoft.SQLServer.Linux.Monitor.Database.TdeDekCertBackupStatusMicrosoft.SQLServer.Linux.DatabaseSystem.Health.SecurityStateConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.Linux.MonitorType.Database.TdeDekCertBackupStatusTruePublic
Microsoft.SQLServer.Linux.Monitor.Database.TrustWorthyConfigurationTrustworthy ConfigurationMonitors the Trustworthy setting for the database. Note that this monitor is disabled by default. Use overrides to enable it when necessary.Microsoft.SQLServer.Linux.Monitor.Database.TrustWorthyConfigurationMicrosoft.SQLServer.Linux.DatabaseMicrosoft.SQLServer.Linux.Rollup.Database.ExternalAccessConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.Linux.MonitorType.Database.DBConfigurationStatusTruePublic
Microsoft.SQLServer.Linux.Monitor.Database.VLFCountVirtual Log File CountVirtual Log File Count monitor for SQL DBs on Linux. Note that this monitor is disabled by default. Use overrides to enable it when necessary.Microsoft.SQLServer.Linux.Monitor.Database.VLFCountMicrosoft.SQLServer.Linux.DatabaseSystem.Health.PerformanceStatePerformanceHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.Linux.MonitorType.Database.VLFCountTruePublic
Microsoft.SQLServer.Linux.Monitor.DatabaseErrorUserPolicy.DBErrorUserPolicyStateDatabase 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.Linux.Monitor.DatabaseErrorUserPolicy.DBErrorUserPolicyStateMicrosoft.SQLServer.Linux.DatabaseErrorUserPolicySystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.Linux.MonitorType.UserPolicyTruePublic
Microsoft.SQLServer.Linux.Monitor.DatabaseReplica.DataSynchronizationStateAvailability Database Data SynchronizationThis monitor checks the data synchronization state of database replica. The monitor is unhealthy when the data synchronization state is NOT SYNCHRONIZING or the state is not SYNCHRONIZED for synchronous commit database replica.Microsoft.SQLServer.Linux.Monitor.DatabaseReplica.DataSynchronizationStateMicrosoft.SQLServer.Linux.DatabaseReplicaSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.Linux.MonitorType.AlwaysOnSystemPolicyTruePublic
Microsoft.SQLServer.Linux.Monitor.DatabaseReplica.SuspendStateAvailability Database Suspension StateThis 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.Linux.Monitor.DatabaseReplica.SuspendStateMicrosoft.SQLServer.Linux.DatabaseReplicaSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.Linux.MonitorType.AlwaysOnSystemPolicyTruePublic
Microsoft.SQLServer.Linux.Monitor.DatabaseReplicaErrorPolicy.StateDatabase Replica Health PolicyTwo-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.Linux.Monitor.DatabaseReplicaErrorPolicy.StateMicrosoft.SQLServer.Linux.DatabaseReplicaErrorUserPolicySystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseTrueMicrosoft.SQLServer.Linux.MonitorType.UserPolicyTruePublic
Microsoft.SQLServer.Linux.Monitor.DatabaseReplicaWarningPolicy.StateDatabase Replica Health PolicyTwo-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.Linux.Monitor.DatabaseReplicaWarningPolicy.StateMicrosoft.SQLServer.Linux.DatabaseReplicaWarningUserPolicySystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseTrueMicrosoft.SQLServer.Linux.MonitorType.UserPolicyTruePublic
Microsoft.SQLServer.Linux.Monitor.DatabaseWarningUserPolicy.DBWarningUserPolicyStateDatabase 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.Linux.Monitor.DatabaseWarningUserPolicy.DBWarningUserPolicyStateMicrosoft.SQLServer.Linux.DatabaseWarningUserPolicySystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueWarningNormalTrueMicrosoft.SQLServer.Linux.MonitorType.UserPolicyTruePublic
Microsoft.SQLServer.Linux.Monitor.DBEngine.AverageWaitTimeAverage Wait TimeAverage Wait Time monitor for DBsMicrosoft.SQLServer.Linux.Monitor.DBEngine.AverageWaitTimeMicrosoft.SQLServer.Linux.DBEngineSystem.Health.PerformanceStatePerformanceHealthTrue0TrueWarningNormalTrueMicrosoft.SQLServer.Linux.MonitorType.DBEngine.AverageWaitTimeTruePublic
Microsoft.SQLServer.Linux.Monitor.DBEngine.BlockingSessionsBlocking SessionsMonitors blocked sessions for a SQL instance on Linux. Note that this monitor is disabled by default. Use overrides to enable it when necessary.Microsoft.SQLServer.Linux.Monitor.DBEngine.BlockingSessionsMicrosoft.SQLServer.Linux.DBEngineSystem.Health.PerformanceStatePerformanceHealthFalse0TrueErrorHighTrueMicrosoft.SQLServer.Linux.MonitorType.DBEngine.BlockingSessionsTruePublic
Microsoft.SQLServer.Linux.Monitor.DBEngine.BufferCacheHitRatioBuffer Cache Hit RatioBuffer Cache Hit Ratio for DB Engine. Note that this monitor is disabled by default. Use overrides to enable it when necessary.Microsoft.SQLServer.Linux.Monitor.DBEngine.BufferCacheHitRatioMicrosoft.SQLServer.Linux.DBEngineSystem.Health.PerformanceStatePerformanceHealthFalse0TrueErrorNormalTrueMicrosoft.SQLServer.Linux.MonitorType.DBEngine.BufferCacheHitRatioTruePublic
Microsoft.SQLServer.Linux.Monitor.DBEngine.DBEngineStatusDB Engine Health StatusThis monitor checks the health state of the SQL Server DB Engine.Microsoft.SQLServer.Linux.Monitor.DBEngine.DBEngineStatusMicrosoft.SQLServer.Linux.DBEngineSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.Linux.MonitorType.DBEngine.DBEngineStatusTruePublic
Microsoft.SQLServer.Linux.Monitor.DBEngine.FullTextServiceStatusSQL 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. Use overrides to enable it when necessary.Microsoft.SQLServer.Linux.Monitor.DBEngine.FullTextServiceStatusMicrosoft.SQLServer.Linux.DBEngineSystem.Health.AvailabilityStateAvailabilityHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.Linux.MonitorType.SqlServiceStatusTruePublic
Microsoft.SQLServer.Linux.Monitor.DBEngine.PageLifeExpectancyPage Life ExpectancyPage Life Expectancy (in seconds) for DB Engine. Note that this monitor is disabled by default. Use overrides to enable it when necessary.Microsoft.SQLServer.Linux.Monitor.DBEngine.PageLifeExpectancyMicrosoft.SQLServer.Linux.DBEngineSystem.Health.PerformanceStatePerformanceHealthFalse0TrueErrorNormalTrueMicrosoft.SQLServer.Linux.MonitorType.DBEngine.PageLifeExpectancyTruePublic
Microsoft.SQLServer.Linux.Monitor.DBEngine.ServicePackLevelProduct Version ComplianceThis monitor checks the product version number of the current SQL Server instance to determine the currently installed Cumulative Update. Microsoft.SQLServer.Linux.Monitor.DBEngine.ServicePackLevelMicrosoft.SQLServer.Linux.DBEngineSystem.Health.ConfigurationStateConfigurationHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.Linux.MonitorType.DBEngine.ServicePackLevelTruePublic
Microsoft.SQLServer.Linux.Monitor.DBEngine.SmartAdminSystemHealthPolicyManaged Backup System Health PolicyThe Managed Backup System Health Policy produces errors like lack of or invalid SQL Credentials, connectivity errors and reports the health of the system. Note that this monitor is disabled by default. Use overrides to enable it when necessary.Microsoft.SQLServer.Linux.Monitor.DBEngine.SmartAdminSystemHealthPolicyMicrosoft.SQLServer.Linux.DBEngineSystem.Health.AvailabilityStateAvailabilityHealthFalse0TrueErrorNormalTrueMicrosoft.SQLServer.Linux.MonitorType.DBEngine.SmartAdminHealthPolicyTruePublic
Microsoft.SQLServer.Linux.Monitor.DBEngine.SmartAdminUserActionHealthPolicyManaged Backup User Action Health PolicyThe Managed Backup User Action Health Policy monitor produces warnings when corrupted backups are found. Note that this monitor is disabled by default. Use overrides to enable it when necessary.Microsoft.SQLServer.Linux.Monitor.DBEngine.SmartAdminUserActionHealthPolicyMicrosoft.SQLServer.Linux.DBEngineSystem.Health.AvailabilityStateAvailabilityHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.Linux.MonitorType.DBEngine.SmartAdminHealthPolicyTruePublic
Microsoft.SQLServer.Linux.Monitor.DBEngine.SQLRecompilationSQL Re-CompilationSQL Re-Compilation for DB Engine. Note that this monitor is disabled by default. Use overrides to enable it when necessary.Microsoft.SQLServer.Linux.Monitor.DBEngine.SQLRecompilationMicrosoft.SQLServer.Linux.DBEngineSystem.Health.PerformanceStatePerformanceHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.Linux.MonitorType.DBEngine.SQLRecompilationTruePublic
Microsoft.SQLServer.Linux.Monitor.DBEngine.StolenServerMemoryStolen Server MemoryStolen Server Memory for DB EngineMicrosoft.SQLServer.Linux.Monitor.DBEngine.StolenServerMemoryMicrosoft.SQLServer.Linux.DBEngineSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.Linux.MonitorType.DBEngine.StolenServerMemoryTruePublic
Microsoft.SQLServer.Linux.Monitor.DBEngine.ThreadCountThread CountMonitors free thread count for Microsoft SQL Server instance on Linux.Microsoft.SQLServer.Linux.Monitor.DBEngine.ThreadCountMicrosoft.SQLServer.Linux.DBEngineSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.Linux.MonitorType.DBEngine.ThreadCountTruePublic
Microsoft.SQLServer.Linux.Monitor.DBFile.DBFileSpaceDB 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.Linux.Monitor.DBFile.DBFileSpaceMicrosoft.SQLServer.Linux.DBFileSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.Linux.MonitorType.DBFile.DBFileSpaceTruePublic
Microsoft.SQLServer.Linux.Monitor.DBFilegroupFx.HashIndexAvgChainLengthAverage 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.Linux.Monitor.DBFilegroupFx.HashIndexAvgChainLengthMicrosoft.SQLServer.Linux.DBFilegroupFxSystem.Health.ConfigurationStateConfigurationHealthTrue0TrueWarningNormalTrueMicrosoft.SQLServer.Linux.MonitorType.DBFilegroupFx.HashIndexAvgChainLengthTruePublic
Microsoft.SQLServer.Linux.Monitor.DBFilegroupFx.HashIndexEmptyBucketsCountEmpty Bucket percent in the hash indexThis monitor checks Hash Index Empty Buckets Count in the SQL Database.Microsoft.SQLServer.Linux.Monitor.DBFilegroupFx.HashIndexEmptyBucketsCountMicrosoft.SQLServer.Linux.DBFilegroupFxSystem.Health.ConfigurationStateConfigurationHealthTrue0TrueWarningNormalTrueMicrosoft.SQLServer.Linux.MonitorType.DBFilegroupFx.HashIndexEmptyBucketsCountTruePublic
Microsoft.SQLServer.Linux.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.Linux.Monitor.DBFilegroupFx.StaleCFPsMicrosoft.SQLServer.Linux.DBFilegroupFxSystem.Health.PerformanceStatePerformanceHealthTrue0TrueWarningNormalTrueMicrosoft.SQLServer.Linux.MonitorType.DBFilegroupFx.StaleCFPsTruePublic
Microsoft.SQLServer.Linux.Monitor.DBFilegroupFx.XTPConfigurationMonitorXTP ConfigurationThis monitor checks the status of the SQL Database XTP configuration. Note that this monitor does not check if an XTP container and the log file are stored on different physical disks due to Linux specifics.Microsoft.SQLServer.Linux.Monitor.DBFilegroupFx.XTPConfigurationMonitorMicrosoft.SQLServer.Linux.DBFilegroupFxSystem.Health.ConfigurationStateConfigurationHealthTrue0TrueWarningNormalTrueMicrosoft.SQLServer.Linux.MonitorType.DBFilegroupFx.XTPConfigurationTruePublic
Microsoft.SQLServer.Linux.Monitor.DBLogFile.DBLogFileSpaceDB 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.Linux.Monitor.DBLogFile.DBLogFileSpaceMicrosoft.SQLServer.Linux.DBLogFileSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.Linux.MonitorType.DBLogFile.DBLogFileSpaceTruePublic
Microsoft.SQLServer.Linux.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.Linux.Monitor.UserResourcePool.MemoryConsumptionMicrosoft.SQLServer.Linux.UserResourcePoolSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.Linux.MonitorType.UserResourcePool.MemoryConsumptionTruePublic