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.

||
|-|
|Applies to: SQL Server ( SQL Server 2008 through current version).|

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)