Monitoring SQL Servers in the enterprise can be complex and it is difficult to get a real assessment of a single SQL Server instance and much more difficult to get the right performance health assessment from multiple servers in your enterprise.

Additionally, performance monitor counters aren't clear which ones to use and how to match these performance counters to DMV and wait statistics outputs.

In this session, we step way outside the box. We'll start with how Microsoft itself collects diagnostic data using SQL Log Scout, SQLdiag/PSSDIAG, and the PAL tool for threshold analysis these are the same tools CSS support engineers use when your escalation lands on their desk.

From there, we dive deep into PerfMon composite templates as deployable code, building your own custom performance counters using the SQL Server: User Settable Object counters, leveraging Resource Governor as a pure monitoring engine, automating alerting pipelines with PowerShell, and mining SQL Server's built-in black box - Ring Buffers and the always-on system_health session.

Every topic includes real demos and scripts you can take home and use Monday morning.

This is one of the sessions I can guarantee you will learn something new and valuable as we will be touching on some unique approaches and techniques for SQL Server performance monitoring.