SQL Server Query Plan Analysis: The 5 Culprits That Cause 95% of Your Performance Headaches

Play SQL Server Query Plan Analysis: The 5 Culprits That Cause 95% of Your Performance Headaches
Sign in to queue


Ever open a huge query plan to track down a performance issue and instead find yourself overwhelmed by the sheer number of objects on the screen? How do you figure out which part of the plan is causing the problem, and what should you do about it? The fact is that the vast majority of query plan troubles boil down to the same basic causes; solving them is simply a matter of knowing where to look. In this session, learn how to open a plan and immediately drill in to the most likely problem areas. Once there, a simple analysis of five key indicators—and no, index scan is not one of them—will help you diagnose your performance problem faster than you ever thought possible. Say goodbye to guesswork and game playing. This session teaches you how easy it can be to apply a bit of logic and quickly improve the performance of your queries.



Session Type:





Hilton L2 Ballrm A



Right click to download this episode

The Discussion

  • User profile image
    Grigory Bushuev

    Excellent speech! Educative and entertaining. I wish I had database scripts to test the demo. Where can I find them?

  • User profile image

    Probably the best talk on execution plans I have seen. Very informative, overwhelming but great stuff here.

Add Your 2 Cents