Re: Problem using SP_TRACE_SETFILTER - it doesn't seem to apply th

From: Wanderer (Wanderer_at_discussions.microsoft.com)
Date: 01/04/05


Date: Mon, 3 Jan 2005 23:11:03 -0800

Hi David,

Using that SP I created, and then fixed :-), I basically run a server side
trace to file. Then I copy the file to another machine, where I do my
analysis.

When opening that trace file, in Profiler, and going to the properties of
the trace, I definitely see my filter.

HTH

"David Gugick" wrote:

> Wanderer wrote:
> > OH, btw,
> >
> > I found that after properly creating those filters, when I open the
> > trace file created by my SP, in profiler, I DO see the filters under
> > the properties tab for the trace.
> >
> > Just FYI
> >
>
> Strange. I don't see them on some test traces I just ran. Are you saying
> that you run a server-side trace, stop the trace, open the trace file in
> Profiler, and then see the trace filters? I can't see it here using that
> method.
>
> Any verification appreciated.
>
> Thanks
>
>
> --
> David Gugick
>
>



Relevant Pages

  • Re: Running profiler on busy 8-cpu Sql Server
    ... I always start with a light trace and add more detail as I go along to ... SQL Server MVP ... > I think it's also worth saying that you should introduce Profiler ... > SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: URGENT deadlock question
    ... > Profiler to view a trace, SQL Server dumps rowsets across the network to ... > SQL Server doesn't feel like it can keep up with all the activity. ... > server-side trace to a trace file guarantees you'll see everything. ...
    (microsoft.public.sqlserver.server)
  • Re: URGENT deadlock question
    ... >> network to the Profiler client, but there is no guarantee you'll see ... >> everything if SQL Server doesn't feel like it can keep up with all ... Just make sure the trace file is created on a local ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 7 Traces
    ... Profiler 2K can generate the xp calls for a defined trace in 7 format. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Per databse CPU usage
    ... You might want to use a server-side trace instead of Profiler if you're ... SQL Server MVP ... > We are experiencing CPU performance issues, some requests just> take all the CPU for 10 to 20 seconds. ...
    (microsoft.public.sqlserver.server)