SQL Trace Terminology
The following terms describe the key concepts of SQL Trace.
The occurrence of an action within an instance of the Microsoft SQL Server Database Engine.
- Data column
An attribute of an event.
- Event class
A type of event that can be traced. The event class contains all of the data columns that can be reported by an event.
- Event category
A group of related event classes.
- Trace (noun)
A collection of events and data returned by the Database Engine.
- Trace (verb)
To collect and monitor events in an instance of SQL Server.
A collection of event classes, data columns and filters that identify the types of events to be collected during a trace.
Criteria that limit the events that are collected in a trace.
- Trace file
A file created when a trace is saved.
In SQL Server Profiler, a file that defines the event classes and data columns to be collected in a trace.
- Trace table
In SQL Server Profiler, a table that is created when a trace is saved to a table.