Query Logging

Question

Is there an easy way to log multiple queries at a time but not ALL the queries?

The two ways of logging I know are to log one query from the EventFlowDebugger, the other is to log ALL queries using the 'trace start' command.

There is a kludge, which is to open multiple event flow debuggers and record one query in each, but that is not ideal when wanting to record several queries.

The reason I am asking is that we have many dozens of queries and I maybe want to record 5 to 10 over a several hour run.  We are executing at a high rate so the resulting ETW file with all queries in it is in the several hundred GB range which makes opening it in the event flow debugger difficult to debug.

Ideally it would be nice to capture everything then only open a few of the queries/published streams in the debugger.

Any help would be appreciated.

Dave

Answer 1

Not that I'm aware of though it's a great suggestion. I would recommend that you place it in Microsoft Connect and let the team know.

I did do some digging around in the API and if theres a way to do it, I wasn't able to find it. The debugger classes are all internal/private.

---

DevBiker (aka J Sawyer)
Microsoft MVP - Sql Server (StreamInsight)

---

---

If I answered your question, please mark as answer.
If my post was helpful, please mark as helpful.