Query Tuning Telemetry for the Advanced SQL Developer

You are a skilled SQL developers who knows how to make your SQL statements scream with speed. But now you want to advance that skill by analyzing instance-wide performance and overall workload analysis. As it turns out, SQL Server includes a variety of Extended Events, DMVs, and other telemetry to help us. It’s just that few people know these secrets. We will examine this seldom used instrumentation through a variety of everyday queries to reveal their overall resource consumption and internal behavior. Lots of examples and demos!

Learn lesser known and undocumented methods of collecting query performance information, including reading internal query memo structures and the hidden trace flags needed.