ASTrace 2012 mutiple tdf

Jul 4, 2014 at 10:13 AM
I would like to run multiple tdf with ASTrace. The reason is to have one trace logging Big queries > 1sec and the other logging all queries (<1sec) both can’t be put into one tracefile without producing lots of log entries.

I tried to install AStrace twice as a service but I wasn't successful with that.

Any ideas on how run multiple traces is appreciated
Coordinator
Jul 4, 2014 at 8:27 PM
I don't think this is possible without downloading the source code from the Source Code tab and customizing it.

I'm not clear how the >1 sec trace will work. You will only get the Query End event not the Query Begin event. That means you won't get the parameters. I guess if you don't have any parameterized queries that's no problem.

My suggestion would be to log all queries with one trace then put a view over the top to filter to slow queries.
Jul 6, 2014 at 8:30 PM
Thanks for your quick reply. I will look into customizing the source code.