SQLServer service status monitoring on Windows with Prometheu.

This is the procedure for monitoring the service status of SQLServer on Windows with Prometheu.

++++++++++++++++++++++++++++++++

[environment].

prometheus : Ver. 2.23.0

prometheus-alertmanager : Ver. 0.15.3

++++++++++++++++++++++++++++++++

Describe the SQLserver service monitoring rules in the yml file (rules.yml by default) where the monitoring rules are set.

In this case, we will describe a configuration that alerts when the state of the SQLServer service is anything other than ‘started’.

- alert: SQLServer-ServiceDown
  expr: windows_service_state{job="[job name]", name="[target instance service name]", state="running"} == 0 …

case environment file monitoring prometheus rules service set sqlserver sre will windows