Comma separated list of system trace events. Call the sp_trace_events system procedure to obtain a list of system-defined
trace events. See sp_trace_events system procedure.
targets
target-type(target-option=value[ ;... ] ) where target-type can only be file.
The target file can have the following options:
Target option
Option value
filename_prefix
An ETD file name prefix with or without a path. All ETD files have the extension .etd. This parameter is required.
max_size
The maximum size of the file in bytes. The default is 0, which means there is no limit on the file size and it grows as long
as disk space is available. Once the specified size is reached, a new file is started.
num_files
The number of files where event tracing information is written, and it is used only if max_size is set. If all the files reach
the maximum specified size, the database server starts overwriting the oldest file.
flush_on_write
A value that controls whether disk buffers are flushed for each event that is logged. The values yes, true, no, and false
are accepted. The default is false. When this parameter is turned on, the performance of the database server may be reduced
if many trace events are being logged.
compressed
A value that controls compression of the ETD file to conserve disk space. The values on and off are accepted. The default
is off.
Server trace event sessions can be used to capture trace events related to system behavior or for a particular user. Server
trace event sessions are stored in memory and are dropped when the database server stops, if they have not been dropped explicitly.
Syntax