SQL : View Running Trace Information
The following SQL can be used to identify any traces that are active on a SQL instance.
Use the query below to see how many running traces there are on the instance:
SELECT count(*) FROM :: fn_trace_getinfo(default) WHERE property = 5 and value = 1
| running |
| 1 |
The next query will return more detailed information about the active traces:
SELECT * FROM :: fn_trace_getinfo(default)
| traceid | property | value |
| 1 | 1 | 0 |
| 1 | 2 | c:\temp\TraceGlobal |
| 1 | 3 | 5 |
| 1 | 4 | 29:27.5 |
| 1 | 5 |
1 |
To halt the running trace use the fllowing query:
EXEC sp_trace_setstatus 1, @status = 0
To delete the trace definition from the database:
EXEC sp_trace_setstatus 1, @status = 2