Using Open Source Products to Collect Performance Metrics

Target Audience:

This presentation is for DBAs, sysadmins, and if you are brave managers.


Ever had a manager standing over your shoulder, wanting to know why an instance is running slow or if it can handle additional workload? What information would you use to answer these questions? If only you knew what performance metrics to collect and had them for your existing instances to answer these questions.

In this session, we will discuss sp_whoisactive and Query Store. Then we will be combining three open source tools – Telegraf, InfluxDB, and Grafana – into an inexpensive system that collects performance metrics you can use to troubleshoot issues and answer important questions about your SQL Server instances, including your Linux SQL Server instances. We will learn what metrics to collect, how to use the tools to collect performance metrics and then we’ll put it all together in an interactive dashboard for easy visualization.

Attendees will see how easy it is to get good performance data and visualize in an interactive way and combine with other tools to troubleshoot issues. For an example, we will combine this solution with Query Store and/or sp_whoisactive to find a problem that occurred on a system and caused me to get my nap interrupted on a Saturday.

Why I Want to Present This Session:

Because this solution for collecting performance data is really cool and not a lot people know about it. It goes across platform and collects data for multiple sources and it’s FREE!

Additional Resources:

Guide for Set Up of Telegraf for Monitoring SQL Server xPlat
The following two tabs change content below.
I am a Database Administrator for Broadvine. She has spent over 20 years in IT and has been using SQL Server since 1999 and is currently certified as a MCSE Data Platform. I cover all aspects of administration and deal heavily with performance tuning and disaster recovery. I a co-organizer of a Special Interest Group (SIG) dedicated to advanced database administration in our local user group TriPass. Before I worked full-time as a DBA I was formally a developer and network administrator. I also tinkered with databases in middle/high school to keep her sports card collection organized. I volunteer as a Guardian ad Litem in North Carolina advocating for abused and neglected foster children in court. This is my passion outside of SQL Server. The national organization for this program if you are interested is National CASA Organization.

Latest posts by Tracy Boggiano (see all)

Previous Post
Advanced Query Tuning Techniques
Next Post
The Problems With Optional Operators

1 Comment. Leave new

Ajay Dwivedi
April 4, 2019 10:07 am

Loved this session. I find this Grafana quite useful. Thanks for this session.


Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.