Baselining and Alerting for Microsoft SQL Server

YouTube·PASS Data Community Summit

Learn techniques and procedures for monitoring crucial performance metrics to establish a baseline for "normal" performance in Microsoft SQL Server in this 58-minute conference talk. Explore the differences between baselines and benchmarks, understand the importance of service monitoring, and discover the goals of baselining. Delve into the performance tuning lifecycle, necessary preparations, and key metrics to capture for SQL Server, virtualization, processors, and storage area networks. Gain insights on implementing baselines effectively and using PerfMon data with queries. Master the art of baselining and alerting to optimize your SQL Server performance.