Last night I had the pleasure of presenting my session “Maintain SQL Server Performance Baseline with PowerShell” for the Quad Cities PASS Chapter. In that session I talk about the performance counters you should monitor, and why, and then how to gather that data using PowerShell so you can keep track of performance daily, and more easily find problems when they do, by comparing normal behavior to problem behavior. I discussed these counters in a blog post I did for SentryOne back in January, 2017.
Thank you to everyone that attended the session, and especially to Sheila Acker (t), who asked me to present, and Pat Phelan (b/t), who led the meeting last night. I’ve posted the slide deck and demo scripts here: Maintain SQL Server Performance Baseline with PowerShell.