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.