Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The sys.traces catalog view contains the current running traces on the system. This view is intended as a replacement for the fn_trace_getinfo function.
For a complete list of supported trace events, see SQL Server Event Class Reference.
| Column name | Data type | Description |
|---|---|---|
id |
int |
Trace ID. |
status |
int |
Trace status: 0 = stopped 1 = running |
path |
nvarchar(260) |
Path of the trace file. This value is null when the trace is a rowset trace. |
max_size |
bigint |
Maximum trace file size limit in megabytes (MB). This value is null when the trace is a rowset trace. |
stop_time |
datetime |
Time to stop the running trace. |
max_files |
int |
Maximum number of rollover files. This value is null if the Max number is not set. |
is_rowset |
bit |
1 = rowset trace. |
is_rollover |
bit |
1 = rollover option is enabled. |
is_shutdown |
bit |
1 = shutdown option is enabled. |
is_default |
bit |
1 = default trace. |
buffer_count |
int |
Number of in-memory buffers used by the trace. |
buffer_size |
int |
Size of each buffer (KB). |
file_position |
bigint |
Last trace file position. This value is null when the trace is a rowset trace. |
reader_spid |
int |
Rowset trace reader session ID. This value is null when the trace is a file trace. |
start_time |
datetime |
Trace start time. |
last_event_time |
datetime |
Time the last event fired. |
event_count |
bigint |
Total number of events that occurred. |
dropped_event_count |
int |
Total number of events dropped. |
See Also
Reference
Object Catalog Views (Transact-SQL)
sys.trace_categories (Transact SQL)
sys.trace_columns (Transact SQL)
sys.trace_events (Transact SQL)
sys.trace_event_bindings (Transact SQL)
sys.trace_subclass_values (Transact SQL)