services/Sql/servers/alerts.yaml

- name: databases - connection_failed
  description: Failed Connections
  type: Metric
  verified: false
  visible: true
  tags:
  - auto-generated
  - agc-30217
  properties:
    metricName: connection_failed
    metricNamespace: Microsoft.Sql/servers/databases
    severity: 3
    windowSize: PT5M
    evaluationFrequency: PT1M
    timeAggregation: Total
    operator: GreaterThan
    criterionType: StaticThresholdCriterion
    threshold: 5.0
    enabled: true
  references:
  - name: Monitor Azure SQL Database with metrics and alerts
    url: https://learn.microsoft.com/azure/azure-sql/database/monitoring-metrics-alerts?view=azuresql-db
  - name: Monitor Azure SQL Database data reference
    url: https://learn.microsoft.com/azure/azure-sql/database/monitoring-sql-database-azure-monitor-reference?view=azuresql
  guid: 7157dc17-9d5a-4835-a122-1d0d904d61ff
- name: databases - deadlock
  description: Deadlocks. Not applicable to data warehouses.
  type: Metric
  verified: false
  visible: true
  tags:
  - auto-generated
  - agc-25557
  properties:
    metricName: deadlock
    metricNamespace: Microsoft.Sql/servers/databases
    severity: 3
    windowSize: PT5M
    evaluationFrequency: PT1M
    timeAggregation: Total
    operator: GreaterThan
    criterionType: StaticThresholdCriterion
    threshold: 1.0
    enabled: true
  references:
  - name: Monitor Azure SQL Database with metrics and alerts
    url: https://learn.microsoft.com/azure/azure-sql/database/monitoring-metrics-alerts?view=azuresql-db
  - name: Monitor Azure SQL Database data reference
    url: https://learn.microsoft.com/azure/azure-sql/database/monitoring-sql-database-azure-monitor-reference?view=azuresql
  guid: ce44fc81-3610-4165-a107-9dd4b8ab3972
- name: databases - blocked_by_firewall
  description: Blocked by Firewall
  type: Metric
  verified: false
  visible: true
  tags:
  - auto-generated
  - agc-13737
  properties:
    metricName: blocked_by_firewall
    metricNamespace: Microsoft.Sql/servers/databases
    severity: 2
    windowSize: PT5M
    evaluationFrequency: PT5M
    timeAggregation: Total
    operator: GreaterThan
    criterionType: StaticThresholdCriterion
    threshold: 5.0
    enabled: true
  references:
  - name: Monitor Azure SQL Database with metrics and alerts
    url: https://learn.microsoft.com/azure/azure-sql/database/monitoring-metrics-alerts?view=azuresql-db
  - name: Monitor Azure SQL Database data reference
    url: https://learn.microsoft.com/azure/azure-sql/database/monitoring-sql-database-azure-monitor-reference?view=azuresql
  guid: 2cda2f3a-8657-431a-a50f-56835aea9a81
- name: databases - storage
  description: Data space used. Not applicable to data warehouses.
  type: Metric
  verified: false
  visible: true
  tags:
  - auto-generated
  - agc-5689
  properties:
    metricName: storage
    metricNamespace: Microsoft.Sql/servers/databases
    severity: 3
    windowSize: PT5M
    evaluationFrequency: PT5M
    timeAggregation: Maximum
    operator: GreaterThan
    criterionType: StaticThresholdCriterion
    threshold: 934584883610.0
    enabled: true
  references:
  - name: Monitor Azure SQL Database with metrics and alerts
    url: https://learn.microsoft.com/azure/azure-sql/database/monitoring-metrics-alerts?view=azuresql-db
  - name: Monitor Azure SQL Database data reference
    url: https://learn.microsoft.com/azure/azure-sql/database/monitoring-sql-database-azure-monitor-reference?view=azuresql
  guid: 86922a27-41bb-4834-bc54-0b602b275597
- name: databases - connection_successful
  description: Successful Connections
  type: Metric
  verified: false
  visible: true
  tags:
  - auto-generated
  - agc-3978
  properties:
    metricName: connection_successful
    metricNamespace: Microsoft.Sql/servers/databases
    severity: 4
    windowSize: PT5M
    evaluationFrequency: PT5M
    timeAggregation: Total
    operator: LessThan
    criterionType: DynamicThresholdCriterion
    failingPeriods:
      numberOfEvaluationPeriods: 5
      minFailingPeriodsToAlert: 5
    alertSensitivity: Low
    enabled: true
  references:
  - name: Monitor Azure SQL Database with metrics and alerts
    url: https://learn.microsoft.com/azure/azure-sql/database/monitoring-metrics-alerts?view=azuresql-db
  - name: Monitor Azure SQL Database data reference
    url: https://learn.microsoft.com/azure/azure-sql/database/monitoring-sql-database-azure-monitor-reference?view=azuresql
  guid: 460b6b29-a602-4409-b748-6b47b232a984
- name: databases - connection_failed_user_error
  description: 'Failed Connections : User Errors'
  type: Metric
  verified: false
  visible: true
  tags:
  - auto-generated
  - agc-2020
  properties:
    metricName: connection_failed_user_error
    metricNamespace: Microsoft.Sql/servers/databases
    severity: 3
    windowSize: PT5M
    evaluationFrequency: PT1M
    timeAggregation: Total
    operator: GreaterThan
    criterionType: StaticThresholdCriterion
    threshold: 1.0
    enabled: true
  references:
  - name: Monitor Azure SQL Database with metrics and alerts
    url: https://learn.microsoft.com/azure/azure-sql/database/monitoring-metrics-alerts?view=azuresql-db
  - name: Monitor Azure SQL Database data reference
    url: https://learn.microsoft.com/azure/azure-sql/database/monitoring-sql-database-azure-monitor-reference?view=azuresql
  guid: d528ffcb-3a99-4356-96d1-981499139ffb
- name: databases - dtu_used
  description: DTU used. Applies to DTU-based databases.
  type: Metric
  verified: false
  visible: true
  tags:
  - auto-generated
  - agc-1363
  properties:
    metricName: dtu_used
    metricNamespace: Microsoft.Sql/servers/databases
    severity: 3
    windowSize: PT5M
    evaluationFrequency: PT5M
    timeAggregation: Average
    operator: GreaterThan
    criterionType: StaticThresholdCriterion
    threshold: 80.0
    enabled: true
  references:
  - name: Monitor Azure SQL Database with metrics and alerts
    url: https://learn.microsoft.com/azure/azure-sql/database/monitoring-metrics-alerts?view=azuresql-db
  - name: Monitor Azure SQL Database data reference
    url: https://learn.microsoft.com/azure/azure-sql/database/monitoring-sql-database-azure-monitor-reference?view=azuresql
  guid: d26f4c8b-0461-4c57-b230-cbd1a5424db1
- name: databases - sql_instance_memory_percent
  description: Memory usage by the database engine instance. Not applicable to data
    warehouses.
  type: Metric
  verified: false
  visible: true
  tags:
  - auto-generated
  - agc-839
  properties:
    metricName: sql_instance_memory_percent
    metricNamespace: Microsoft.Sql/servers/databases
    severity: 3
    windowSize: PT5M
    evaluationFrequency: PT5M
    timeAggregation: Average
    operator: GreaterThan
    criterionType: StaticThresholdCriterion
    threshold: 90.0
    enabled: true
  guid: f44a3cb0-6e99-4a5e-a691-c5d7d5bf7e64
- name: databases - sessions_count
  description: Number of active sessions. Not applicable to Synapse DW Analytics.
  type: Metric
  verified: false
  visible: true
  tags:
  - auto-generated
  - agc-604
  properties:
    metricName: sessions_count
    metricNamespace: Microsoft.Sql/servers/databases
    severity: 0
    windowSize: PT5M
    evaluationFrequency: PT5M
    timeAggregation: Average
    operator: LessThan
    criterionType: StaticThresholdCriterion
    threshold: 0.5
    enabled: true
  guid: 07eeae07-010e-47ca-ad90-fa7adb5a6c52
- name: databases - dtu_limit
  description: DTU Limit. Applies to DTU-based databases.
  type: Metric
  verified: false
  visible: true
  tags:
  - auto-generated
  - agc-542
  properties:
    metricName: dtu_limit
    metricNamespace: Microsoft.Sql/servers/databases
    severity: 2
    windowSize: PT5M
    evaluationFrequency: PT5M
    timeAggregation: Average
    operator: GreaterThan
    criterionType: StaticThresholdCriterion
    threshold: 100.0
    enabled: true
  guid: 50124594-a291-4183-a8e3-195f5e6f5204
- name: databases - sql_instance_cpu_percent
  description: CPU usage by all user and system workloads. Not applicable to data
    warehouses.
  type: Metric
  verified: false
  visible: true
  tags:
  - auto-generated
  - agc-445
  properties:
    metricName: sql_instance_cpu_percent
    metricNamespace: Microsoft.Sql/servers/databases
    severity: 3
    windowSize: PT15M
    evaluationFrequency: PT5M
    timeAggregation: Average
    operator: GreaterThan
    criterionType: StaticThresholdCriterion
    threshold: 70.0
    enabled: true
  guid: 1a8132b9-fbd2-4ac5-9e08-96358e16b7f7
- name: databases - app_cpu_percent
  description: App CPU percentage. Applies to serverless databases.
  type: Metric
  verified: false
  visible: true
  tags:
  - auto-generated
  - agc-415
  properties:
    metricName: app_cpu_percent
    metricNamespace: Microsoft.Sql/servers/databases
    severity: 2
    windowSize: PT5M
    evaluationFrequency: PT1M
    timeAggregation: Average
    operator: GreaterThan
    criterionType: StaticThresholdCriterion
    threshold: 80.0
    enabled: true
  guid: 05591510-5fe2-454a-96d8-bbda8201c6a4
- name: databases - app_memory_percent
  description: App memory percentage. Applies to serverless databases.
  type: Metric
  verified: false
  visible: true
  tags:
  - auto-generated
  - agc-392
  properties:
    metricName: app_memory_percent
    metricNamespace: Microsoft.Sql/servers/databases
    severity: 3
    windowSize: PT5M
    evaluationFrequency: PT1M
    timeAggregation: Average
    operator: GreaterThan
    criterionType: StaticThresholdCriterion
    threshold: 90.0
    enabled: true
  guid: c5c95fe9-a4b4-4afa-a07a-a0d18804d416
- name: databases - cpu_used
  description: CPU used. Applies to vCore-based databases.
  type: Metric
  verified: false
  visible: true
  tags:
  - auto-generated
  - agc-355
  properties:
    metricName: cpu_used
    metricNamespace: Microsoft.Sql/servers/databases
    severity: 3
    windowSize: PT5M
    evaluationFrequency: PT1M
    timeAggregation: Average
    operator: GreaterThan
    criterionType: StaticThresholdCriterion
    threshold: 80.0
    enabled: true
  guid: 3ddd3f95-989c-4777-b6b8-728439aae1df
- name: databases - memory_usage_percent
  description: Memory percentage. Applies only to data warehouses.
  type: Metric
  verified: false
  visible: true
  tags:
  - auto-generated
  - agc-337
  properties:
    metricName: memory_usage_percent
    metricNamespace: Microsoft.Sql/servers/databases
    severity: 2
    windowSize: PT5M
    evaluationFrequency: PT1M
    timeAggregation: Maximum
    operator: GreaterThan
    criterionType: StaticThresholdCriterion
    threshold: 90.0
    enabled: true
  guid: f5c13b49-8528-457d-9d7d-083b8433bf96
- name: databases - tempdb_data_size
  description: Space used in tempdb data files in kilobytes. Not applicable to data
    warehouses.
  type: Metric
  verified: false
  visible: true
  tags:
  - auto-generated
  - agc-290
  properties:
    metricName: tempdb_data_size
    metricNamespace: Microsoft.Sql/servers/databases
    severity: 3
    windowSize: PT15M
    evaluationFrequency: PT5M
    timeAggregation: Maximum
    operator: GreaterThan
    criterionType: StaticThresholdCriterion
    threshold: 80.0
    enabled: true
  guid: 0fe27fd1-e4f7-48c1-bbd2-a6953755d5e8
- name: databases - dwu_consumption_percent
  description: DWU percentage. Applies only to data warehouses.
  type: Metric
  verified: false
  visible: true
  tags:
  - auto-generated
  - agc-253
  properties:
    metricName: dwu_consumption_percent
    metricNamespace: Microsoft.Sql/servers/databases
    severity: 3
    windowSize: PT5M
    evaluationFrequency: PT1M
    timeAggregation: Maximum
    operator: GreaterThan
    criterionType: StaticThresholdCriterion
    threshold: 95.0
    enabled: true
  guid: 70f88865-7a8b-4e03-9252-a9369df503ef
- name: elasticpools - storage_percent
  description: Data space used percent. Not applicable to hyperscale
  type: Metric
  verified: false
  visible: true
  tags:
  - auto-generated
  - agc-5563
  properties:
    metricName: storage_percent
    metricNamespace: Microsoft.Sql/servers/elasticpools
    severity: 3
    windowSize: PT5M
    evaluationFrequency: PT1M
    timeAggregation: Average
    operator: GreaterThan
    criterionType: StaticThresholdCriterion
    threshold: 90.0
    enabled: true
  guid: 88f3cbc0-bcfb-482f-b6f4-709a335afcad
- name: elasticpools - cpu_percent
  description: CPU percentage
  type: Metric
  verified: false
  visible: true
  tags:
  - auto-generated
  - agc-5158
  properties:
    metricName: cpu_percent
    metricNamespace: Microsoft.Sql/servers/elasticpools
    severity: 3
    windowSize: PT5M
    evaluationFrequency: PT1M
    timeAggregation: Average
    operator: GreaterThan
    criterionType: StaticThresholdCriterion
    threshold: 90.0
    enabled: true
  guid: 805c4ae5-a852-43bd-ad1c-0f7f381d8f32
- name: elasticpools - dtu_consumption_percent
  description: DTU Percentage. Applies to DTU-based elastic pools.
  type: Metric
  verified: false
  visible: true
  tags:
  - auto-generated
  - agc-3917
  properties:
    metricName: dtu_consumption_percent
    metricNamespace: Microsoft.Sql/servers/elasticpools
    severity: 3
    windowSize: PT5M
    evaluationFrequency: PT1M
    timeAggregation: Average
    operator: GreaterThan
    criterionType: StaticThresholdCriterion
    threshold: 90.0
    enabled: true
  guid: 5d9075b5-3c19-4cf6-9c2e-50ba4c175691
- name: elasticpools - allocated_data_storage_percent
  description: Data space allocated percent. Not applicable to hyperscale
  type: Metric
  verified: false
  visible: true
  tags:
  - auto-generated
  - agc-2773
  properties:
    metricName: allocated_data_storage_percent
    metricNamespace: Microsoft.Sql/servers/elasticpools
    severity: 2
    windowSize: PT5M
    evaluationFrequency: PT1M
    timeAggregation: Maximum
    operator: GreaterThan
    criterionType: StaticThresholdCriterion
    threshold: 90.0
    enabled: true
  guid: 7e9d0710-3243-4cf2-8b73-6be1539b8545
- name: elasticpools - physical_data_read_percent
  description: Data IO percentage
  type: Metric
  verified: false
  visible: true
  tags:
  - auto-generated
  - agc-2113
  properties:
    metricName: physical_data_read_percent
    metricNamespace: Microsoft.Sql/servers/elasticpools
    severity: 3
    windowSize: PT5M
    evaluationFrequency: PT1M
    timeAggregation: Average
    operator: GreaterThan
    criterionType: StaticThresholdCriterion
    threshold: 90.0
    enabled: true
  guid: 92efc2ea-b6ed-41aa-921c-6d40e7b58c27
- name: elasticpools - log_write_percent
  description: Log IO percentage
  type: Metric
  verified: false
  visible: true
  tags:
  - auto-generated
  - agc-1483
  properties:
    metricName: log_write_percent
    metricNamespace: Microsoft.Sql/servers/elasticpools
    severity: 3
    windowSize: PT5M
    evaluationFrequency: PT5M
    timeAggregation: Average
    operator: GreaterThan
    criterionType: StaticThresholdCriterion
    threshold: 90.0
    enabled: true
  guid: 47cd814e-1991-437e-8feb-e589a250d2a3
- name: elasticpools - workers_percent
  description: Workers percentage
  type: Metric
  verified: false
  visible: true
  tags:
  - auto-generated
  - agc-985
  properties:
    metricName: workers_percent
    metricNamespace: Microsoft.Sql/servers/elasticpools
    severity: 3
    windowSize: PT5M
    evaluationFrequency: PT1M
    timeAggregation: Average
    operator: GreaterThan
    criterionType: StaticThresholdCriterion
    threshold: 90.0
    enabled: true
  guid: 1b37038e-6e5c-4463-97d4-8a632251d70e
- name: elasticpools - sessions_percent
  description: Sessions percentage
  type: Metric
  verified: false
  visible: true
  tags:
  - auto-generated
  - agc-552
  properties:
    metricName: sessions_percent
    metricNamespace: Microsoft.Sql/servers/elasticpools
    severity: 3
    windowSize: PT5M
    evaluationFrequency: PT1M
    timeAggregation: Average
    operator: GreaterThan
    criterionType: StaticThresholdCriterion
    threshold: 90.0
    enabled: true
  guid: 6b2e0ce9-d1b8-4061-b3ce-c39f9c5c1763
- name: elasticpools - sqlserver_process_memory_percent
  description: Memory usage as a percentage of the SQL DB process. Applies to elastic
    pools. (This metric is equivalent to sql_instance_memory_percent, and will be
    removed in the future.)
  type: Metric
  verified: false
  visible: true
  tags:
  - auto-generated
  - agc-500
  properties:
    metricName: sqlserver_process_memory_percent
    metricNamespace: Microsoft.Sql/servers/elasticpools
    severity: 2
    windowSize: PT5M
    evaluationFrequency: PT1M
    timeAggregation: Maximum
    operator: GreaterThan
    criterionType: StaticThresholdCriterion
    threshold: 90.0
    enabled: true
  guid: fa056aaf-57c4-4abe-9bc5-23ba413a1f5b
- name: elasticpools - sqlserver_process_core_percent
  description: CPU usage as a percentage of the SQL DB process. Applies to elastic
    pools. (This metric is equivalent to sql_instance_cpu_percent, and will be removed
    in the future.)
  type: Metric
  verified: false
  visible: true
  tags:
  - auto-generated
  - agc-472
  properties:
    metricName: sqlserver_process_core_percent
    metricNamespace: Microsoft.Sql/servers/elasticpools
    severity: 2
    windowSize: PT5M
    evaluationFrequency: PT1M
    timeAggregation: Maximum
    operator: GreaterThan
    criterionType: StaticThresholdCriterion
    threshold: 95.0
    enabled: true
  guid: 73ec4301-872a-4bea-928e-420255aae8cb
- name: elasticpools - xtp_storage_percent
  description: In-Memory OLTP storage percent. Not applicable to hyperscale
  type: Metric
  verified: false
  visible: true
  tags:
  - auto-generated
  - agc-331
  properties:
    metricName: xtp_storage_percent
    metricNamespace: Microsoft.Sql/servers/elasticpools
    severity: 3
    windowSize: PT5M
    evaluationFrequency: PT5M
    timeAggregation: Average
    operator: GreaterThan
    criterionType: StaticThresholdCriterion
    threshold: 80.0
    enabled: true
  guid: db517009-30ad-4cbc-b282-7f212052c3b4
- name: elasticpools - tempdb_log_used_percent
  description: Space used percentage in tempdb transaction log file
  type: Metric
  verified: false
  visible: true
  tags:
  - auto-generated
  - agc-295
  properties:
    metricName: tempdb_log_used_percent
    metricNamespace: Microsoft.Sql/servers/elasticpools
    severity: 3
    windowSize: PT5M
    evaluationFrequency: PT5M
    timeAggregation: Average
    operator: GreaterThan
    criterionType: StaticThresholdCriterion
    threshold: 80.0
    enabled: true
  guid: af66de51-079c-4d34-af92-f52f887642dc
- name: elasticpools - allocated_data_storage
  description: Data space allocated. Not applicable to hyperscale
  type: Metric
  verified: false
  visible: true
  tags:
  - auto-generated
  - agc-270
  properties:
    metricName: allocated_data_storage
    metricNamespace: Microsoft.Sql/servers/elasticpools
    severity: 1
    windowSize: PT5M
    evaluationFrequency: PT1M
    timeAggregation: Average
    operator: GreaterThanOrEqual
    criterionType: StaticThresholdCriterion
    threshold: 225000000000.0
    enabled: true
  guid: 3743016a-a056-43fe-b53a-36dd9a17626d
- name: elasticpools - eDTU_used
  description: eDTU used. Applies to DTU-based elastic pools.
  type: Metric
  verified: false
  visible: true
  tags:
  - auto-generated
  - agc-256
  properties:
    metricName: eDTU_used
    metricNamespace: Microsoft.Sql/servers/elasticpools
    severity: 3
    windowSize: PT5M
    evaluationFrequency: PT1M
    timeAggregation: Average
    operator: GreaterThan
    criterionType: StaticThresholdCriterion
    threshold: 80.0
    enabled: true
  guid: 16a64053-1905-4d8e-8198-810584cad108