Over the years, SQL Server has started collecting more awesome metrics about your queries and plans.

Summarize new metrics added since 2012-ish

Understand how to query the right DMVs to gather them

Use them to find query problems and work towards solving them

In the old days, query tuning used to be really hard. 

If you weren't sitting there hitting F5 or invested in an expensive monitoring tool, it was pretty tough to catch performance problems in the act. 

Between existing DMVs, Query Store, and execution plan details, query tuning today is easier than ever.

In this session, I'm going to teach you survival skills you'll need to become a better query tuner, and understand complex problems.

The video is not available to view online.