Using Open Source Software to Collect Performance Metrics

Discover how to effectively collect and visualize performance metrics for SQL Server instances using open-source tools in this comprehensive conference talk. Learn to leverage sp_whoisactive and Query Store for tracking running queries, then explore the powerful combination of Telegraf, InfluxDB, and Grafana to create an affordable and user-friendly system for gathering crucial performance data. Gain insights into troubleshooting techniques for SQL Server instances, including Linux deployments, Azure Managed Instances, and Azure SQL Databases. Follow along as the speaker demonstrates the ease of obtaining valuable performance information, creating interactive visualizations, and integrating with other tools to resolve issues. Conclude with a real-world example showcasing how this solution solved a specific problem, equipping you with practical knowledge to enhance your database management skills.

Using Open Source Software to Collect Performance Metrics - Tracy Boggiano