I am having some problems setting up grafana with influxdb I am looking at setting up https://grafana.com/dashboards/409 I have installed influxdb on the grafana server, and I have followed this article: https://github.com/influxdata/telegraf/tree/master/plugins/inputs/sqlserver I have edited my …

in your telegraf config file, in the sql outputs section, you might change the query_type to 1 instead of 2…worked for me!

Hi, Yes user ID and password of the user you created earlier should be used in the connectionstring in telegraf. App name is a name that will be used when telegraf connecting to mssql. If you run a trace in mssql you’ll be able to see what specific application that’s executing queries in question. …

Thanks for the reply, I’m still having some issues. So i added the user to SQL, installed InfluxDb and telegraf on my grafana server (ubunto). In the telegraf.conf I then added the connection string: # Read metrics from Microsoft SQL Server # servers = [ # "Server=10.x.x.x;Port=1443;User Id=tele…

You have to remove the #-characters - they’re comments!

Well that makes too much sense doesnt it lol… So i’ve taken out the #'s and I’m still not seeing the instances show up in the grafana. Server1 = grafana/influxdb Server2 = MS SQL the connection string looks like vim telegraf.conf (added to the end of the file) # Read metrics from Microsoft …

When trying to start the telegraf service I see i’m getting: Error in plugin[inputs.sqlserver]: unable to open tcp connection with host SERVER2:1443: dial tcp SERVER2:1443: getsockopt: connection refused May be a networking issue then…although the firewalls seem to be off on that server (windows …

I’m not sure telegraf supports windows authentication - please start with validating this! Please note that you can start telegraf with just console output enabled (no data will be sent to influx) which can help you verify that telegraf at least can extract correct metrics. See telegraf console arg…

Hi I have this in the telegraf.conf (ip and pw are changed here): Read metrics from Microsoft SQL Server [[inputs.sqlserver]] Specify instances to monitor with a list of connection strings. All connection parameters are optional. By default, the host is localhost, listening on default port, TCP 1…

Have you verified that you get any data into influxdb? Maybe the dashboard is outdated? And as I wrote above: [image] anon34853223: Please note that you can start telegraf with just console output enabled (no data will be sent to influx) which can help you verify that telegraf at least can extr…

Please include example data queried directly from influxdb. Maybe dashboard is outdated and you’ll need to manually update it?

Setting up SQL Server Monitoring

Grafana InfluxDB

darkallien September 12, 2018, 5:56am 10

I’ve tested the data flow and from what i can see i get the data in Influx, but what the dashboard is looking for does not look to match what is there, do you know a working dashboard?

Topic		Replies	Views
Set Up Grafana on local	4	915	September 19, 2017
Monitoring Target Instance (SQL Server) - Not Found Grafana plugins , grafana-ui , telegraf , grafana	6	323	February 15, 2024
SQL Server Monitoring Dashboard - by Florian Kinder Configuration	0	674	March 10, 2019
SQL Monitoring DashBoard Grafana	0	1081	September 11, 2018
Unable to pull metrics into Grafana using InfluxDB and Telegraf Grafana	8	4979	September 10, 2018

Setting up SQL Server Monitoring

Related topics