All Unit Monitors in Microsoft.SqlServer.Azure Management Pack

 DisplayNameDescriptionIDTargetParent MonitorCategoryEnabledInstance NameCounter NameFrequencyAlert GenerateAlert SeverityAlert PriorityAlert Auto ResolveMonitor TypeRemotableAccessibilityRunAs
Microsoft.SqlServer.Azure.UnitMonitor.DatabaseBlockedByFirewallMonitors Count of connections blocked by the FirewallMonitors 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.DatabaseBlockedByFirewallMicrosoft.SqlServer.Azure.UserDatabaseSystem.Health.PerformanceStatePerformanceHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.DatabaseEventLogTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.DatabaseConnectionDatabase Connection AvailabilityThis 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.DatabaseConnectionMicrosoft.SqlServer.Azure.UserDatabaseSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.ConnectionTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.DatabaseConnectionFailedMonitors Count of Failed ConnectionMonitors 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.DatabaseConnectionFailedMicrosoft.SqlServer.Azure.UserDatabaseSystem.Health.PerformanceStatePerformanceHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.DatabaseEventLogTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.DatabaseCpuCPU PercentageMonitors 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.DatabaseCpuMicrosoft.SqlServer.Azure.UserDatabaseSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.DatabaseResourceStatsTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.DatabaseDataIOData IO PercentageMonitors 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.DatabaseDataIOMicrosoft.SqlServer.Azure.UserDatabaseSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.DatabaseResourceStatsTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.DatabaseDtuPercentDTU PercentageMonitors 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.DatabaseDtuPercentMicrosoft.SqlServer.Azure.UserDatabaseSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.DatabaseResourceStatsTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.DatabaseFreeSpaceDatabase Free SpaceThis 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.DatabaseFreeSpaceMicrosoft.SqlServer.Azure.UserDatabaseSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.DatabaseFreeSpaceTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.DatabaseLocksCountTransaction Locks CountMonitors 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.DatabaseLocksCountMicrosoft.SqlServer.Azure.UserDatabaseSystem.Health.PerformanceStatePerformanceHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.DatabaseLocksCountTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.DatabaseLogWriteLog IO PercentageMonitors 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.DatabaseLogWriteMicrosoft.SqlServer.Azure.UserDatabaseSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.DatabaseResourceStatsTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.DatabaseNumberOfSessionsSessions CountMonitors 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.DatabaseNumberOfSessionsMicrosoft.SqlServer.Azure.UserDatabaseSystem.Health.PerformanceStatePerformanceHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.DatabaseSessionsTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.DatabaseReplicationLinkStateGeo-Replication Link StateMonitors 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.DatabaseReplicationLinkStateMicrosoft.SqlServer.Azure.UserDatabaseSystem.Health.AvailabilityStateAvailabilityHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.DatabaseReplicationLinkStateTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.DatabaseSessionsSessions PercentageMonitors 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.DatabaseSessionsMicrosoft.SqlServer.Azure.UserDatabaseSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.DatabaseResourceStatsTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.DatabaseSessionsAverageMemorySessions Average MemoryMonitors 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.DatabaseSessionsAverageMemoryMicrosoft.SqlServer.Azure.UserDatabaseSystem.Health.PerformanceStatePerformanceHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.DatabaseSessionsTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.DatabaseSessionsRowsReturnedSessions Rows ReturnedMonitors 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.DatabaseSessionsRowsReturnedMicrosoft.SqlServer.Azure.UserDatabaseSystem.Health.PerformanceStatePerformanceHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.DatabaseSessionsTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.DatabaseSessionsTotalCpuSessions Total CPU TimeMonitors 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.DatabaseSessionsTotalCpuMicrosoft.SqlServer.Azure.UserDatabaseSystem.Health.PerformanceStatePerformanceHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.DatabaseSessionsTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.DatabaseSessionsTotalIoSessions Total I/OMonitors 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.DatabaseSessionsTotalIoMicrosoft.SqlServer.Azure.UserDatabaseSystem.Health.PerformanceStatePerformanceHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.DatabaseSessionsTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.DatabaseSessionsTotalMemorySessions Total MemoryMonitors 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.DatabaseSessionsTotalMemoryMicrosoft.SqlServer.Azure.UserDatabaseSystem.Health.PerformanceStatePerformanceHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.DatabaseSessionsTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.DatabaseStateDatabase Health StateThis 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.DatabaseStateMicrosoft.SqlServer.Azure.UserDatabaseSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.DatabaseStateTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.DatabaseTransactionsMaxLogUsageTransaction Log Space UsedMonitors 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.DatabaseTransactionsMaxLogUsageMicrosoft.SqlServer.Azure.UserDatabaseSystem.Health.PerformanceStatePerformanceHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.DatabaseTransactionsMaxLogUsageTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.DatabaseTransactionsMaxRunTimeTransaction Execution TimeMonitors 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.DatabaseTransactionsMaxRunTimeMicrosoft.SqlServer.Azure.UserDatabaseSystem.Health.PerformanceStatePerformanceHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.DatabaseTransactionsMaxRunTimeTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.DatabaseWorkerWorkers PercentageMonitors 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.DatabaseWorkerMicrosoft.SqlServer.Azure.UserDatabaseSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.DatabaseResourceStatsTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.DatabaseXTPStoragePercentIn-memory OLTP Storage PercentageMonitors 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.DatabaseXTPStoragePercentMicrosoft.SqlServer.Azure.UserDatabaseSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.DatabaseResourceStatsTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.DtuAllocationPercent of Allocated DTUsMonitors 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.DtuAllocationMicrosoft.SqlServer.Azure.ServerSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.ServerDtuAllocationTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.ElasticPool.NumberOfDatabasesMaximum Number of DatabasesMonitors 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.NumberOfDatabasesMicrosoft.SqlServer.Azure.ElasticPoolSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.ElasticPool.NumberOfDatabasesTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.ElasticPoolCpuCPU 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.ElasticPoolCpuMicrosoft.SqlServer.Azure.ElasticPoolSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.ElasticPoolResourceStatsTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.ElasticPoolDataIoUtilData IO PercentageMonitors 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.ElasticPoolDataIoUtilMicrosoft.SqlServer.Azure.ElasticPoolSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.ElasticPoolResourceStatsTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.ElasticPoolEDtuPercenteDTU PercentageMonitors 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.ElasticPoolEDtuPercentMicrosoft.SqlServer.Azure.ElasticPoolSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.ElasticPoolResourceStatsTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.ElasticPoolLogWriterUtilLog IO PercentageMonitors 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.ElasticPoolLogWriterUtilMicrosoft.SqlServer.Azure.ElasticPoolSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.ElasticPoolResourceStatsTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.ElasticPoolMaxSessionUtilSessions PercentageMonitors 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.ElasticPoolMaxSessionUtilMicrosoft.SqlServer.Azure.ElasticPoolSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.ElasticPoolResourceStatsTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.ElasticPoolStorageUtilStorage PercentageMonitors 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.ElasticPoolStorageUtilMicrosoft.SqlServer.Azure.ElasticPoolSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.ElasticPoolResourceStatsTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.ElasticPoolWorkerUtilWorkers PercentageMonitors 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.ElasticPoolWorkerUtilMicrosoft.SqlServer.Azure.ElasticPoolSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.ElasticPoolResourceStatsTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.NumberOfDatabasesMaximum Number of DatabasesMonitors 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.NumberOfDatabasesMicrosoft.SqlServer.Azure.ServerSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.NumberOfDatabasesTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.ServerConnectionServer Connection AvailabilityThis 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.ServerConnectionMicrosoft.SqlServer.Azure.ServerSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.ConnectionTruePublic
Microsoft.SqlServer.Azure.UnitMonitor.ServerStateMonitorServer Health StateThis 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.ServerStateMonitorMicrosoft.SqlServer.Azure.ServerSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SqlServer.Azure.UnitMonitorType.ServerStateTruePublic