On Wednesday 13th of February 2019 at 18:00 at Incrementals Office
5th Floor The Garment Factory 10 Montrose Street we have the privilege of Tracy Boggiano speaking remotely to our user group. Below is a summary of the session.
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.
Interested in attending this session sign up at our meetup page.
Tracy is a Database Superhero. She has spent over 20 years in IT and has used SQL Server since 1999. She is works at FM:Systems. Tracy is a also co-organizer of a Special Interest Group (SIG) dedicated to advanced DBA topics in our local user group TriPass. In addition, she is also the founder of http://WeSpeakLinux.com. Before she worked full-time as a DBA, she was formally a developer and network administrator. She also tinkered with databases in middle/high school to keep her sports card collection organized.