The Mystery of Query Timeouts by Kendra Little – YouTube
“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.