SQL exporter metric definition file (metrics_sql_exporter.conf)

Format

See Format in Node exporter metric definition file (metrics_node_exporter.conf).

To Page Top

File

metrics_sql_exporter.conf

metrics_sql_exporter.conf.model (model file)

To Page Top

Storage destination directory

- Integration Manager host

• For a physical host

  Manager-path\conf\imdd\plugin\jp1pccs\

• For a physical host

  Shared-folder\jp1imm\conf\imdd\plugin\jp1pccs\

To Page Top

Description

This file defines the metric information of SQL exporter displayed on the Trends tab, Dashboard tab, and Dashboard List dialog box of the Integrated Operation Viewer window.

Defined content is used for the __metricListGet method of product plugin in JP1/IM - Agent and the return value of the __timeSeriesDataGet method.

If JP1/IM - Manager is in a hierarchical configuration and you want the Integration Manager to refer to trend data stored in Trend data Management Database of lower manager, you must add the referenced trend data metrics to the Integration Manager metric definition file.

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

Definitions are reflected when the metric information is obtained on the Trends tab, Dashboard tab, and Dashboard List dialog box of the Integrated Operation Viewer window, or with the REST API.

To Page Top

Description

See Description in Node exporter metric definition file (metrics_node_exporter.conf).

To Page Top

Model file settings (initial status)

The settings (initial status) of each metric described in the model file of the SQL exporter metric definition file are shown below.

• connections^#

  ■Settings (initial status)

  Member name		Settings (initial status)
  name		connections
  default		true
  Metric definition-file promql (including $jp1im_TrendData_labels)		mssql_connections and $jp1im_TrendData_labels
  resource_en	category	database_sql
  	label	Number of active connections
  	description	Number of active connections
  	unit	-
  resource_ja	category	database_sql
  	label	アクティブな接続の数
  	description	アクティブな接続の数。
  	unit	-

  #

  There are no applicable fields in JP1/PFM-RM for Microsoft SQL Server.

• deadlocks^#

  ■Settings (initial status)

  Member name		Settings (initial status)
  name		deadlocks
  default		False
  Metric definition-file promql (including $jp1im_TrendData_labels)		rate(mssql_deadlocks[$stepTime{minSeconds=\"120\"}]) and $jp1im_TrendData_labels
  resource_en	category	database_sql
  	label	The number of occurred lock requests that caused the deadlock
  	description	The number of occurred lock requests that caused the deadlock
  	unit	-
  resource_ja	category	database_sql
  	label	デッドロックの原因となったロック要求の発生数
  	description	デッドロックの原因となったロック要求の発生数。
  	unit	-

  #

  There are no applicable fields in JP1/PFM-RM for Microsoft SQL Server.

• user_errors^#

  ■Settings (initial status)

  Member name		Settings (initial status)
  name		user_errors
  default		False
  Metric definition-file promql (including $jp1im_TrendData_labels)		rate(mssql_user_errors[$stepTime{minSeconds=\"120\"}]) and $jp1im_TrendData_labels
  resource_en	category	database_sql
  	label	The number of occurred user errors
  	description	The number of occurred user errors
  	unit	-
  resource_ja	category	database_sql
  	label	ユーザエラーの発生数
  	description	ユーザエラーの発生数。
  	unit	-

  #

  There are no applicable fields in JP1/PFM-RM for Microsoft SQL Server.

• kill_connection_errors^#

  ■Settings (initial status)

  Member name		Settings (initial status)
  name		kill_connection_errors
  default		False
  Metric definition-file promql (including $jp1im_TrendData_labels)		rate(mssql_kill_connection_errors[$stepTime{minSeconds=\"120\"}]) and $jp1im_TrendData_labels
  resource_en	category	database_sql
  	label	The number of occurred critical errors that caused SQL Server to forcibly terminate connections
  	description	The number of occurred critical errors that caused SQL Server to forcibly terminate connections
  	unit	-
  resource_ja	category	database_sql
  	label	SQL Serverが接続を強制終了する原因となった重大なエラーの発生数
  	description	SQL Serverが接続を強制終了する原因となった重大なエラーの発生数。
  	unit	-

  #

  There are no applicable fields in JP1/PFM-RM for Microsoft SQL Server.

• page_life_expectancy_seconds^#

  ■Settings (initial status)

  Member name		Settings (initial status)
  name		page_life_expectancy_seconds
  default		False
  Metric definition-file promql (including $jp1im_TrendData_labels)		rate(mssql_page_life_expectancy_seconds[$stepTime{minSeconds=\"120\"}]) and $jp1im_TrendData_labels
  resource_en	category	database_sql
  	label	The minimum number of seconds remains in the buffer pool
  	description	The minimum number of seconds a page remains in the buffer pool of this node without being referenced
  	unit	sec
  resource_ja	category	database_sql
  	label	バッファー・プールに留まる最小秒数
  	description	ページが参照なしでこのノードのバッファー・プールに留まる最小秒数。
  	unit	Seconds

  #

  There are no applicable fields in JP1/PFM-RM for Microsoft SQL Server.

• batch_requests^#

  ■Settings (initial status)

  Member name		Settings (initial status)
  name		batch_requests
  default		False
  Metric definition-file promql (including $jp1im_TrendData_labels)		rate(mssql_batch_requests[$stepTime{minSeconds=\"120\"}]) and $jp1im_TrendData_labels
  resource_en	category	database_sql
  	label	The number of command batches received
  	description	The number of command batches received
  	unit	-
  resource_ja	category	database_sql
  	label	受信したコマンドバッチの数
  	description	受信したコマンドバッチの数。
  	unit	-

  #

  There are no applicable fields in JP1/PFM-RM for Microsoft SQL Server.

• log_growths^#

  ■Settings (initial status)

  Member name		Settings (initial status)
  name		log_growths
  default		False
  Metric definition-file promql (including $jp1im_TrendData_labels)		mssql_log_growths and $jp1im_TrendData_labels
  resource_en	category	database_sql
  	label	The number of times the transaction log has been expanded for each database
  	description	The number of times the transaction log has been expanded for each database
  	unit	-
  resource_ja	category	database_sql
  	label	データベースごとにトランザクション・ログが拡張された回数
  	description	データベースごとにトランザクション・ログが拡張された回数。
  	unit	-

  #

  There are no applicable fields in JP1/PFM-RM for Microsoft SQL Server.

• checkpoint_pages_sec^#

  ■Settings (initial status)

  Member name		Settings (initial status)
  name		checkpoint_pages_sec
  default		False
  Metric definition-file promql (including $jp1im_TrendData_labels)		mssql_checkpoint_pages_sec and $jp1im_TrendData_labels
  resource_en	category	database_sql
  	label	Checkpoint pages per second
  	description	Checkpoint pages per second
  	unit	-
  resource_ja	category	database_sql
  	label	チェックポイント・ページ/秒
  	description	チェックポイント・ページ/秒。
  	unit	-

  #

  There are no applicable fields in JP1/PFM-RM for Microsoft SQL Server.

• io_stall_seconds^#

  ■Settings (initial status)

  Member name		Settings (initial status)
  name		io_stall_seconds
  default		False
  Metric definition-file promql (including $jp1im_TrendData_labels)		avg(mssql_io_stall_seconds)without(operation) and $jp1im_TrendData_labels
  resource_en	category	database_sql
  	label	Stall time per I/O operation for the database
  	description	Stall time per I/O operation for the database (in seconds)
  	unit	sec
  resource_ja	category	database_sql
  	label	データベースとI/O操作あたりのストール時間
  	description	データベースとI/O操作あたりのストール時間。
  	unit	Seconds

  #

  There are no applicable fields in JP1/PFM-RM for Microsoft SQL Server.

• io_stall_read_seconds^#

  ■Settings (initial status)

  Member name		Settings (initial status)
  name		io_stall_read_seconds
  default		False
  Metric definition-file promql (including $jp1im_TrendData_labels)		mssql_io_stall_seconds{operation=\"read\"} and $jp1im_TrendData_labels
  resource_en	category	database_sql
  	label	Stall time per read 1 operation
  	description	Stall time per read 1 operation (in seconds)
  	unit	sec
  resource_ja	category	database_sql
  	label	read 1操作あたりのストール時間
  	description	read 1操作あたりのストール時間。
  	unit	Seconds

  #

  There are no applicable fields in JP1/PFM-RM for Microsoft SQL Server.

• io_stall_write_seconds^#

  ■Settings (initial status)

  Member name		Settings (initial status)
  name		io_stall_write_seconds
  default		False
  Metric definition-file promql (including $jp1im_TrendData_labels)		mssql_io_stall_seconds{operation=\"write\"} and $jp1im_TrendData_labels
  resource_en	category	database_sql
  	label	Stall time per write 1 operation
  	description	Stall time per write 1 operation (in seconds)
  	unit	sec
  resource_ja	category	database_sql
  	label	write 1操作あたりのストール時間
  	description	write 1操作あたりのストール時間。
  	unit	Seconds

  #

  There are no applicable fields in JP1/PFM-RM for Microsoft SQL Server.

• io_stall_total_seconds^#

  ■Settings (initial status)

  Member name		Settings (initial status)
  name		io_stall_total_seconds
  default		False
  Metric definition-file promql (including $jp1im_TrendData_labels)		mssql_io_stall_total_seconds and $jp1im_TrendData_labels
  resource_en	category	database_sql
  	label	Total stall time per database
  	description	Total stall time per database (in seconds)
  	unit	sec
  resource_ja	category	database_sql
  	label	データベースごとの合計停止時間
  	description	データベースごとの合計停止時間。
  	unit	Seconds

  #

  There are no applicable fields in JP1/PFM-RM for Microsoft SQL Server.

• resident_memory_mbytes^#

  ■Settings (initial status)

  Member name		Settings (initial status)
  name		resident_memory_mbytes
  default		False
  Metric definition-file promql (including $jp1im_TrendData_labels)		mssql_resident_memory_bytes /1024/1024 and $jp1im_TrendData_labels
  resource_en	category	database_sql
  	label	SQL Server resident memory size
  	description	SQL Server resident memory size (also known as the working set)
  	unit	MBytes
  resource_ja	category	database_sql
  	label	Server常駐メモリサイズ
  	description	SQL Server常駐メモリサイズ（別名ワーキングセット）。
  	unit	MBytes

  #

  There are no applicable fields in JP1/PFM-RM for Microsoft SQL Server.

• virtual_memory_mbytes^#

  ■Settings (initial status)

  Member name		Settings (initial status)
  name		virtual_memory_mbytes
  default		False
  Metric definition-file promql (including $jp1im_TrendData_labels)		mssql_virtual_memory_bytes /1024/1024 and $jp1im_TrendData_labels
  resource_en	category	database_sql
  	label	commit size
  	description	SQL Server commit size for virtual memory
  	unit	MBytes
  resource_ja	category	database_sql
  	label	コミットサイズ
  	description	SQL Serverの仮想メモリに対するコミットサイズ。
  	unit	MBytes

  #

  There are no applicable fields in JP1/PFM-RM for Microsoft SQL Server.

• memory_utilization_percentage^#

  ■Settings (initial status)

  Member name		Settings (initial status)
  name		memory_utilization_percentage
  default		False
  Metric definition-file promql (including $jp1im_TrendData_labels)		mssql_memory_utilization_percentage and $jp1im_TrendData_labels
  resource_en	category	database_sql
  	label	The percentage of committed memory within the working set
  	description	The percentage of committed memory within the working set
  	unit	%
  resource_ja	category	database_sql
  	label	ワーキング セット内のコミット済みメモリの割合
  	description	ワーキング セット内のコミット済みメモリの割合。
  	unit	%

  #

  There are no applicable fields in JP1/PFM-RM for Microsoft SQL Server.

• page_fault_count^#

  ■Settings (initial status)

  Member name		Settings (initial status)
  name		page_fault_count
  default		False
  Metric definition-file promql (including $jp1im_TrendData_labels)		rate(mssql_page_fault_count[$stepTime{minSeconds=\"120\"}]) and $jp1im_TrendData_labels
  resource_en	category	database_sql
  	label	The number of page faults generated by the SQL Server process
  	description	The number of page faults generated by the SQL Server process
  	unit	-
  resource_ja	category	database_sql
  	label	SQL Serverプロセスによって発生したページ フォールトの数
  	description	SQL Serverプロセスによって発生したページ フォールトの数。
  	unit	-

  #

  There are no applicable fields in JP1/PFM-RM for Microsoft SQL Server.

• os_memory_mbytes^#

  ■Settings (initial status)

  Member name		Settings (initial status)
  name		os_memory_mbytes
  default		False
  Metric definition-file promql (including $jp1im_TrendData_labels)		sum(mssql_os_memory)without(state) /1024/1024 and $jp1im_TrendData_labels
  resource_en	category	database_sql
  	label	OS physical memory (total)
  	description	OS physical memory (total)
  	unit	MBytes
  resource_ja	category	database_sql
  	label	OS物理メモリ（全体）
  	description	OS物理メモリ（全体）。
  	unit	MBytes

  #

  There are no applicable fields in JP1/PFM-RM for Microsoft SQL Server.

• os_memory_available_mbytes^#

  ■Settings (initial status)

  Member name		Settings (initial status)
  name		os_memory_available_mbytes
  default		true
  Metric definition-file promql (including $jp1im_TrendData_labels)		mssql_os_memory{state="available"} /1024/1024 and $jp1im_TrendData_labels
  resource_en	category	database_sql
  	label	OS physical memory (available)
  	description	OS physical memory (available)
  	unit	MBytes
  resource_ja	category	database_sql
  	label	OS物理メモリ（使用可能）
  	description	OS物理メモリ（使用可能）。
  	unit	MBytes

  #

  There are no applicable fields in JP1/PFM-RM for Microsoft SQL Server.

• os_memory_used_mbytes^#

  ■Settings (initial status)

  Member name		Settings (initial status)
  name		os_memory_used_mbytes
  default		False
  Metric definition-file promql (including $jp1im_TrendData_labels)		mssql_os_memory{state="used"} /1024/1024 and $jp1im_TrendData_labels
  resource_en	category	database_sql
  	label	OS physical memory (used)
  	description	OS physical memory (used)
  	unit	MBytes
  resource_ja	category	database_sql
  	label	OS物理メモリ（使用済み）
  	description	OS物理メモリ（使用済み）。
  	unit	MBytes

  #

  There are no applicable fields in JP1/PFM-RM for Microsoft SQL Server.

• os_page_file^#

  ■Settings (initial status)

  Member name		Settings (initial status)
  name		os_page_file
  default		False
  Metric definition-file promql (including $jp1im_TrendData_labels)		sum(mssql_os_page_file)without(state) and $jp1im_TrendData_labels
  resource_en	category	database_sql
  	label	OS page file (total)
  	description	OS page file (total)
  	unit	-
  resource_ja	category	database_sql
  	label	OSページファイル（全体）
  	description	OSページファイル（全体）。
  	unit	-

  #

  There are no applicable fields in JP1/PFM-RM for Microsoft SQL Server.

• os_page_file_available^#

  ■Settings (initial status)

  Member name		Settings (initial status)
  name		os_page_file_available
  default		true
  Metric definition-file promql (including $jp1im_TrendData_labels)		mssql_os_page_file{state="available"} and $jp1im_TrendData_labels
  resource_en	category	database_sql
  	label	OS page file (available)
  	description	OS page file (available)
  	unit	-
  resource_ja	category	database_sql
  	label	OSページファイル（使用可能）
  	description	OSページファイル（使用可能）。
  	unit	-

  #

  There are no applicable fields in JP1/PFM-RM for Microsoft SQL Server.

• os_page_file_used^#

  ■Settings (initial status)

  Member name		Settings (initial status)
  name		os_page_file_used
  default		False
  Metric definition-file promql (including $jp1im_TrendData_labels)		mssql_os_page_file{state="used"} and $jp1im_TrendData_labels
  resource_en	category	database_sql
  	label	OS page file (used)
  	description	OS page file (used)
  	unit	-
  resource_ja	category	database_sql
  	label	OSページファイル（使用済み）
  	description	OSページファイル（使用済み）。
  	unit	-

  #

  There are no applicable fields in JP1/PFM-RM for Microsoft SQL Server.

• process_count^#

  ■Settings (initial status)

  Member name		Settings (initial status)
  name		process_count
  default		true
  Metric definition-file promql (including $jp1im_TrendData_labels)		mssql_database_detail_process_count and $jp1im_TrendData_labels
  resource_en	category	database_sql
  	label	Total number of processes
  	description	Total number of processes
  	unit	-
  resource_ja	category	database_sql
  	label	プロセスの合計数
  	description	プロセスの合計数。
  	unit	-

  #

  Equivalent to Process Count field in JP1/PFM-RM for Microsoft SQL Server PD_DD record.

• perc_busy_percentage^#

  ■Settings (initial status)

  Member name		Settings (initial status)
  name		perc_busy_percentage
  default		true
  Metric definition-file promql (including $jp1im_TrendData_labels)		mssql_global_server_summary_perc_busy and $jp1im_TrendData_labels
  resource_en	category	database_sql
  	label	The percentage of CPU busy time
  	description	The percentage of CPU busy time
  	unit	%
  resource_ja	category	database_sql
  	label	CPUビジー時間の割合
  	description	CPUビジー時間の割合。
  	unit	%

  #

  Equivalent to CPU % field in PI record of JP1/PFM-RM for Microsoft SQL Server.

• server_summary_packet_errors^#

  ■Settings (initial status)

  Member name		Settings (initial status)
  name		server_summary_packet_errors
  default		False
  Metric definition-file promql (including $jp1im_TrendData_labels)		mssql_global_server_summary_packet_errors and $jp1im_TrendData_labels
  resource_en	category	database_sql
  	label	The number of packet errors
  	description	The number of packet errors
  	unit	-
  resource_ja	category	database_sql
  	label	パケットエラーの数
  	description	パケットエラーの数。
  	unit	-

  #

  Equivalent to Pkt Errors field in PI record of JP1/PFM-RM for Microsoft SQL Server.

• blocked_processes^#

  ■Settings (initial status)

  Member name		Settings (initial status)
  name		blocked_processes
  default		true
  Metric definition-file promql (including $jp1im_TrendData_labels)		mssql_server_detail_blocked_processes and $jp1im_TrendData_labels
  resource_en	category	database_sql
  	label	The number of processes waiting due to processes locked
  	description	The number of processes waiting due to processes running on Microsoft SQL Server being locked
  	unit	-
  resource_ja	category	database_sql
  	label	プロセスがロックしていることにより待たされているプロセスの数
  	description	Microsoft SQL Serverで動作しているプロセスがロックしていることにより待たされているプロセスの数。
  	unit	-

  #

  Equivalent to Blocked Processes field in PD record of JP1/PFM-RM for Microsoft SQL Server.

• server_overview_cache_hit^#

  ■Settings (initial status)

  Member name		Settings (initial status)
  name		server_overview_cache_hit
  default		true
  Metric definition-file promql (including $jp1im_TrendData_labels)		mssql_server_overview_cache_hit and $jp1im_TrendData_labels
  resource_en	category	database_sql
  	label	The percentage of times data pages were found in the data cache
  	description	The percentage of times data pages were found in the data cache
  	unit	%
  resource_ja	category	database_sql
  	label	データキャッシュ内でデータページが見つかった回数の割合
  	description	データキャッシュ内でデータページが見つかった回数の割合。
  	unit	%

  #

  Equivalent to Cache Hit % field in JP1/PFM-RM for Microsoft SQL Server PI_SERV record.

To Page Top