| 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 |
| Monitors Count of connections blocked by the Firewall | Monitors the count of connections blocked by the Firewall.
Note that this monitor works through T-SQL only.
In order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseBlockedByFirewall | Microsoft.SqlServer.Azure.UserDatabase | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.DatabaseEventLog | True | Public | |
| Database Connection Availability | This monitor checks the connection availability to the Database.
Note that in order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseConnection | Microsoft.SqlServer.Azure.UserDatabase | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.Connection | True | Public | |
| Monitors Count of Failed Connection | Monitors the count of failed connections.
Note that this monitor works through T-SQL only.
In order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseConnectionFailed | Microsoft.SqlServer.Azure.UserDatabase | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.DatabaseEventLog | True | Public | |
| CPU Percentage | Monitors the CPU resources consumed by all database sessions.
Note that in order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseCpu | Microsoft.SqlServer.Azure.UserDatabase | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.DatabaseResourceStats | True | Public | |
| Data IO Percentage | Monitors the data I/O utilization in percentage terms by all database sessions.
Note that in order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseDataIO | Microsoft.SqlServer.Azure.UserDatabase | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.DatabaseResourceStats | True | Public | |
| DTU Percentage | Monitors the DTU Utilization consumed by the database.
Note that in order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseDtuPercent | Microsoft.SqlServer.Azure.UserDatabase | 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.
Note that in order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseFreeSpace | Microsoft.SqlServer.Azure.UserDatabase | 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.
Note that this monitor works through T-SQL only.
In order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseLocksCount | Microsoft.SqlServer.Azure.UserDatabase | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.DatabaseLocksCount | True | Public | |
| Log IO Percentage | Monitors the write resource utilization in percentage terms by all database sessions.
Note that in order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseLogWrite | Microsoft.SqlServer.Azure.UserDatabase | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.DatabaseResourceStats | True | Public | |
| Sessions Count | Monitors the number of database sessions.
Note that this monitor works through T-SQL only.
In order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseNumberOfSessions | Microsoft.SqlServer.Azure.UserDatabase | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.DatabaseSessions | True | Public | |
| Geo-Replication Link State | Monitors Synchronization State of Geo-Replication for secondary databases.
Note that in order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseReplicationLinkState | Microsoft.SqlServer.Azure.UserDatabase | System.Health.AvailabilityState | AvailabilityHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.DatabaseReplicationLinkState | True | Public | |
| Sessions Percentage | Monitors the percentage of maximum concurrent sessions of the database’s service tier limit.
Note that in order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseSessions | Microsoft.SqlServer.Azure.UserDatabase | 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.
Note that this monitor works through T-SQL only.
In order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseSessionsAverageMemory | Microsoft.SqlServer.Azure.UserDatabase | 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.
Note that this monitor works through T-SQL only.
In order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseSessionsRowsReturned | Microsoft.SqlServer.Azure.UserDatabase | 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.
Note that this monitor works through T-SQL only.
In order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseSessionsTotalCpu | Microsoft.SqlServer.Azure.UserDatabase | 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.
Note that this monitor works through T-SQL only.
In order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseSessionsTotalIo | Microsoft.SqlServer.Azure.UserDatabase | 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.
Note that this monitor works through T-SQL only.
In order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseSessionsTotalMemory | Microsoft.SqlServer.Azure.UserDatabase | 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.
Note that in order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseState | Microsoft.SqlServer.Azure.UserDatabase | 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.
Note that this monitor works through T-SQL only.
In order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseTransactionsMaxLogUsage | Microsoft.SqlServer.Azure.UserDatabase | 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.
Note that this monitor works through T-SQL only.
In order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseTransactionsMaxRunTime | Microsoft.SqlServer.Azure.UserDatabase | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.DatabaseTransactionsMaxRunTime | True | Public | |
| Workers Percentage | Monitors the total amount of maximum concurrent workers (requests) consumed by all database sessions.
Note that in order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseWorker | Microsoft.SqlServer.Azure.UserDatabase | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.DatabaseResourceStats | True | Public | |
| In-memory OLTP Storage Percentage | Monitors the total amount of XTP Storage (In-memory OLTP Storage) in percentage terms.
Note that in order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | Microsoft.SqlServer.Azure.UnitMonitor.DatabaseXTPStoragePercent | Microsoft.SqlServer.Azure.UserDatabase | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.DatabaseResourceStats | True | Public | |
| Percent of Allocated DTUs | Monitors the number of database transaction units (DTUs) allocated by the server in relation to the limit per server.
Note that in order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | Microsoft.SqlServer.Azure.UnitMonitor.DtuAllocation | Microsoft.SqlServer.Azure.Server | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.ServerDtuAllocation | True | Public | |
| Maximum Number of Databases | Monitors the number of extant databases in relation to the limit per pool.
Note that in order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | Microsoft.SqlServer.Azure.UnitMonitor.ElasticPool.NumberOfDatabases | Microsoft.SqlServer.Azure.ElasticPool | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.ElasticPool.NumberOfDatabases | True | Public | |
| CPU Utilization (\%) | Monitors the total CPU Utilization consumed by all databases in Elastic Pool.
Note that in order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | Microsoft.SqlServer.Azure.UnitMonitor.ElasticPoolCpu | Microsoft.SqlServer.Azure.ElasticPool | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.ElasticPoolResourceStats | True | Public | |
| Data IO Percentage | Monitors the Data IO Utilization consumed by all databases in Elastic Pool.
Note that in order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | Microsoft.SqlServer.Azure.UnitMonitor.ElasticPoolDataIoUtil | Microsoft.SqlServer.Azure.ElasticPool | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.ElasticPoolResourceStats | True | Public | |
| eDTU Percentage | Monitors the eDTU Utilization consumed by all databases in Elastic Pool.
Note that in order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | Microsoft.SqlServer.Azure.UnitMonitor.ElasticPoolEDtuPercent | Microsoft.SqlServer.Azure.ElasticPool | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.ElasticPoolResourceStats | True | Public | |
| Log IO Percentage | Monitors the Log Write Utilization consumed by all databases in Elastic Pool.
Note that in order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | Microsoft.SqlServer.Azure.UnitMonitor.ElasticPoolLogWriterUtil | Microsoft.SqlServer.Azure.ElasticPool | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.ElasticPoolResourceStats | True | Public | |
| Sessions Percentage | Monitors the Sessions Utilization consumed by all databases in Elastic Pool.
Note that in order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | Microsoft.SqlServer.Azure.UnitMonitor.ElasticPoolMaxSessionUtil | Microsoft.SqlServer.Azure.ElasticPool | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.ElasticPoolResourceStats | True | Public | |
| Storage Percentage | Monitors the Storage Utilization consumed by all databases in Elastic Pool.
Note that in order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | Microsoft.SqlServer.Azure.UnitMonitor.ElasticPoolStorageUtil | Microsoft.SqlServer.Azure.ElasticPool | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.ElasticPoolResourceStats | True | Public | |
| Workers Percentage | Monitors the Storage Utilization consumed by all databases in Elastic Pool.
Note that in order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | Microsoft.SqlServer.Azure.UnitMonitor.ElasticPoolWorkerUtil | Microsoft.SqlServer.Azure.ElasticPool | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.ElasticPoolResourceStats | True | Public | |
| Maximum Number of Databases | Monitors the number of extant databases in relation to the limit per server.
Note that in order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | 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 Connection Availability | This monitor checks the availability of connection to the server.
Note that in order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | Microsoft.SqlServer.Azure.UnitMonitor.ServerConnection | Microsoft.SqlServer.Azure.Server | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SqlServer.Azure.UnitMonitorType.Connection | True | Public | |
| Server Health State | This monitor checks the health state of the “master” database.
Note that in order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value. | 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 | |