SQL Server Query Plan Analysis: The 5 Culprits That Cause 95% of Your Performance Headaches
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.