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

Name: Telegraf/InfluxDB/Grafana(TICK) for Monitoring SQL Server
Rating: 3.4 (268 reviews)

Learn how to build a dashboard to monitor SQL Server.Basics of Telegraf,InfluxDB,Grafana/Chronograf & Kapacitor

Created bySreejith R

Last updated 11/2020

English

English [Auto],

What you'll learn

Students will be able to set up a SQL server monitoring dashboard using TICK stack by themselves.
Students will able to set up monitoring of other server systems/systems.
Students will learn about Telegraf,InfluxDB,Chronograf and kapacitor.

Course content

6 sections • 24 lectures • 1h 56m total length

Introduction2:21
This is just an introduction to the course.You can see a sample dashboard.
What you are going to learn?0:56
Explore the tick stack architecture and its components—Telegraaf agent, Influx DB, Chronograph UI, and CAPACITOR processing engine—and learn to set alerts in the SQL Server Monitoring Dashboard.
Why monitoring?1:33

What is TICK Stack?2:48
T for Telegraf3:42
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.
I for InfluxDB3:10
C for Chronograf2:06
K for Kapacitor2:39
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.
TICK Components

Setting up InfluxDB Part 12:07
This lecture shows how to download,install and configure InfluxDB in windows system.
Setting up InfluxDB Part 21:10
Setting up Kapacitor2:46
Setting up Telegraf Part 18:44
This lecture will show download,install and configuring input and output plugin for telegraf in a windows system.
Telegraf input is configured with SQL server and Windows performance metrics.
Setting up Telegraf Part 23:31
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.
Setting up Chronograf4:42
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.

Prebuilt Dashboards in chronograf3:25
Creating a dashboard part 19:20
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.
Creating a dashboard part 27:05
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.
Creating a dashboard part 321:17
Exporting and Importing dashboard6:42
Creating Alert : Configure Kapacitor & Alert Handlers9:28

Requirements

Basic database/server knowledge is useful
For demos,windows OS is used,same method for other OS too.

Description

If you want to store and monitor your systems metrics or server/application metrics for performance,you should learn this course.TICK tack is the open source and it has a huge support and it supports collection of data/metrics from 200+ popular services/app/server like SQL server,mysql,apache,system etc.

Most of the companies now a days use some kind of monitoring to keep track of production systems.In this course i will be demonstrating how to set up a monitoring dashboard to keep track of SQL Database server metrics.

If you have some other systems to monitor, not SQL server ,i will be demonstrating how to configure/collect metrics/data from other systems as well.This course is super easy and i have tried my best to explain the concepts clearly.You don't need to be technical to learn this course.I am sure this course will be an added advantage to your resume.

Who this course is for:

Anyone who has basic database knowledge can take this course but not required.
Beginner SQL developers or Junior DBA's or anyone who is interested in databases.

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

What you'll learn

Explore related topics

Course content

Introduction3 lectures • 5min

TICK Stack5 lectures • 14min

Setting Up TICK Stack Components6 lectures • 23min

Inside Chronograf3 lectures • 10min

Building a Dashboard6 lectures • 57min

Other settings1 lecture • 6min

Requirements

Description

Who this course is for: