2.2 Lab 3 Solution: Watch Brent Work Through It (55m)

In a one-hour hustle, when you’re only allowed to tune queries, things are going to move fast. Brent shows how he uses sp_BlitzFirst to identify the SQL Server’s top bottleneck, then uses sp_BlitzCache’s @SortOrder parameter to find the queries causing those waits. He steps through two suspiciously high-resource-utilization queries, tries to fix them, and then…