SQLServer service status monitoring on Windows with Prometheu.

Atsushi Suzuki — Fri, 03 May 2024 15:07:31 +0000

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   #1 is running, 0 is not running
  for: 7m   #If this duration is exceeded, the alert will change from Warning to Critical. s(seconds) m(minutes)
  labels:
      AlertGp: [alert group name]  #This name is arbitrary. You can set any group label for the alert. This label can be used in alertmanager.yml.

Kubernetest (on-prem) master node and worker node associations.

Atsushi Suzuki — Fri, 03 May 2024 14:14:10 +0000

Procedure for reassociating worker nodes with the master node in on-premise Kubernetes after restarting the worker nodes.
++++++++++++++++++++++++++++++++
[Environment]
Ubuntu 20.10
Cluster Version 1.22.2
++++++++++++++++++++++++++++++++

1) Reset the state of kubelet using kubeadm. (on the worker node)

$ kubeadm reset

2) Generate the --discovery-token-ca-cert-hash (on the master node)

$ openssl x509 -pubkey -in /etc/kubernetes/pki/ca.crt | openssl rsa -pubin -outform der 2>/dev/null | openssl dgst -sha256 -hex | sed 's/^.* //'

Paste the output hash into a notepad for later use.

3) Generate a --token (on the master node)

$ kubeadm token create

Copy and paste the output token into a notepad.

4) Reassociate with the master node (on the worker node)

Use the values output in steps 2) and 3).