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 or SQL Server 2005 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.
- Trace definition
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.