The Mystery of Query Timeouts Video

“People are complaining about query timeouts. I don’t see anything happening in SQL Server, but they always say the database is the problem. How can I tell what’s really going on?”

When your users keep hitting timeouts in their application, they naturally think the database is killing off helpless queries. In this webinar Kendra Little will tell you how to triage treacherous timeout situations and collect hard evidence about whether or not the problem is in the database. Do the right detective work and you can turn your frustrated users and irate developers into raving fans.

This session is be 200-level – you should have familiarity with OLTP concepts and understand what DMVs and Profiler are, but you don’t have to be an expert with them.

Enjoyed the video? It’s part of our new Technology Triage Tuesdays, a free webcast series at 11:30AM Central every week.  Register for our next webcasts, and add a recurring calendar reminder.

Kendra Little

Kendra specializes in high availability and performance tuning. She is a Microsoft Certified Master in SQL Server-- the highest technical SQL Server Certification available. Kendra loves databases and software development more than long walks on the beach. Those cartoons in her blog posts? She draws 'em all. Read more and contact Kendra.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

7 Responses to The Mystery of Query Timeouts Video
  1. Sol Esguerra
    July 28, 2011 | 1:19 PM

    Very informative. Thanks Kendra!

  2. Craig Quillen
    July 28, 2011 | 1:25 PM

    The resources link is pointing to the notes for last week’s performance tips video.

    • Brent Ozar
      July 28, 2011 | 2:27 PM

      Craig – thanks! I removed that.

  3. Reghardt
    July 28, 2011 | 1:30 PM

    Kendra,
    I am a first time viewer of the website and wanted to say thanks for this totally awesome post. Even though none of the information was new to me it is nice to “put all the piece together” and show it in a well laid out and easy to follow plan. This will help me stay organized and ensure that I keep all the individual tasks in the proper order.
    Thanks,
    Reghardt
    MCITP Database Admin

  4. Christian
    July 29, 2011 | 3:36 PM

    Nice video Kendra!

  5. Andy Grant
    July 29, 2011 | 3:39 PM

    Great video Kendra. This is really good “evergreen content”, so you will be able to steer customers to this information over the long haul and they’ll get value from this – and the all powerful Google will steer peeps to it over a longer period of time. Your delivery is great!

    Cheers,
    Andy

  6. Deepak
    August 1, 2011 | 10:15 AM

    Kendra – Excellent video and thanks so much for making this one.

Leave a Reply

Wanting to leave an <em>phasis on your comment?

Notify me of followup comments via e-mail. You can also subscribe without commenting.