Skip to content

Azure SQL Elastic Pool

Availability BadgeResource Discovery Support Badge

You can scrape an Azure SQL Elastic Pool via the SqlElasticPool resource type.

When using declared resources, the following fields need to be provided:

  • serverName - The name of the SQL Server instance.
  • poolName - The name of the elastic pool.

All supported metrics are documented in the official Azure Monitor documentation.

The following scraper-specific metric labels will be added:

  • server - The name of the SQL Server instance.
  • elastic_pool - The name of the elastic pool.

Example

Here is an example configuration:

- name: promitor_demo_sql_elastic_pool_cpu
  description: "CPU percentage used for a Azure SQL Elastic Pool"
  resourceType: SqlElasticPool
  labels:
    app: promitor
  azureMetricConfiguration:
    metricName: cpu_percent
    aggregation:
      type: Average
  resources: # Optional, required when no resource discovery is configured
  - serverName: promitor-sql-server
    poolName: promitor-db
  resourceDiscoveryGroups: # Optional, requires Promitor Resource Discovery agent (https://docs.promitor.io/latest/how-it-works#using-resource-discovery)
  - name: sql-elastic-pools