sqlserver.input less tag counter values

[LuisMuGo]

Please direct all support questsions to slack or the forums. Thank you.

I'm ussing a simple sqlserver.input config for recolecting metrics like that:

[[inputs.sqlserver]]
     servers = [
                 "Server=xxxx;Port=xxxx;app name=telegraf;log=1;",

               ]
     query_version = 2
     exclude_query = [ 'Schedulers' , 'SqlRequests']
     database_type = "SQLServer"

The normal counter values that I have received are: Active Temp Tables, Active Transactions, Active memory grant amount (KB), Average Latch Wait Time (ms), Background writer pages/sec, Backup/Restore Throughput/sec, Batch Requests/sec, Batches >=000000ms & <000001ms, Batches >=000001ms & <000002ms, Batches >=000002ms & <000005ms, Batches >=000005ms & <000010ms, Batches >=000010ms & <000020ms, Batches >=000020ms & <000050ms, Blocked tasks, Buffer cache hit ratio, Bytes Received from Replica/sec, Bytes Sent to Replica/sec, Bytes Sent to Transport/sec, CPU Limit Violation Count, CPU Usage (time), CPU usage %, Checkpoint pages/sec, DTC calls, Data File(s) Size (KB), Database Cache Memory (KB), Database pages, Disk Read Bytes/sec, Disk Read IO Throttled/sec, Flow Control Time (ms/sec), Flow Control/sec, Forwarded Records/sec, Free Memory (KB), Free Space in tempdb (KB), Free list stalls/sec , Memory Grants Pending, Memory broker clerk size, Mirrored Write Transactions/sec, Number of Deadlocks/sec and much more.

The problem is in some host the only counters tag values that we recolect are: CPU Limit Violation Count, CPU Usage (time), Lock Wait Count, Lock Wait Time, Queued Request Count, Reduced Memory Grant Count, Request Count

We use a big amount of counters data so is important for us to solve this problem.

Thank you!

[telegraf-tiger[bot]]

Hello! I recommend posting this question in our Community Slack or Community Forums, we have a lot of talented community members there who could help answer your question more quickly. You can also learn more about Telegraf by enrolling at InfluxDB University for free!

Heads up, this issue will be automatically closed after 7 days of inactivity. Thank you!

[telegraf-tiger[bot]]

Hello! I am closing this issue due to inactivity. I hope you were able to resolve your problem, if not please try posting this question in our Community Slack or Community Forums or provide additional details in this issue and reqeust that it be re-opened. Thank you!