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.
Overview
Syllabus
Intro
Four Takeaways
Baseline Versus Benchmark
The Importance of Service Monitoring
Goal of the Baseline
Maturity Model
Performance Tuning Lifecycle
Preparation and prerequisites
What To Capture?
What SQL Server Metrics to Capture?
What Virtualisation Metrics to Capture?
What Processor Metrics to Capture?
SAN Considerations
What SQL Server Activity Metrics Should I Capture?
Getting PerfMon Data with a Query
After Testing?
Summary - Implementing Baselines
Taught by
PASS Data Community Summit
