| | 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 |
|---|
 | Securables Configuration Status | This monitor checks the status of Managed Instance securables’ access configuration. | Microsoft.Azure.ManagedInstance.DBEngine.Configuration.SecurablesConfigMonitor | Microsoft.Azure.ManagedInstance.DBEngine | System.Health.ConfigurationState | AvailabilityHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.Azure.ManagedInstance.MonitorType.SecurablesConfig | 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.Azure.ManagedInstance.Monitor.Database.AutoCloseConfiguration | Microsoft.Azure.ManagedInstance.Database | Microsoft.Azure.ManagedInstance.Rollup.Database.AutomaticConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.Azure.ManagedInstance.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.Azure.ManagedInstance.Monitor.Database.AutoCreateStatConfiguration | Microsoft.Azure.ManagedInstance.Database | Microsoft.Azure.ManagedInstance.Rollup.Database.AutomaticConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.Azure.ManagedInstance.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.Azure.ManagedInstance.Monitor.Database.AutoShrinkConfiguration | Microsoft.Azure.ManagedInstance.Database | Microsoft.Azure.ManagedInstance.Rollup.Database.AutomaticConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.Azure.ManagedInstance.MonitorType.Database.DBConfigurationStatus | True | Public | |
| Auto Update Statistics Async Configuration | Monitors the Auto Update Statistics Asynchronously setting for the database. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. | Microsoft.Azure.ManagedInstance.Monitor.Database.AutoUpdateStatAsyncConfiguration | Microsoft.Azure.ManagedInstance.Database | Microsoft.Azure.ManagedInstance.Rollup.Database.AutomaticConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.Azure.ManagedInstance.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.Azure.ManagedInstance.Monitor.Database.AutoUpdateStatConfiguration | Microsoft.Azure.ManagedInstance.Database | Microsoft.Azure.ManagedInstance.Rollup.Database.AutomaticConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.Azure.ManagedInstance.MonitorType.Database.DBConfigurationStatus | True | Public | |
| Database Backup Status | This monitor checks the status of the database backup as reported by Microsoft Managed Instance. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. | Microsoft.Azure.ManagedInstance.Monitor.Database.DBBackupStatus | Microsoft.Azure.ManagedInstance.Database | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.Azure.ManagedInstance.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.Azure.ManagedInstance.Monitor.Database.DBChainingConfiguration | Microsoft.Azure.ManagedInstance.Database | Microsoft.Azure.ManagedInstance.Rollup.Database.ExternalAccessConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.Azure.ManagedInstance.MonitorType.Database.DBConfigurationStatus | True | Public | |
| Database Status | This monitor checks the status of the database as reported by Microsoft Managed Instance. | Microsoft.Azure.ManagedInstance.Monitor.Database.DBStatus | Microsoft.Azure.ManagedInstance.Database | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.Azure.ManagedInstance.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.Azure.ManagedInstance.Monitor.Database.PageVerifyConfiguration | Microsoft.Azure.ManagedInstance.Database | Microsoft.Azure.ManagedInstance.Rollup.Database.RecoveryConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.Azure.ManagedInstance.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.Azure.ManagedInstance.Monitor.Database.RecoveryModelConfiguration | Microsoft.Azure.ManagedInstance.Database | Microsoft.Azure.ManagedInstance.Rollup.Database.RecoveryConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.Azure.ManagedInstance.MonitorType.Database.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.Azure.ManagedInstance.Monitor.Database.TrustWorthyConfiguration | Microsoft.Azure.ManagedInstance.Database | Microsoft.Azure.ManagedInstance.Rollup.Database.ExternalAccessConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.Azure.ManagedInstance.MonitorType.Database.DBConfigurationStatus | True | Public | |
| Average Wait Time | Average Wait Time monitor for databases | Microsoft.Azure.ManagedInstance.Monitor.DBEngine.AverageWaitTime | Microsoft.Azure.ManagedInstance.DBEngine | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.Azure.ManagedInstance.MonitorType.DBEngine.AverageWaitTime | True | Public | |
| Blocking Sessions | Monitors blocked sessions for a Managed Instance. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. | Microsoft.Azure.ManagedInstance.Monitor.DBEngine.BlockingSessions | Microsoft.Azure.ManagedInstance.DBEngine | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | High | True | Microsoft.Azure.ManagedInstance.MonitorType.DBEngine.BlockingSessions | True | Public | |
| Buffer Cache Hit Ratio | Buffer Cache Hit Ratio for Managed Instance | Microsoft.Azure.ManagedInstance.Monitor.DBEngine.BufferCacheHitRatio | Microsoft.Azure.ManagedInstance.DBEngine | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.Azure.ManagedInstance.MonitorType.DBEngine.BufferCacheHitRatio | True | Public | |
| CPU Utilization (\%) | CPU Utilization (\%) for Managed Instance. | Microsoft.Azure.ManagedInstance.Monitor.DBEngine.CPUUtilization | Microsoft.Azure.ManagedInstance.DBEngine | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.Azure.ManagedInstance.MonitorType.DBEngine.CPUUtilization | True | Public | |
| Managed Instance Health Status | This monitor checks the health state of the Managed Instance. | Microsoft.Azure.ManagedInstance.Monitor.DBEngine.DBEngineStatus | Microsoft.Azure.ManagedInstance.DBEngine | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.Azure.ManagedInstance.MonitorType.DBEngine.DBEngineStatus | True | Public | |
| Page Life Expectancy | Page Life Expectancy(s) for Managed Instance | Microsoft.Azure.ManagedInstance.Monitor.DBEngine.PageLifeExpectancy | Microsoft.Azure.ManagedInstance.DBEngine | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.Azure.ManagedInstance.MonitorType.DBEngine.PageLifeExpectancy | True | Public | |
| SQL Re-Compilation | SQL Re-Compilation for Managed Instance. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. | Microsoft.Azure.ManagedInstance.Monitor.DBEngine.SQLRecompilation | Microsoft.Azure.ManagedInstance.DBEngine | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.Azure.ManagedInstance.MonitorType.DBEngine.SQLRecompilation | True | Public | |
| Stolen Server Memory | Stolen Server Memory for Managed Instance. | Microsoft.Azure.ManagedInstance.Monitor.DBEngine.StolenServerMemory | Microsoft.Azure.ManagedInstance.DBEngine | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.Azure.ManagedInstance.MonitorType.DBEngine.StolenServerMemory | True | Public | |
| Thread Count | Thread Count for Managed Instance | Microsoft.Azure.ManagedInstance.Monitor.DBEngine.ThreadCount | Microsoft.Azure.ManagedInstance.DBEngine | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.Azure.ManagedInstance.MonitorType.DBEngine.ThreadCount | 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 Managed Instance Database. | Microsoft.Azure.ManagedInstance.Monitor.DBFilegroupFx.HashIndexAvgChainLength | Microsoft.Azure.ManagedInstance.DBFilegroupFx | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.Azure.ManagedInstance.MonitorType.DBFilegroupFx.HashIndexAvgChainLength | True | Public | |
| Empty Bucket Percent in the Hash Index | This monitor checks Hash Index Empty Buckets Count in the Managed Instance Database. | Microsoft.Azure.ManagedInstance.Monitor.DBFilegroupFx.HashIndexEmptyBucketsCount | Microsoft.Azure.ManagedInstance.DBFilegroupFx | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.Azure.ManagedInstance.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.Azure.ManagedInstance.Monitor.DBFilegroupFx.StaleCFPs | Microsoft.Azure.ManagedInstance.DBFilegroupFx | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.Azure.ManagedInstance.MonitorType.DBFilegroupFx.StaleCFPs | True | Public | |
| XTP Configuration | This monitor checks the status of the Managed Instance Database XTP Configuration. | Microsoft.Azure.ManagedInstance.Monitor.DBFilegroupFx.XTPConfigurationMonitor | Microsoft.Azure.ManagedInstance.DBFilegroupFx | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.Azure.ManagedInstance.MonitorType.DBFilegroupFx.XTPConfiguration | 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.Azure.ManagedInstance.Monitor.UserResourcePool.MemoryConsumption | Microsoft.Azure.ManagedInstance.UserResourcePool | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.Azure.ManagedInstance.MonitorType.UserResourcePool.MemoryConsumption | True | Public | |
Home