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
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.