Re: Similar question about Auto Startup Trace

From: Kalen Delaney (replies_at_public_newsgroups.com)
Date: 02/14/04 

Date: Sat, 14 Feb 2004 07:54:53 -0800

Please take a look at the script created. There is a place for you to
specify the file to write to. You cannot save to a table from a server side
trace.
AFTER you have tried this, and looked at the script created, feel free to
ask more questions. 

--
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Harry G" <anonymous@discussions.microsoft.com> wrote in message
news:107d501c3f30a$8dfe1f50$a601280a@phx.gbl...
> If I script the trace like this, when the trace auto
> started, it will auto write data to a file? because auto
> write to a table or file is must in my case.
>
> Thank you so much for your help,
> Harry
>
> >-----Original Message-----
> >You should uncheck 'save to table' based on your earlier
> posts. It should be
> >on the general definition page in the Profiler.
> >
> >--
> >HTH
> >----------------
> >Kalen Delaney
> >SQL Server MVP
> >www.SolidQualityLearning.com
> >
> >
> >"Harry G" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:1067901c3f2a3$c7525a80$a501280a@phx.gbl...
> >> Kalen, Would you please tell me which option I should
> >> uncheck it before I script the definition of the trace
> and
> >> where is it?
> >>
> >> Thanks you,
> >> Harry
> >> >-----Original Message-----
> >> >HI Harry
> >> >
> >> >The auto started trace should be writing to a file, so
> it
> >> is auto saved
> >> >there. You could create a job to stop the trace at
> >> regular intervals (every
> >> >hour?), close it, copy the file to a table, and the
> >> restart the trace.
> >> >
> >> >--
> >> >HTH
> >> >----------------
> >> >Kalen Delaney
> >> >SQL Server MVP
> >> >www.SolidQualityLearning.com
> >> >
> >> >
> >> >"Harry G" <anonymous@discussions.microsoft.com> wrote
> in
> >> message
> >> >news:100e101c3f26c$e576be20$a401280a@phx.gbl...
> >> >> Hi,
> >> >>
> >> >> After the trace auto startuped when SQL server
> startup,
> >> >> Is there any way to AUTO save the data into a table
> or
> >> >> AUTO save the data into a file? Any ideas?
> >> >>
> >> >> Thanks in Advance,
> >> >> Harry
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >

Relevant Pages

  • Re: Similar question about Auto Startup Trace
    ... If I script the trace like this, when the trace auto ... >Kalen Delaney ...
    (microsoft.public.sqlserver.tools)
  • Re: Similar question about Auto Startup Trace
    ... The auto started trace should be writing to a file, ... SQL Server MVP ... "Harry G" wrote in message ...
    (microsoft.public.sqlserver.tools)
  • Re: Similar question about Auto Startup Trace
    ... >HI Harry ... >The auto started trace should be writing to a file, ... >> After the trace auto startuped when SQL server startup, ...
    (microsoft.public.sqlserver.tools)
  • Re: Similar question about Auto Startup Trace
    ... Harry ... >Please take a look at the script created. ... >> If I script the trace like this, when the trace auto ...
    (microsoft.public.sqlserver.tools)
  • Re: LTT user input
    ... and to that end have taken the existing trace infrastructure ... script for that event (if there's a handler defined for the event ... This gives the script a chance to do whatever Perlish thing it ... syscall totals to individual syscall totals for each pid. ...
    (Linux-Kernel)