question

David Wimbush avatar image
David Wimbush asked

How can I monitor timeouts?

Does anyone know if there's a way to monitor for queries that time out, please? It seems to me a pretty fundamental performance indicator. You can navel gaze all day about PerfMon counters but if you suddenly start getting lots of timeouts you have a real problem. Ideally, I'd like to be able to log or query timeouts: at least when it happened and what the query was. An ideas, please? (We're using a mixture of SQL 2008 R2 and SQL 2012.)
timeout
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Cyborg avatar image
Cyborg answered
Extended events is best for this situation, its very light weight compare to profiler and others. Found an article about similar topic [here][1] [1]: http://www.dbfriend.net/2011/04/capturing-time-out-procedures-using.html
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

David Wimbush avatar image David Wimbush commented ·
Thanks, Cyborg. I suppose timeout is really a feature of the client data access library than of SQL Server itself, so there's probably not much more we can do.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.