| | DisplayName | Description | ID | Target | Category | Enabled | Instance Name | Counter Name | Frequency | Event_ID | Event Source | Alert Generate | Alert Severity | Alert Priority | Remotable | Event Log |
|---|
 | Collect Microsoft Azure SQL Database Count Connection Blocked By the firewall | This rule collects the count of connections blocked by the firewall in Microsoft Azure SQL Database. | Microsoft.SqlServer.Azure.PerformanceRule.DatabaseBlockedByFirewall | Microsoft.SqlServer.Azure.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Collect Microsoft Azure SQL Database Count Failed Connection | This rule collects the count of failed connections in Microsoft Azure SQL Database. | Microsoft.SqlServer.Azure.PerformanceRule.DatabaseConnectionFailed | Microsoft.SqlServer.Azure.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Collect Microsoft Azure SQL Database Count Successful Connection | This rule collects the count of successful connections in Microsoft Azure SQL Database. | Microsoft.SqlServer.Azure.PerformanceRule.DatabaseConnectionSuccessful | Microsoft.SqlServer.Azure.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Collect Microsoft Azure SQL Database CPU Usage (\%) | This rule collects the CPU resources of Microsoft Azure SQL Database in percentage terms. | Microsoft.SqlServer.Azure.PerformanceRule.DatabaseCpu | Microsoft.SqlServer.Azure.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Collect Microsoft Azure SQL Database Data I/O (\%) | This rule collects the percentage of average data I/O utilization of service tier limit by Microsoft Azure SQL Database. | Microsoft.SqlServer.Azure.PerformanceRule.DatabaseDataIO | Microsoft.SqlServer.Azure.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Collect Microsoft Azure SQL Database Count of Deadlock | This rule collects the count of connections blocked by the firewall in Microsoft Azure SQL Database. | Microsoft.SqlServer.Azure.PerformanceRule.DatabaseDeadLock | Microsoft.SqlServer.Azure.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Collect Microsoft Azure SQL Database Free Space (MB) | This rule collects the amount of space left in Microsoft Azure SQL Database in megabytes. | Microsoft.SqlServer.Azure.PerformanceRule.DatabaseFreeSpaceMb | Microsoft.SqlServer.Azure.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Collect Microsoft Azure SQL Database Free Space (\%) | This rule collects the amount of space left in Microsoft Azure SQL Database in percentage terms. | Microsoft.SqlServer.Azure.PerformanceRule.DatabaseFreeSpacePercent | Microsoft.SqlServer.Azure.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Collect Microsoft Azure SQL Database Transactions Locks Count | This rule collects transactions locks count for Microsoft Azure SQL Database. | Microsoft.SqlServer.Azure.PerformanceRule.DatabaseLocksCount | Microsoft.SqlServer.Azure.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Collect Microsoft Azure SQL Database Log Write (\%) | This rule collects the percentage of write resource utilization of the service tier limit by Microsoft Azure SQL Database. | Microsoft.SqlServer.Azure.PerformanceRule.DatabaseLogWritePercent | Microsoft.SqlServer.Azure.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| [Deprecated] Collect Microsoft Azure SQL Database 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. | Microsoft.SqlServer.Azure.PerformanceRule.DatabaseNetworkExternalEgress | Microsoft.SqlServer.Azure.Database | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
| [Deprecated] Collect Microsoft Azure SQL Database 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. | Microsoft.SqlServer.Azure.PerformanceRule.DatabaseNetworkExternalIngress | Microsoft.SqlServer.Azure.Database | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
| [Deprecated] Collect Microsoft Azure SQL Database 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. | Microsoft.SqlServer.Azure.PerformanceRule.DatabaseNetworkInternalEgress | Microsoft.SqlServer.Azure.Database | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
| [Deprecated] Collect Microsoft Azure SQL Database 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. | Microsoft.SqlServer.Azure.PerformanceRule.DatabaseNetworkInternalIngress | Microsoft.SqlServer.Azure.Database | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
| Collect Microsoft Azure SQL Database Number Of Sessions | This rule collects number of current Microsoft Azure SQL Database sessions. | Microsoft.SqlServer.Azure.PerformanceRule.DatabaseNumberOfSessions | Microsoft.SqlServer.Azure.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Collect Microsoft Azure SQL Database Total Space Quota (MB) | This rule collects the total available amount of space for Microsoft Azure SQL Database in megabytes. | Microsoft.SqlServer.Azure.PerformanceRule.DatabaseQuotaSizeMb | Microsoft.SqlServer.Azure.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Collect Microsoft Azure SQL Database Sessions Average Memory Consumption (MB) | This rule collects average memory amount used by all sessions of a single Microsoft Azure SQL Database in megabytes. | Microsoft.SqlServer.Azure.PerformanceRule.DatabaseSessionsAverageMemoryMb | Microsoft.SqlServer.Azure.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Collect Microsoft Azure SQL Database Sessions (\%) | This rule collects the percentage of maximum concurrent sessions of the database’s service tier limit by Microsoft Azure SQL Database. | Microsoft.SqlServer.Azure.PerformanceRule.DatabaseSessionsPercent | Microsoft.SqlServer.Azure.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Collect Microsoft Azure SQL Database Sessions Rows Returned | This rule collects number of rows returned by all current Microsoft Azure SQL Database sessions. | Microsoft.SqlServer.Azure.PerformanceRule.DatabaseSessionsRowsReturned | Microsoft.SqlServer.Azure.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Collect Microsoft Azure SQL Database Sessions Total CPU Time (ms) | This rule collects total CPU time used by all current Microsoft Azure SQL Database sessions. | Microsoft.SqlServer.Azure.PerformanceRule.DatabaseSessionsTotalCpu | Microsoft.SqlServer.Azure.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Collect Microsoft Azure SQL Database Sessions Total Read/Write Operations | This rule collects total read/write operations performed by requests in all current Microsoft Azure SQL Database sessions. | Microsoft.SqlServer.Azure.PerformanceRule.DatabaseSessionsTotalIo | Microsoft.SqlServer.Azure.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Collect Microsoft Azure SQL Database Sessions Total Memory Consumption (MB) | This rule collects total memory consumed by all Microsoft Azure SQL Database sessions in megabytes. | Microsoft.SqlServer.Azure.PerformanceRule.DatabaseSessionsTotalMemoryMb | Microsoft.SqlServer.Azure.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Collect Microsoft Azure SQL Database Count Throttling Long Transaction | This rule collects the count of throttling long transaction in Microsoft Azure SQL Database. | Microsoft.SqlServer.Azure.PerformanceRule.DatabaseThrottlingLongTransaction | Microsoft.SqlServer.Azure.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Collect Microsoft Azure SQL Database Transactions Max Log Usage (MB) | This rule collects max transactions log usage for Microsoft Azure SQL Database in megabytes. | Microsoft.SqlServer.Azure.PerformanceRule.DatabaseTransactionsMaxLogUsageMb | Microsoft.SqlServer.Azure.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Collect Microsoft Azure SQL Database Transactions Max Running Time (minutes) | This rule collects max transactions running time for Microsoft Azure SQL Database in minutes. | Microsoft.SqlServer.Azure.PerformanceRule.DatabaseTransactionsMaxRunTimeMinutes | Microsoft.SqlServer.Azure.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Collect Microsoft Azure SQL Database Used Space (MB) | This rule collects the amount of space used by the Microsoft Azure SQL Database in megabytes. | Microsoft.SqlServer.Azure.PerformanceRule.DatabaseUsedSpaceMb | Microsoft.SqlServer.Azure.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Collect Microsoft Azure SQL Database Used Space (\%) | This rule collects the amount of space used by Microsoft Azure SQL Database in percentage terms. | Microsoft.SqlServer.Azure.PerformanceRule.DatabaseUsedSpacePercent | Microsoft.SqlServer.Azure.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Collect Microsoft Azure SQL Database Workers (\%) | This rule collects percentage of maximum concurrent workers (requests) of the database’s service tier limit by the Microsoft Azure SQL Database. | Microsoft.SqlServer.Azure.PerformanceRule.DatabaseWorkerPercent | Microsoft.SqlServer.Azure.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Collect Microsoft Azure SQL Database XTP Storage (Memory-Optimized Data Storage) in percentage terms | This rule collects the usage of XTP Storage (Memory-Optimized Data Storage) by Microsoft Azure SQL Database in percentage terms. | Microsoft.SqlServer.Azure.PerformanceRule.DatabaseXTPStoragePercent | Microsoft.SqlServer.Azure.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Collect Number Of Database For Microsoft Azure SQL Database Cloud Service | This rule collects the number of Microsoft Azure SQL Database hosted in Microsoft Azure SQL Database Cloud Service. | Microsoft.SqlServer.Azure.PerformanceRule.NumberOfDatabases | Microsoft.SqlServer.Azure.Server | PerformanceCollection | True | | | 0 | 0 | | False | | | 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.WatcherNode | 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.WatcherNode | Alert | True | | | 0 | 0 | | True | Warning | Normal | True | Operations Manager |
Home