The below metrics are obtained in the output file of telegraf (query_version 1) but are missing in the version (query_version 2):
Database stats
Database io
Database size
Memory clerk
OS volume
Wait stats
System info:
telegraf version : 1.10.0
sqlserver : win 2012R2
prometheus database
Relevant telegraf.conf:
[[inputs.sqlserver]]
servers = [“Server=localhost;Port=1433;User Id=telegraf;Password=Mystrongpassword@01;app name=telegraf;log=1;”,]
query_version = 2
How to get these metrics using the latest version of telegraf (query_version 2)?