Query Store and the DMVs tell you what is slow on average — and the tickets on your desk are never average.

This 75-minute session takes three real tickets and closes each one with evidence pulled straight off the server: the actual plan of one bad execution, the parameters that were really passed in, the queries behind a wait type, and the query quietly starving everyone else of memory.

Presented live at SQL Server Bootcamp 2026 on 4 September 2026