sys.traces (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

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)