| 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 |
| Blocked by Firewall Connections Count | Monitors the count of connections blocked by the firewall. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseBlockedByFirewall | Microsoft.SqlServer.Azure.Database | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.DatabaseEventLog | True | Public | |
| Failed Connections Count | Monitors the count of failed connections. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseConnectionFailed | Microsoft.SqlServer.Azure.Database | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.DatabaseEventLog | True | Public | |
| CPU Usage (\%) | Monitors the CPU resources consumed by all database sessions. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseCpu | Microsoft.SqlServer.Azure.Database | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.DatabaseResourceStats | True | Public | |
| Data I/O (\%) | Monitors the data I/O utilization in percentage terms by all database sessions. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseDataIO | Microsoft.SqlServer.Azure.Database | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.DatabaseResourceStats | True | Public | |
| Database Free Space | This monitor checks the free space of the Database. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseFreeSpace | Microsoft.SqlServer.Azure.Database | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.DatabaseFreeSpace | True | Public | |
| Transaction Locks Count | Monitors the highest number of locks held by any transaction for a database. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseLocksCount | Microsoft.SqlServer.Azure.Database | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.DatabaseLocksCount | True | Public | |
| Log Write (\%) | Monitors the write resource utilization in percentage terms by all database sessions. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseLogWrite | Microsoft.SqlServer.Azure.Database | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.DatabaseResourceStats | True | Public | |
| Number of Sessions | Monitors the number of database sessions. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseNumberOfSessions | Microsoft.SqlServer.Azure.Database | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.DatabaseSessions | True | Public | |
| Sessions (\%) | Monitors the percentage of maximum concurrent sessions of the database’s service tier limit. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseSessions | Microsoft.SqlServer.Azure.Database | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.DatabaseResourceStats | True | Public | |
| Sessions Average Memory | Monitors the average amount of memory consumption for all sessions of a database. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseSessionsAverageMemory | Microsoft.SqlServer.Azure.Database | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.DatabaseSessions | True | Public | |
| Sessions Rows Returned | Monitors the rows returned for all sessions of a database. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseSessionsRowsReturned | Microsoft.SqlServer.Azure.Database | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.DatabaseSessions | True | Public | |
| Sessions Total CPU Time | Monitors the total amount of CPU time consumed by all database sessions. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseSessionsTotalCpu | Microsoft.SqlServer.Azure.Database | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.DatabaseSessions | True | Public | |
| Sessions Total I/O | Monitors the total amount of disk reads and writes for all database sessions. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseSessionsTotalIo | Microsoft.SqlServer.Azure.Database | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.DatabaseSessions | True | Public | |
| Sessions Total Memory | Monitors the total amount of memory consumed by all database sessions. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseSessionsTotalMemory | Microsoft.SqlServer.Azure.Database | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.DatabaseSessions | True | Public | |
| Database Health State | This monitor checks the health state of the Database. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseState | Microsoft.SqlServer.Azure.Database | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.DatabaseState | True | Public | |
| Transaction Log Space Used | Monitors the largest amount of log space consumed by any transaction for a database. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseTransactionsMaxLogUsage | Microsoft.SqlServer.Azure.Database | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.DatabaseTransactionsMaxLogUsage | True | Public | |
| Transaction Execution Time | Monitors the longest elapsed (wall clock) time of all transactions for a database. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseTransactionsMaxRunTime | Microsoft.SqlServer.Azure.Database | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.DatabaseTransactionsMaxRunTime | True | Public | |
| Workers Usage (\%) | Monitors the maximum concurrent workers (requests) by all database sessions. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseWorker | Microsoft.SqlServer.Azure.Database | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.DatabaseResourceStats | True | Public | |
| XTP Storage (Memory-Optimized Data Storage, \%) | Monitors the XTP Storage (Memory-Optimized Data Storage) in percentage terms. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseXTPStoragePercent | Microsoft.SqlServer.Azure.Database | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.DatabaseResourceStats | True | Public | |
| Maximum Number of Databases | Monitors the number of extant databases in relation to the limit per server. | Microsoft.SqlServer.Azure.UnitMonitor.NumberOfDatabases | Microsoft.SqlServer.Azure.Server | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.NumberOfDatabases | True | Public | |
| Server Health State | This monitor checks the health state of the “master” database. | Microsoft.SqlServer.Azure.UnitMonitor.ServerStateMonitor | Microsoft.SqlServer.Azure.Server | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.ServerState | True | Public | |