SQL server monitoring - agent install guide

Please read the prerequisites Prerequisites - data collectorsPreview

Download and install Influx Telegraf. Influx Telegraf is one of the most used open source agents to collect metrics from sensors and systems. See https://www.influxdata.com/time-series-platform/telegraf/ for more information. Make sure you download the version corresponding to your OS.

Download the eyer_telegraf_sql.conf configuration file from Eyer.

Open the eyer_telegraf_server.conf file and navigate to the “outputs.http” section. Insert your Eyer apiTokenPush in the “authenticate” line as seen below

Navigate to the “inputs.sqlserver” section. You need to configure how you want to connect to the SQL server.

1. The config is pre-configured with integrated security (second line in the “servers=[ ]” section). If you want to disable this and use another method, please comment out this line with a “#”.

2. If you want to use SQL authentication, uncomment the first line in the “servers = [ ]” section and modify the ip / user / password.

3. For more details and options, see https://github.com/microsoft/go-mssqldb

Save the config.

Register the Telegraf agent as a service and start it(see instructions per OS). With Windows use