Five Query Plan Culprits That Cause 95% of Your Headaches - Adam Machanic

Ever open a huge query plan to track down a performance issue and find yourself overwhelmed by the number of objects on the screen? How do you figure out which part of the plan is causing the problem? What should you do about it? 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 you will learn how to open a plan and drill in to the most likely problem areas. Once there, a simple analysis of five key indicators will help you diagnose your performance problem faster than you thought possible. Say goodbye to guesswork and game playing. This session will teach you how easy it can be to apply a bit of logic to improve performance of your queries.

Adam Machanic is a Boston-based SQL Server developer, writer, and speaker. He focuses on large-scale data warehouse performance and development, and is author of the award-winning SQL Server monitoring stored procedure, sp_WhoIsActive. Adam has written for numerous web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including "SQL Server 2008 Internals" (Microsoft Press, 2009) and "Expert SQL Server 2005 Development" (Apress, 2007). Adam regularly speaks at conferences and training events on a variety of SQL Server topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, a Microsoft Certified IT Professional (MCITP), and an alumnus of the INETA North American Speakers Bureau.

Join or login to comment.

  • Stefan K.

    Adam, were you going to upload the slide deck? I was hoping to review it again.

    1 · March 28, 2014

  • Peter M.

    Detailed and low-level, yet not over this newbie's head. Thanks, Adam.

    February 13, 2014

  • Slava V.

    Every meeting I learn something new. Thanks!

    February 13, 2014

  • Vivek U.

    This was a great meet up. Valuable tips for optimizing queries.

    1 · February 13, 2014

  • salim

    Can someone share the queries used in the presentation ?

    February 13, 2014

  • Michael G.

    Another truly outstanding presentation. This one had some valuable real world 'rule of thumb' takeaways on the care and feeding of the query optimizer.

    February 13, 2014

  • Adam M.

    Thanks, everyone, for joining me last night!

    The demo scripts are posted in the downloads area.

    February 13, 2014

  • Christian H.

    Great very helpful, thanks

    February 13, 2014

  • Vladimir I.

    This was one of the best presentations on the topic that I have attended.

    February 13, 2014

  • Ofer T.

    Superb. Many thanks,

    February 13, 2014

  • Steven M.

    Excellant. Informative and immediately applicable.

    2 · February 13, 2014

  • Aldwin


    February 13, 2014

  • Lily S.

    Awesome. Succinct, very productive and simple to follow and retain the info. Adam Machanic presented the material very well w zero fluff.

    February 12, 2014

  • BassmanDBA

    Is there an online meeting option for this session or is this an onsite only event in MA?

    1 · February 7, 2014

    • Adam M.

      Road trip? :-)

      1 · February 7, 2014

    • Robert P.

      If you can't make this meetup, think about coming March 28th when Adam is going to do a pre-seminar for SQL Saturday 262. Then stay for Saturdays event as well.

      1 · February 7, 2014

  • Adam M.

    Microsoft has asked me to remind everyone to enter through the main Microsoft entrance, and that you must bring a photo ID.

    February 7, 2014

  • Robert P.

    We had to move the meeting from Thursday to Wednesday so please mark you calendar that the new date is Feb 12th!

    December 9, 2013

  • Robert P.

    All, please note that the RSVP question IS REQUIRED, even if you have your display name set to your full name, or if you've answered it previously. We need one place to track names, and we need your response every time you RSVP.

    October 12, 2013

Our Sponsors

  • actifio

    Copy Data Virtualization - slash cost, time, and complexity.

  • Reg Gate Software

    Ingeniously Simple Tools

  • Ntirety

    Total Data Experts

  • PASS

    Professional Association for SQL Server

People in this
Meetup are also in:

Create your own Meetup Group

Get started Learn more

Meetup has allowed me to meet people I wouldn't have met naturally - they're totally different than me.

Allison, started Women's Adventure Travel

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy