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.

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

In SQL Server 2005 and later versions, 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.