| title | sys.traces (Transact-SQL) | ||||
|---|---|---|---|---|---|
| description | sys.traces (Transact-SQL) | ||||
| author | rwestMSFT | ||||
| ms.author | randolphwest | ||||
| ms.date | 03/14/2017 | ||||
| ms.service | sql | ||||
| ms.subservice | system-objects | ||||
| ms.topic | reference | ||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
[!INCLUDE SQL Server SQL MI]
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
[!INCLUDEssNoteDepFutureAvoid] 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. |
[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.
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)