Prometheus exporter for Azure Elastic Pool SQL metrics.

Forked from the azure_sql_exporter.

Databases are only queries when fetching /metrics from the exporter so that you may control the interval from your scrape_config section in Prometheus. Recommended to be no more frequent than 15s, this is the frequency that the data is updated at.

go get -u github.com/benclapp/azure_elastic_sql_exporter

Usage of azure_elastic_sql_exporter:
  -config.file string
    	Specify the config file with the database credentials. (default "./config.yaml")
  -web.listen-address string
    	Address to listen on for web interface and telemetry. (default ":9596")
  -web.telemetry-path string
    	Path under which to expose metrics. (default "/metrics")

This exporter requires a configuration file. By default, it will look for the config.yaml file in the PWD and can be specified with the -config.file parameter.

The file is in YAML format and contains the information for connecting to the databases you want to export. This file will contain sensitive information so make sure your configuration management locks down access to this file (chmod [46]00) and it is encouraged to create an SQL user with the least amount of privilege.

databases:
  - user: prometheus
    port: 1433
    password: str0ngP@sswordG0esHere
    server: salesdb.database.windows.net
  - user: prometheus
    port: 1433
    password: str0ngP@sswordG0esHere
    server: inventorydb.database.windows.net

• #1 Add support for multiple elastic pools

Pre-compiled versions may be found in the release section.

Images are available on Docker Hub. Example:

docker run -d -p 9596:9596 -v ./config.yaml:/config/config.yaml benclapp/azure_elastic_sql_exporter:latest -config.file /config/config.yaml