ListenerState status in MSSQL Server

bala_rocky · November 18, 2021, 6:04pm

Hi,

How to check ListenerState status in MSSQL server using telegraf plugin,
I tried the below code in primary and secondary setup servers, enabled always on option. too, but not able to get the ListenerState value
Please check and let us know the steps.

[[inputs.sqlserver]]
servers = [“Server=localhost;Port=1001;User Id=telegraf;Password=pass1234;app name=telegraf;log=1;”]
database_type = “SQLServer”
query_version = 2
include_query = [“SQLServerAvailabilityReplicaStates”,“SQLServerDatabaseReplicaStates”

Giovanni_Luisotto · November 19, 2021, 10:47am

Hi

you can’t change the behavior of the SQL Server plugin “as you wish”, behind it there is a fixed query that fetches some data. If that column is not gathered you can’t really change that “out of the box”.

If you need more you can:

open a feature request on Github, or make a PR yourself
do the changes you need and make your own build of Telegraf.

I suggest you have a look at the queries behind telegraf, you can find them here:

github.com

influxdata/telegraf/blob/master/plugins/inputs/sqlserver/sqlqueriesV2.go

//nolint:lll // conditionally long lines allowed
package sqlserver

import (
	_ "github.com/denisenkom/go-mssqldb" // go-mssqldb initialization
)

// Queries - V2
// Thanks Bob Ward (http://aka.ms/bobwardms)
// and the folks at Stack Overflow
// (https://github.com/opserver/Opserver/blob/9c89c7e9936b58ad237b30e6f4cc6cd59c406889/Opserver.Core/Data/SQL/SQLInstance.Memory.cs)
// for putting most of the memory clerk definitions online!
/*
The SQL scripts use a series of IF and CASE statemens to choose the correct query based on edition and version of SQL Server, below the meaning of the numbers:
EngineEdition:
1 = Personal or Desktop Engine (Not available in SQL Server 2005 (9.x) and later versions.)
2 = Standard (This is returned for Standard, Web, and Business Intelligence.)
3 = Enterprise (This is returned for Evaluation, Developer, and Enterprise editions.)
4 = Express (This is returned for Express, Express with Tools, and Express with Advanced Services)
5 = SQL Database

This file has been truncated. show original

Topic		Replies	Views
Execute SQL Query using Telegraf plugin for MSSQL Server Telegraf	4	3077	May 16, 2023
Having Problems with MSSQL Plugins for Telegraf Telegraf	2	578	October 12, 2022
Get sql connection status using telegraf plugin Telegraf	1	375	November 19, 2021
SQL Server Input Plugin - missing IO data Telegraf	4	905	December 6, 2019
Not getting data for "Memory Clerk", "Database size", "Database latency" , "OS Volume", "CPU" in SQL server using telegraf Telegraf telegraf	3	728	May 28, 2019

ListenerState status in MSSQL Server

Related topics