Finding a Trace
Today a colleague kicked off a trace and went to a meeting. After a while, we noticed some performance issues. After looking at the processes running, I could see a trace was running. I had two options. I could kill the spid or I could stop the trace.
I decided to stop the trace. I had to first find the trace. To obtain this, ran:
SELECT * FROM master.sys.fn_trace_getinfo(null)
This displayed all of the traces currently running. TraceId 1 is SQL Server’s internal trace.
I saw a second trace, which I promptly stopped and closed by running:
EXEC master.dbo.sp_trace_setstatus @traceid = 2, @status = 2
Performance immediately returned to normal.