Dive deep into real-world tuning techniques, how to analyze query performance, and advanced Extended Events usage. You'll learn about high level procedure performance looking at the DMV,s and what my specific queries might help you identify as pain points.
We will cover how to use extended events to capture things like specific procedure parameters, as well as a few other techniques for capturing measure related to performance or deadlocks.
Then, we'll start with the top things I look for in a static code review, before I ever look at the execution plan. Those spot checks often find things that make a working procedure work substantially faster.
Next, we will go over some real world execution plan examples, what they show us, and how to fix them. You’ll see the basics like seek vs scan, sure, but what do things like key lookups, lazy table spool operators, and other things mean for you to review.
We will finish with the code I use every day for finding missing indexes, which is very dense data wise, but once you start using it, you’ll be a DBA Superhero.
