Hi,
I just found out from performance dashboard that there is an active trace
running. I have no idea when it is started. Is there a way to stop the trace?
Is the tracing part of the server background process that starts
automatically when you start the server?

Traces Report
© 2006-2007 Microsoft Corporation. All rights reserved. Dashboard Version:
1.0 (5 Max File Size
7/15/2009 10:44:40 PM
6/24/2009 10:46:41 PM
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log_78.trc
Trace ID 1
Configured Events...
Trace Buffers
Events Traced
Trace Buffer Size
Status
Max Files
Last Event
Stop Time


Pingx

That is the default trace and there is no reason to stop it - it is useful
for tracking a lot of information.

"Pingx" <Pingx (AT) discussions (DOT) microsoft.com> wrote

I agree with Jeffrey that the default trace can be useful for forensics and
you should keep it running. See the Books Online for details on how to
retrieve the data from the live file and how to enable/disable the trace.

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

"Pingx" <Pingx (AT) discussions (DOT) microsoft.com> wrote