n8500x/sql-server-rca-assistant-collector repository overview

⁠sql-server-rca-assistant-collector

Companion image to n8500x/sql-server-rca-assistant⁠ — the DMV collector for its optional monitoring stack. You only need this image if you want ClickHouse-backed recent-vs-baseline trend analysis; the assistant runs fine without it.

⁠What it does

Continuously polls a SQL Server target's DMVs (wait stats, blocking chains, memory grants, query stats, schedulers, file stats, missing indexes) plus First Responder Kit results, and writes them into ClickHouse. Exposes a small Flask health/incident API on :8080 (GET /health).

SQL Server ──(DMV polling every N s)──▶ collector ──▶ ClickHouse ──▶ Grafana / the assistant

⁠Not standalone

This image is meant to be deployed by the project's Helm chart (monitoring.deploy=true) or openshift/monitoring/, which wire it to ClickHouse and SQL Server. Run directly only for testing:

docker run --rm -p 8080:8080 \
  -e SQLSERVER_HOST=mssql -e SQLSERVER_USER=sa -e SQLSERVER_PASSWORD='YourSecurePassword123!' \
  -e SQLSERVER_DATABASE=master \
  -e CLICKHOUSE_HOST=clickhouse -e CLICKHOUSE_PORT=8123 \
  -e CLICKHOUSE_DATABASE=rca_metrics -e CLICKHOUSE_USER=rca -e CLICKHOUSE_PASSWORD=rca_password \
  -e COLLECTION_INTERVAL=5 \
  n8500x/sql-server-rca-assistant-collector:latest

⁠Environment

Built from the pinned upstream commit of dzigz/sql-server-rca-assistant⁠ (sim/docker/collectors/dmv). Runs as a non-root, OpenShift-arbitrary-UID-clean container. Tags: latest + dated YYYYMMDD-HHMMSS. License: MIT (upstream).