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

Download this episode

Download Video

Description

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.
For more information, check out this course on Microsoft Virtual Academy:

Day:

3

Session Type:

Breakout

Code:

DBI-B489

Room:

Hilton L2 Ballrm A

Embed

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to send us feedback you can Contact Us.