[ASK] telegraf, influx, sql server correct setup

telegraf
influxdb

#1

hi, i’m trying to understand this grafana dashboard grafana.*com/dashboards/409 but i ended up with bit confuse bout the topology and/or requirement.

here’s my experiment progress :

  • i prepared 2 dummy VM on my PC , the 1st one is used for ubuntu grafana-server , and the 2nd is for window SQL server (key, installed, done) with that dashboard 409 things
  • then i install influxdb on ubuntu, ok done i created a database telegraf
  • i jumped into windows machine, i downloaded this telegraf nightly build _https://dl.influxdata.com/telegraf/nightlies/telegraf-nightly_windows_amd64.zip
  • i created sql server login too
  • nah, what https://github.com/influxdata/telegraf/tree/master/plugins/inputs/sqlserver <— this link used for? it didn’t explain what next to do. and what this ‘sqlserver.go’ things?
  • i run the telegraf.exe via cmd and the grafana dashboard still didn’t show any progress, the netstat on linux it just fine, they’re listening established each other, telnet connected 1433 and 8086

here’s my another reference http://www.sqlservercentral.com/blogs/database-superheros-blog/2018/02/24/guide-for-set-up-of-telegraf-for-monitoring-sql-server-xplat/

and it failed (for me)

correct me if i’m wrong :disappointed:, thx in advance


#2

Hello Andrypein,

Did you find a solution with this? I ask because I am trying to get the same dashboard to work and it looks like I can get some data but not all of it.

Thanks,
Scott