Collect information about currently running queries only when client timeout occurs

Asked Jan 02 '14 at 13:43

Active Jan 02 '14 at 13:43

Viewed 257 times

We would like to be able to collect information about all currently running queries when (and only when) a client timeout occurs in SQL Server 2008.

I know I can collect information about the client timeouts using the "Attention" Event Class in SQL Profiler.

And I know I can gather information about the currently run queries using sys.dm_exec_requests.

But how can I connect these two, i.e. query for all currently active queries only when an Attention Event Class appears?

Would this be possible using extended events (I have never used them, so am not sure about their capabilities)? Or rather some other mechanism?

Any help is appreciated.

asked Jan 02 '14 at 13:43

DotNetDeveloper

Have you looked at the blocked process report? It doesn't do exactly what you want but could well be what you actually need dependent on the motivation for the question. – Martin Smith Jan 02 '14 at 14:39
Attention is its own event in SQL Trace. Probably could set up a notification procedure like this – Martin Smith Jan 02 '14 at 14:48

0 Answers0