项目地址

https://gitee.com/ops-dev/sqlserver-exporter

环境变量

  1. # export 端口
  2. YOULU_SQLSERVER_EXPORTER_WEB_LISTEN_ADDRESS = :9821
  3. # export 监控地址
  4. YOULU_SQLSERVER_EXPORTER_WEB_TELEMETRY_PATH = /metrics
  5. # 数据库服务器地址
  6. YOULU_SQLSERVER_EXPORTER_SQL_SERVER = localhost
  7. # 数据库端口
  8. YOULU_SQLSERVER_EXPORTER_SQL_PORT = 1433
  9. # 数据库用户名
  10. YOULU_SQLSERVER_EXPORTER_SQL_USER = sa
  11. # 数据库密码
  12. YOULU_SQLSERVER_EXPORTER_SQL_PASSWORD = Mg5UawHtkp
  13. # 数据库名
  14. YOULU_SQLSERVER_EXPORTER_SQL_DATABASE = erkengzi

Prometheus

  1.  - job_name: 'sqlserver'
  2.     scrape_interval: 15s
  3.     static_configs:
  4.     - targets: ['192.168.10.69:9821']

rules.yml

  1. - name: sqlserver  ## mysql 监控报警
  2.   rules: 
  3.   - alert: sqlserver_status
  4.     expr: sqlStatus > 0
  5.     for: 1s
  6.     labels:
  7.         severity: critical
  8.     annotations:
  9.       summary: "Instance {{ $labels.instance }} ....  当前值{{ $value }}"
  10.       description: "当前sqlserver...."