sys.traces (Transact-SQL)
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.
Important
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use Extended Event catalog views instead.
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. |
Permissions
The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.
See Also
Reference
Object Catalog Views (Transact-SQL)
sys.trace_categories (Transact-SQL)
sys.trace_columns (Transact-SQL)
sys.trace_events (Transact-SQL)