Summary

Test Plan

Additional Information

Summary by cubic

Adds MSSQL Distributor monitoring to collect subscriber metrics for replication (latency, agent not running, time to expiration) and exposes new charts with clear labels. This complements existing publisher metrics and improves visibility into replication health.

• New Features

  • Collects subscription data from the distribution DB via sp_replmonitorhelpsubscription (types 0, 1, 2).
  • Adds publication_subscription dictionary linking subscriber and publication.
  • New charts: mssql.replication_subscriber_latency, mssql.replication_subscriber_agent_not_running, mssql.replication_subscriber_time_to_expiration.
  • Updates metadata to add “MSSQL Replication Subscriber” and rename “MSSQL Replication” to “MSSQL Replication Publisher.”
  • Allocates an ODBC statement handle for the distributor and wires collection into the replication loop.

• Refactors

  • Uses NETDATA_MSSQL_MASTER_DB constant for DB selection and adds NETDATA_REPLICATION_MONITOR_SUBSCRIPTION_QUERY.
  • Adds PRIO_MSSQL_SUBSCRIBER_LATENCY priority for subscriber charts.

^{Written for commit e5fd5ee. Summary will update automatically on new commits.}