influxdata/telegraf

SQL Server plugin - Add metrics for database state

Open

#7149 opened on Mar 10, 2020

View on GitHub
 (1 comment) (0 reactions) (0 assignees)Go (9,892 stars) (4,161 forks)batch import
area/sqlserverfeathelp wantedsize/m

Description

Feature Request

Right now SQL Server plugin exposes only a total number of databases in pending/recovery/restoring/etc state. It would be nice to have a metric that reflects per-database state

Proposal:

Add metric that reflects state of each database (i.e online/offline/pending/etc)

Contributor guide

Tech stack
gosql
Domain
backendobservability
Issue type
feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
half day
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
stale
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
clear
Prerequisites
Go programmingTelegraf plugin developmentSQL Server basics
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
50
Research direction
The issue requests a new metric for per database state in the SQL Server plugin. Start by examining the existing metrics for database state in plugins/inputs/sqlserver/ (likely the sqlserver.go file). Understand how the current total number of databases in various states is collected. Check the issue comments for any additional guidance. Then implement a new gauge metric that tags with database name and state, following the plugin's metric naming conventions.