Azure SQL Server

Kubernetes

OpsVerse's Kubernetes agent can collect metrics from Azure SQL Server.

Add the following YAML snippet to the agent's values.yaml and run the agent based on these instructions.

The placeholders <azure-client-id>, <azure-tenant-id>, <azure-client-secret>, <resource-subscription-id> in the following YAML with the appropriate details.

azure-metrics-exporter:
  enabled: true
  env:
    DEBUG: "true"
    VERBOSE: "true"
    AZURE_CLIENT_ID: "<azure-client-id>"
    AZURE_TENANT_ID: "<azure-tenant-id>"
    AZURE_CLIENT_SECRET: "<azure-client-secret>"



victoria-metrics-agent:
  extraScrapeConfigs:
    - job_name: az-sql-metrics
      scrape_interval: 30s
      metrics_path: /probe/metrics/list
      params:
        name:
          - az_sql
        template:
          - '{name}_{metric}'
        subscription:
          - <resource-subscription-id>
        resourceType:
          - Microsoft.sql/servers/databases
        metric:
          - app_cpu_billed
          - app_cpu_percent
          - app_memory_percent
          - availability
          - blocked_by_firewall
          - cpu_percent
          - cpu_limit
          - cpu_used
          - physical_data_read_percent
          - allocated_data_storage
          - storage
          - storage_percent
          - deadlock
          - connection_failed
          - connection_failed_user_error
          - ledger_digest_upload_failed
          - xtp_storage_percent
          - log_write_percent
          - sessions_count
          - sessions_percent
          - connection_successful
          - ledger_digest_upload_success
          - workers_percent
          - sql_instance_cpu_percent
          - sql_instance_memory_percent
          - sqlserver_process_core_percent
          - sqlserver_process_memory_percent
          - tempdb_data_size
          - tempdb_log_size
          - tempdb_log_used_percent
          - diff_backup_size_bytes
          - full_backup_size_bytes
          - log_backup_size_bytes
      static_configs:
        - targets:
            - http://devopsnow-agent-azure-metr.devopsnow.svc.cluster.local:8080