Telegraf/InfluxDB/Grafana(TICK) for Monitoring SQL Server

Discover how Telegraaf, a lightweight, Go-based, plugin-driven collection agent, captures time series data from a SQL Server and outputs it to InfluxDB via a configurable plugin setup on GitHub.

Explore how Telegraf outputs time series data to InfluxDB, the high performance time series database. Query data with the InfluxDB CLI or chronograph UI to visualize dashboards.

Learn to use chronograph for building and visualizing dashboards in the tick stack, with templates and custom visualizations like line and stack graphs, plus an influx db interface.

Explore capacitor as the real-time data processor in the tic-tac architecture, and learn to set alerts for cpu usage and connections via chronograph interface with email or slack notifications.

Set up InfluxDB part 2 by launching the time series database from the Windows package. Start InfluxDB with default config, and run it as administrator or as a Windows service.

Set up capacitor, the data processing component, on Windows by downloading, extracting, and running capacitor.exe with default settings to enable data processing and alerts, listening on port 9092.

Set up a telegraf login on the SQL Server, configure credentials in the telegraf config, and start telegraf to store metrics in the InfluxDB Telegraaf database via chronograph.

Download latest stable chronograph for Windows, install and run as administrator, then access localhost:88 to configure the InfluxDB connection in the configuration tab using the Telegraph database and port 1886.

Explore chronograph's dashboard and alert sections, create dashboards, import or export them in JSON, prepare to connect capacitor and write alert rules.

Explore the influxdb admin and configuration tabs to manage databases, users, and queries, create databases for telegraf data, and configure data sources, capacitor, and alerts for chronograph.

Explore the pre-built dashboards in chronograf, showing host-specific system metrics collected by the telegraf agent with Windows performance counters and SQL Server inputs.

Create a dashboard in chronograph by adding cells, selecting data, and building queries against the Telegraf–fed InfluxDB to monitor memory metrics. Explore memory-related metrics such as SQL Server memory, cache memory, and optimizer memory, and tailor visualizations with line graphs, legends, and aliases.

Continue building the SQL Server dashboard by exploring chronograph visualizations. Create insights with line graphs, stacked graphs, bar charts, and single stat or gauge controls for time-series metrics.

Build a SQL Server health dashboard by adding memory and activity metrics, such as memory manager metrics and SQL Server activities, with visualizations to help DBAs debug and optimize queries.