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.

Ważne:
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.

Zobacz także

Odwołanie

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)