Azure SQL Elastic Pool¶

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://promitor.io/concepts/how-it-works#using-resource-discovery)
  - name: sql-elastic-pools