Re: automating profiler

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 06/17/04 

Date: Thu, 17 Jun 2004 11:37:18 -0400

Not that I am aware of. 

-- 
Andrew J. Kelly  SQL MVP
"Jo" <Jo@discussions.microsoft.com> wrote in message
news:DC0B3779-1875-40D4-848B-31473782A038@microsoft.com...
> Is there a SQL 7.0 soluthion?
>
> "Andrew J. Kelly" wrote:
>
> > Sure, take a look at fn_trace_gettable in BOL.  By the way you almost
never
> > want to trace directly to a table if you care about performance.
> >
> > -- 
> > Andrew J. Kelly  SQL MVP
> >
> >
> > "Jo" <Jo@discussions.microsoft.com> wrote in message
> > news:75FFDF10-B0AA-4AD4-8573-0A241F630717@microsoft.com...
> > > I have created a stored proc that will automate the capture of traces.
The
> > trace is captured to a file instead of a table because tracing to a
table on
> > the same server has caused performance issues.
> > >
> > > The problem is that I really want the trace in a table so that we can
> > produce reports with Reporting Services. I know that I can manually save
the
> > trace to a trace table. But is there a way to automate this process? I
can't
> > find any command line parameters for Profiler.
> > >
> > >
> > >
> >
> >
> >

Relevant Pages

  • Re: Log Reader
    ... Andrew J. Kelly SQL MVP ... >> though you may be runing the script from QA on your machine the trace ... >> Andrew J. Kelly SQL MVP ... >>> comand to stop and clear the trace and re run the commands and it say ...
    (microsoft.public.sqlserver.programming)
  • Re: How to display the command text when a long transaction is on proc
    ... The only way to see what line is actually executing is to start a trace ... beforehand with stmt:starting event. ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL profiler question
    ... Trace to a file and then use fn_trace_gettable to ... > Andrew J. Kelly SQL MVP ... >> I started a trace that loads a table. ...
    (microsoft.public.sqlserver.tools)
  • Re: SQL profiler question
    ... I created the trace to load a file. ... "Andrew J. Kelly" wrote: ... > Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.tools)
  • Re: 2005 Std Edition Installed, but not running
    ... Configuration Manager? ... Andrew J. Kelly SQL MVP ... with it do, reporting services, etc. ...
    (microsoft.public.sqlserver.setup)