Using Open Source Products To Collect Performance Metrics By Tracy Boggiano GroupBy

Content provided by Brent Ozar. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Brent Ozar or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.

GroupBy – Free SQL Server Training »
Using Open Source Products to Collect Performance Metrics by Tracy Boggiano

5+ y ago 56:55

MP3•Episode home

Archived series ("Inactive feed" status)

When? This feed was archived on January 29, 2020 15:10 (4+ y ago). Last successful fetch was on October 18, 2019 15:18 (5y ago)

Why? Inactive feed status. Our servers were unable to retrieve a valid podcast feed for a sustained period.

What now? You might be able to find a more up-to-date version using the search function. This series will no longer be checked for updates. If you believe this to be in error, please check if the publisher's feed link below is valid and contact support to request the feed be restored or if you have any other concerns about this.

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.

Get full session notes here: https://groupby.org/conference-session-abstracts/using-open-source-products-to-collect-performance-metrics/

74 episodes

#Prog Languages #Science #Database #Sqlserver #Training #Brent Ozar #Tech #Podcasting Education #Communities #Development