I have this scenario, i would like to monitor all our Microsoft sql databases in our setup using Telegraf. I dont want to install telegraf agent in every server, i want to collect SQL database metrics remotely from a single location. What is the challenge? If you use the default setup, telegraf will not tag the remote hostname in its metric, it will use our telegraf hostname. That means you can’t tell the difference between databases .

Solution ? i found out that we can add additional tags in the configure
[inputs.sqlserver.tags]

If you use this configure, you will see this tag “sql_db_remote_host” in the metrics.