Microsoft.SqlServer.Management.Trace Namespace

The Microsoft.SqlServer.Management.Trace namespace contains the SQL Server Trace and Replay objects.

Classes

ReplayEventArgs

The ReplayEventArgs object provides programmatic access to the arguments used to report events that occur when replaying trace on an instance of SQL Server.

SqlTraceException

The SqlTraceException class represents the general exception raised by the SMO trace objects.

SqlTraceFailToInstantiateTypeException

The SqlTraceFailToInstantiateTypeException class represents the exception raised when an SMO trace object operation fails to instantiate an object.

SqlTraceFailToLoadInstAPIAssemblyException

The SqlTraceFailToLoadInstAPIAssemblyException class represents the exception raised by the SMO trace objects when an Inst API assembly fails to load.

TraceEventArgs

The TraceEventArgs object provides programmatic access to the arguments used to report events that occur when collecting trace from an instance of SQL Server.

TraceFile

The TraceFile class is a Trace object that represents a trace log file.

TraceReader

The TraceReader class is an abstract Trace Object class that is used in the construction of the TraceServer class, the TraceTable class, and the TraceFile class.

TraceReaderWriter

The TraceReaderWriter class is an abstract Trace Objects class that is used in the construction of the TraceTable class and the TraceFile class.

TraceReplay

The TraceReplay object is a Replay object that represents the replay operation for trace log files and trace tables.

TraceReplayOptions

The TraceReplayOptions object is a Replay object that represents the configuration settings required when replaying a trace.

TraceServer

The TraceServer class is a Trace object that represents a new trace on an instance of SQL Server.

TraceTable

The TraceTable class is a Trace object that represents a table of trace information.

Interfaces

IDataRecordChanger

The IDataRecordChanger object is a Trace and Replay object that represents the current record.

ITraceDataWriter

The ITraceDataWriter object provides programmatic access to the data writer for the SQL Trace.

Enums

ReplayMode

The ReplayMode enumeration contains values that are used to specify the type of synchronization used during the trace replay.

Delegates

ReplayEventHandler

Represents the ReplayEventHandler event handler.

ReplayPauseHandler

Represents the ReplayPauseHandler event handler.

ReplayResultEventHandler

Represents the ReplayResultEventHandler event handler.

ReplayStartHandler

Represents the ReplayStartHandler event handler.

ReplayStopHandler

Represents the ReplayStopHandler event handler.

WriteNotifyEventHandler

Represents the WriteNotifyEventHandler handler.

Remarks

The Microsoft.SqlServer.Management.Trace provides an interface for reading trace data from files, tables, or rowsets.

The Trace and Replay objects can do the following:

  • Trace and record events on an instance of SQL Server.

  • Manipulate and analyze trace data.

  • Replay recorded trace events on an instance of SQL Server.

    The Microsoft.SqlServer.Management.Trace namespace is in the Microsoft.SqlServerConnectionInfoExtended.dll file.

Note

The Trace and Replay objects are not supported on a 64-bit platform.