Trace Problem

[deepsheep]

Another interesting one, I think it is linked to my other problem too.

My one sql machine (same one I have problems with the counter in perfmon) apparantly has a trace running ont it. But I can't find what started it anywhere.

I found this thread with a soloution:

http://www.tek-tips.com/viewthread.cfm?qid=1198522

Is there any harm in killing the trace without knowing where it came from? Is there a recomended process to killing it? Can I find out where it came from?

Thanks!

 

[deepsheep]

Well, here is what I've learned for the next person.

My trace turns out to be the default trace. Here's a little information on it:

http://decipherinfosys.wordpress.com/2007/12/26/black-box-trace-in-sql-server-2000-and-2005/

The machine that didn't have the default trace running turned out to have something wrong (not too sure what yet). We had to reset it this morning and the trace is now running.