Export (0) Print
Expand All

Microsoft.SqlServer.Management.Trace Namespace

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

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

The Trace and Replay objects can be used to

  • 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 can be found in the Microsoft.SqlServerConnectionInfo.dll file.

In addition to the Trace and Replay objects, SQL Server traces can be implemented manually using Microsoft SQL Server Profiler Reference or using a set of Transact-SQL stored procedures called Introducing SQL Trace.

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

ClassDescription
ReplayEventArgsThe ReplayEventArgs object provides programmatic access to the arguments used to report events that occur when replaying trace on an instance of Microsoft SQL Server.
SqlTraceExceptionThe SQLTraceException class represents the general exception raised by the SQL Server Management Objects (SMO) trace objects.
SqlTraceFailToInstantiateTypeExceptionThe SQLTraceFailToInstantiateTypeException class represents the exception raised when a SQL Server Management Objects (SMO) trace object operation fails to instantiate an object.
SqlTraceFailToLoadInstAPIAssemblyExceptionThe SQLTraceFailToLoadInstAPIAssemblyException class represents the exception raised by the SQL Server Management Objects (SMO) trace objects when an Inst API assembly fails to load.
TraceEventArgsThe TraceEventArgs object provides programmatic access to the arguments used to report events that occur when collecting trace from an instance of Microsoft SQL Server.
TraceFileThe TraceFile class is a Trace object that represents a trace log file.
TraceReaderThe 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.
TraceReaderWriterThe TraceReaderWriter class is an abstract Trace Objects class that is used in the construction of the TraceTable class and the TraceFile class.
TraceReplayThe TraceReplay object is a Replay object that represents the replay operation for trace log files and trace tables.
TraceReplayOptionsThe TraceReplayOptions object is a Replay object that represents the configuration settings required when replaying a trace.
TraceServerThe TraceServer class is a Trace object that represents a new trace on an instance of Microsoft SQL Server.
TraceTableThe TraceTable class is a Trace object that represents a table of trace information.

InterfaceDescription
IDataRecordChangerThe IDataRecordChanger object is a Trace and Replay object that represents the current record.
ITraceDataWriterThe ITraceDataWriter object provides programmatic access to the data writer for the SQL Trace.

DelegateDescription
ReplayEventHandlerRepresents the ReplayEventHandler event handler.
ReplayPauseHandlerRepresents the ReplayPauseHandler event handler.
ReplayResultEventHandlerRepresents the ReplayResultEventHandler event handler.
ReplayStartHandlerRepresents the ReplayStartHandler event handler.
ReplayStopHandlerRepresents the ReplayStopHandler event handler.
WriteNotifyEventHandlerRepresents the WriteNotifyEventHandler handler.

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

Community Additions

ADD
Show:
© 2014 Microsoft