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!