The Tiger Team presented another session in PASS Virtual Conference: DBA Fundamentals Chapter on SQL Server Performance Baselining and Monitoring yesterday. The details of the session, links for slides and demos are mentioned below
When managing large scale deployment of SQL Server instances, it is important for DBAs to setup proactive monitoring & establishing performance baselines which helps in performance tuning, capacity planning, virtualization and migration to cloud. In this session, we demonstrate a SQL Performance Baselining and Monitoring solution leveraging out of the box tools viz system_health XEvents sessions, perfmon, powershell and SSRS to monitor large scale deployment of SQL Server instances.
Senior Program Manager (@talktosavjani)