I'm wanting to create some standard diagnostics scripts for SQL Server 2005 installations and sqldiag seems the most logical way to do this.
However, I want to be able to add filters to ProfilerCollector so that I can capture data for a specific database, application, etc.
I've searched but can not find any information on either adding filters - which I suspect that you can not do - or specifying filters by using the template attribute. However, Profiler itself does not seem to export templates as .xml which is the format
of the default file specified for the template attribute!
Does anyone know if adding filters is possible, by whatever mechanism, and if so does anyone have any examples? It would be very much appreciated.
thanks, and regards
View Complete Post