Collecting Performance Metrics
Database Administration, Performance Tuning Optimization, and DevOps
Have you ever had a manager standing over your shoulder, wanting to know why a server is running slowly? Or if a server can handle additional workload? What information would you use to answer these questions? How would you share this information with your manager? If only you had performance metrics from your existing servers to answer these questions.
In this session, 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 and answer important questions about your SQL Server instances, including your SQL Server on Linux instances. We will learn what data to collect, how to use the tools mentioned to collect that data and then we'll put it all together in an interactive dashboard for easy visualization.