SQL exporter discovery configuration file (jpc_file_sd_config_mssql.yml)

Organization of this page

Format

Write in YAML format.

- targets:
#  - hostname-of-SQL-exporter:port-number-of-SQL-exporter
  labels:
    jp1_pc_exporter: JPC SQL exporter
    jp1_pc_category: database
    jp1_pc_trendname: sql_exporter
    jp1_pc_remote_monitor_instance: installation-destination-hostname:MSSQL metric collector(SQL exporter)
    jp1_pc_multiple_node: "{__name__=~'mssql_.*'}"
    jp1_pc_rm_agent_create_flag: false

To Page Top

File

jpc_file_sd_config_mssql.yml

jpc_file_sd_config_mssql.yml.model (model file)

To Page Top

Storage destination directory

- Integrated agent host

For Windows

For physical hosts (definition files and model files)

Agent-path\conf\
Logical host (definition file)

Shared-folder\jp1ima\conf\

To Page Top

Description

Files that set SQL exporter that Prometheus server will scrape.

To Page Top

Character code

UTF-8 (without BOM)

To Page Top

Line feed code

CR+LF

To Page Top

Time of import of definitions

When Prometheus server reload API is executed or restarted, Prometheus server is subject to scrape. After that, when you execute jddcreatetree command and jddupdatetree command, it is reflected in the content displayed in integrated operation viewer tree.

To Page Top

Description

hostname-of-SQL-exporter: Specifies the hostname of SQL exporter to scrape to, using characters other than 1 to 253 control characters. You can also specify FQDN format. "localhost" cannot be specified.
port-number-of-SQL-exporter: Specifies the port number of SQL exporter to scrape to.
installation-destination-hostname: Specifies the host name of the host on which SQL exporter is running.

To Page Top

Definition example

- targets:
  - hostA:20735
  labels:
    jp1_pc_exporter: JPC SQL exporter
    jp1_pc_category: database
    jp1_pc_trendname: sql_exporter
    jp1_pc_remote_monitor_instance: hostA:MSSQL metric collector(SQL exporter)
    jp1_pc_multiple_node: "{__name__=~'mssql_.*'}"
    jp1_pc_rm_agent_create_flag: false

To Page Top