| DisplayName | Description | ID | Target | Category | Enabled | Instance Name | Counter Name | Frequency | Event_ID | Event Source | Alert Generate | Alert Severity | Alert Priority | Remotable | Event Log |
| Azure SQL DB: DB Blocked by Firewall Count | This rule collects the count of connections blocked by the firewall in Microsoft Azure SQL Database.
Note that this rule 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.PerformanceRule.DatabaseBlockedByFirewall | Microsoft.SqlServer.Azure.UserDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: DB Failed Connections Count | This rule collects the count of failed connections in Microsoft Azure SQL Database.
Note that this rule 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.PerformanceRule.DatabaseConnectionFailed | Microsoft.SqlServer.Azure.UserDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: DB Successful Connections Count | This rule collects the count of successful connections in Microsoft Azure SQL Database.
Note that this rule 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.PerformanceRule.DatabaseConnectionSuccessful | Microsoft.SqlServer.Azure.UserDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: DB CPU Percentage | This rule collects the CPU resources of Microsoft Azure SQL Database 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.PerformanceRule.DatabaseCpu | Microsoft.SqlServer.Azure.UserDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: DB Data IO Percentage | This rule collects the percentage of average data I/O utilization of service tier limit by Microsoft Azure SQL 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.PerformanceRule.DatabaseDataIO | Microsoft.SqlServer.Azure.UserDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: DB Deadlocks Count | This rule collects the count of deadlocks in Microsoft Azure SQL Database.
Note that this rule 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.PerformanceRule.DatabaseDeadLock | Microsoft.SqlServer.Azure.UserDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: DB DTU Used Count | This rule collects the number of DTUs allocated by Microsoft Azure SQL 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.PerformanceRule.DatabaseDtuAllocated | Microsoft.SqlServer.Azure.UserDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: DB DTU Limit Count | This rule collects the number of DTUs Microsoft Azure SQL Database can allocate before reaching 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.PerformanceRule.DatabaseDtuFree | Microsoft.SqlServer.Azure.UserDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: DB DTU Percentage | This rule collects the DTU resources of Microsoft Azure SQL Database 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.PerformanceRule.DatabaseDtuPercent | Microsoft.SqlServer.Azure.UserDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: DB Free Space (MB) | This rule collects the amount of space left in Microsoft Azure SQL Database in megabytes.
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.PerformanceRule.DatabaseFreeSpaceMb | Microsoft.SqlServer.Azure.UserDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: DB Free Space Percentage | This rule collects the amount of space left in Microsoft Azure SQL Database 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.PerformanceRule.DatabaseFreeSpacePercent | Microsoft.SqlServer.Azure.UserDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: DB Transactions Locks Count | This rule collects transactions locks count for Microsoft Azure SQL Database.
Note that this rule 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.PerformanceRule.DatabaseLocksCount | Microsoft.SqlServer.Azure.UserDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: DB Log IO Percentage | This rule collects the percentage of write resource utilization of the service tier limit by Microsoft Azure SQL 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.PerformanceRule.DatabaseLogWritePercent | Microsoft.SqlServer.Azure.UserDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| [Deprecated] Azure SQL DB: DB External Network Egress (KB) | This rule collects external network egress for Microsoft Azure SQL Database in kilobytes. This rule has been deprecated in Azure SQL Database V12 logical 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.PerformanceRule.DatabaseNetworkExternalEgress | Microsoft.SqlServer.Azure.Database | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
| [Deprecated] Azure SQL DB: DB External Network Ingress (KB) | This rule collects external network ingress for Microsoft Azure SQL Database in kilobytes. This rule has been deprecated in Azure SQL Database V12 logical 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.PerformanceRule.DatabaseNetworkExternalIngress | Microsoft.SqlServer.Azure.Database | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
| [Deprecated] Azure SQL DB: DB Internal Network Egress (KB) | This rule collects internal network egress for Microsoft Azure SQL Database in kilobytes. This rule has been deprecated in Azure SQL Database V12 logical 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.PerformanceRule.DatabaseNetworkInternalEgress | Microsoft.SqlServer.Azure.Database | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
| [Deprecated] Azure SQL DB: DB Internal Network Ingress (KB) | This rule collects internal network ingress for Microsoft Azure SQL Database in kilobytes. This rule has been deprecated in Azure SQL Database V12 logical 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.PerformanceRule.DatabaseNetworkInternalIngress | Microsoft.SqlServer.Azure.Database | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: DB Sessions Count | This rule collects number of current Microsoft Azure SQL Database sessions.
Note that this rule 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.PerformanceRule.DatabaseNumberOfSessions | Microsoft.SqlServer.Azure.UserDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: Total Space Quota (MB) | This rule collects the total available amount of space for Microsoft Azure SQL Database in megabytes.
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.PerformanceRule.DatabaseQuotaSizeMb | Microsoft.SqlServer.Azure.UserDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: DB Sessions Average Memory Consumption (MB) | This rule collects average memory amount used by a single Microsoft Azure SQL Database session in megabytes.
Note that this rule 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.PerformanceRule.DatabaseSessionsAverageMemoryMb | Microsoft.SqlServer.Azure.UserDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: DB Sessions Percentage | This rule collects the percentage of maximum concurrent sessions of the database’s service tier limit by Microsoft Azure SQL 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.PerformanceRule.DatabaseSessionsPercent | Microsoft.SqlServer.Azure.UserDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: DB Sessions Rows Returned | This rule collects number of rows returned by all current Microsoft Azure SQL Database sessions.
Note that this rule 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.PerformanceRule.DatabaseSessionsRowsReturned | Microsoft.SqlServer.Azure.UserDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: DB Sessions Total CPU Time (ms) | This rule collects total CPU time used by all current Microsoft Azure SQL Database sessions.
Note that this rule 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.PerformanceRule.DatabaseSessionsTotalCpu | Microsoft.SqlServer.Azure.UserDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: DB Sessions Total Read/Write Operations | This rule collects total read/write operations performed by requests in all current Microsoft Azure SQL Database sessions.
Note that this rule 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.PerformanceRule.DatabaseSessionsTotalIo | Microsoft.SqlServer.Azure.UserDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: DB Sessions Total Memory Consumption (MB) | This rule collects total memory consumed by all Microsoft Azure SQL Database sessions in megabytes.
Note that this rule 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.PerformanceRule.DatabaseSessionsTotalMemoryMb | Microsoft.SqlServer.Azure.UserDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: DB Transactions Max Log Usage (MB) | This rule collects max transactions log usage for Microsoft Azure SQL Database in megabytes.
Note that this rule 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.PerformanceRule.DatabaseTransactionsMaxLogUsageMb | Microsoft.SqlServer.Azure.UserDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: DB Transactions Max Running Time (minutes) | This rule collects max transactions running time for Microsoft Azure SQL Database in minutes.
Note that this rule 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.PerformanceRule.DatabaseTransactionsMaxRunTimeMinutes | Microsoft.SqlServer.Azure.UserDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: DB Used Space (MB) | This rule collects the amount of space used by the Microsoft Azure SQL Database in megabytes.
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.PerformanceRule.DatabaseUsedSpaceMb | Microsoft.SqlServer.Azure.UserDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: DB Used Space Percentage | This rule collects the amount of space used by Microsoft Azure SQL Database 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.PerformanceRule.DatabaseUsedSpacePercent | Microsoft.SqlServer.Azure.UserDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: DB Workers Percentage | This rule collects percentage of maximum concurrent workers (requests) of the database’s service tier limit by the Microsoft Azure SQL 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.PerformanceRule.DatabaseWorkerPercent | Microsoft.SqlServer.Azure.UserDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: DB In-memory OLTP Storage Percentage | This rule collects the usage of In-memory OLTP Storage by Microsoft Azure SQL Database 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.PerformanceRule.DatabaseXTPStoragePercent | Microsoft.SqlServer.Azure.UserDatabase | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: Elastic Pool Data IO Percentage | This rule collects the data IO utilization of Microsoft Azure SQL Elastic Database Pool 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.PerformanceRule.ElasticPool.AvgDataIoUtil | Microsoft.SqlServer.Azure.ElasticPool | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: Elastic Pool Log IO Percentage | This rule collects the log write utilization of Microsoft Azure SQL Elastic Database Pool 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.PerformanceRule.ElasticPool.AvgLogWriterUtil | Microsoft.SqlServer.Azure.ElasticPool | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: Elastic Pool Sessions Percentage | This rule collects the sessions’ count of Microsoft Azure SQL Elastic Database Pool in percentage terms per 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.PerformanceRule.ElasticPool.MaxSessionUtil | Microsoft.SqlServer.Azure.ElasticPool | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: Elastic Pool Storage Percentage | This rule collects the storage utilization of Microsoft Azure SQL Elastic Database Pool 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.PerformanceRule.ElasticPool.MaxStorageUtil | Microsoft.SqlServer.Azure.ElasticPool | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: Elastic Pool Workers Percentage | This rule collects the workers utilization of Microsoft Azure SQL Elastic Database Pool 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.PerformanceRule.ElasticPool.MaxWorkersUtil | Microsoft.SqlServer.Azure.ElasticPool | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: Elastic Pool Databases Count | This rule collects the number of Microsoft Azure SQL 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.PerformanceRule.ElasticPool.NumberOfDatabases | Microsoft.SqlServer.Azure.ElasticPool | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: Elastic Pool CPU Percentage | This rule collects the CPU resources of Microsoft Azure SQL Elastic Database Pool 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.PerformanceRule.ElasticPoolCpu | Microsoft.SqlServer.Azure.ElasticPool | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: Elastic Pool eDTU Used | This rule collects the eDTU resources of Microsoft Azure SQL Elastic Database Pool in unit 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.PerformanceRule.ElasticPoolEDtuCount | Microsoft.SqlServer.Azure.ElasticPool | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: Elastic Pool eDTU Percentage | This rule collects the eDTU resources of Microsoft Azure SQL Elastic Database Pool 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.PerformanceRule.ElasticPoolEDtuPercent | Microsoft.SqlServer.Azure.ElasticPool | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: Server Databases Count | This rule collects the number of Microsoft Azure SQL Database hosted in Microsoft Azure SQL Database Cloud Service.
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.PerformanceRule.NumberOfDatabases | Microsoft.SqlServer.Azure.Server | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: Server DTU Used Count | This rule collects the number of DTUs allocated by Microsoft Azure SQL Database Cloud Service.
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.PerformanceRule.Server.DtuAllocated | Microsoft.SqlServer.Azure.Server | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: Server DTU Limit Count | This rule collects the number of DTUs Microsoft Azure SQL Database Cloud Service can allocate before reaching 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.PerformanceRule.Server.DtuFree | Microsoft.SqlServer.Azure.Server | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Azure SQL DB: Server DTU Percentage | This rule collects DTUs allocated by Microsoft Azure SQL Database Cloud Service 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.PerformanceRule.Server.DtuPercent | Microsoft.SqlServer.Azure.Server | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Microsoft Azure SQL Database .Net Framework Rule | This rule provides Microsoft Azure SQL Database Management Pack workflows .Net Framework version check.
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.Rule.CheckDotNetVersion | Microsoft.SqlServer.Azure.EventLogCollectionTarget | Alert | True | | | 0 | 0 | | True | Error | High | True | |
| Microsoft Azure SQL Database Management Pack Self-Monitoring | This rule provides Microsoft Azure SQL Database Management Pack workflows self-monitoring for critical issues. | Microsoft.SqlServer.Azure.Rule.SelfMonitoringCritical | Microsoft.SqlServer.Azure.EventLogCollectionTarget | Alert | True | | | 0 | 0 | | True | Error | High | True | Operations Manager |
| Microsoft Azure SQL Database Management Pack Self-Monitoring (Non-Critical) | This rule provides Microsoft Azure SQL Database Management Pack workflows self-monitoring for non-critical issues. | Microsoft.SqlServer.Azure.Rule.SelfMonitoringWarning | Microsoft.SqlServer.Azure.EventLogCollectionTarget | Alert | True | | | 0 | 0 | | True | Warning | Normal | True | Operations Manager |