sqlServer采集器安装说明

本文介绍了如何部署和配置sql_exporter来监控SQLServer,包括下载、解压、配置数据源、启动服务,并展示了预期的监控指标输出。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

sqlServer Exporter

问题描述

需要对sqlServer进行监控,部署了sql_exporter,对过程进行一下记录。

源码参见sqlServer_exporter

①下载

https://github.com/free/sql_exporter/releases

②解压缩

tar -xzvf sql_exporter-0.5.linux-amd64.tar.gz

③启动:

先进入exporter

cd sql_exporter-0.5.linux-amd64

然后修改sql_exporter.yml文件中data_source_name: ’ sqlserver:// prom_user:prom_password@dbserver1.example.com:1433 '的内容,根据实际情况修改sqlServer的用户名和密码,以及目标ip

vi sql_exporter.yml

最后启动exporter

./sql_exporter

④验证:

curl localhost:9399/metrics

预期输出:

# HELP mssql_batch_requests Number of command batches received.
# TYPE mssql_batch_requests counter
mssql_batch_requests 13
# HELP mssql_connections Number of active connections.
# TYPE mssql_connections gauge
mssql_connections{db="master"} 48
# HELP mssql_deadlocks Number of lock requests that resulted in a deadlock.
# TYPE mssql_deadlocks counter
mssql_deadlocks 0
# HELP mssql_io_stall_seconds Stall time in seconds per database and I/O operation.
# TYPE mssql_io_stall_seconds counter
mssql_io_stall_seconds{db="master",operation="read"} 0.895
mssql_io_stall_seconds{db="master",operation="write"} 0.07
mssql_io_stall_seconds{db="model",operation="read"} 0.233
mssql_io_stall_seconds{db="model",operation="write"} 0.021
mssql_io_stall_seconds{db="msdb",operation="read"} 0.439
mssql_io_stall_seconds{db="msdb",operation="write"} 0.029
mssql_io_stall_seconds{db="tempdb",operation="read"} 0.156
mssql_io_stall_seconds{db="tempdb",operation="write"} 0.018
# HELP mssql_io_stall_total_seconds Total stall time in seconds per database.
# TYPE mssql_io_stall_total_seconds counter
mssql_io_stall_total_seconds{db="master"} 0.965
mssql_io_stall_total_seconds{db="model"} 0.254
mssql_io_stall_total_seconds{db="msdb"} 0.468
mssql_io_stall_total_seconds{db="tempdb"} 0.174
# HELP mssql_kill_connection_errors Number of severe errors that caused SQL Server to kill the connection.
# TYPE mssql_kill_connection_errors counter
mssql_kill_connection_errors 0
# HELP mssql_local_time_seconds Local time in seconds since epoch (Unix time).
# TYPE mssql_local_time_seconds gauge
mssql_local_time_seconds 1.578622388e+09
# HELP mssql_log_growths Number of times the transaction log has been expanded, per database.
# TYPE mssql_log_growths counter
mssql_log_growths{db="master"} 0
mssql_log_growths{db="model"} 0
mssql_log_growths{db="msdb"} 0
mssql_log_growths{db="mssqlsystemresource"} 0
mssql_log_growths{db="tempdb"} 0
...
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值