Export (0) Print
Expand All
0 out of 2 rated this helpful - Rate this topic

SQL Trace Terminology

The following terms describe the key concepts of SQL Trace.

Event

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.

Filter

Criteria that limit the events that are collected in a trace.

Trace file

A file created when a trace is saved.

Template

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.