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

Microsoft.SqlServer.Management.Trace Namespace

The Microsoft.SqlServer.Management.Trace namespace contains the 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 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.

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

NoteNote

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

  ClassDescription
Public classReplayEventArgsThe ReplayEventArgs object provides programmatic access to the arguments used to report events that occur when replaying trace on an instance of SQL Server.
Public classSqlTraceExceptionThe SQLTraceException class represents the general exception raised by the SMO trace objects.
Public classSqlTraceFailToInstantiateTypeExceptionThe SQLTraceFailToInstantiateTypeException class represents the exception raised when an SMO trace object operation fails to instantiate an object.
Public classSqlTraceFailToLoadInstAPIAssemblyExceptionThe SQLTraceFailToLoadInstAPIAssemblyException class represents the exception raised by the SMO trace objects when an Inst API assembly fails to load.
Public classTraceEventArgsThe TraceEventArgs object provides programmatic access to the arguments used to report events that occur when collecting trace from an instance of SQL Server.
Public classTraceFileThe TraceFile class is a Trace object that represents a trace log file.
Public classTraceReaderThe 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.
Public classTraceReaderWriterThe TraceReaderWriter class is an abstract Trace Objects class that is used in the construction of the TraceTable class and the TraceFile class.
Public classTraceReplayThe TraceReplay object is a Replay object that represents the replay operation for trace log files and trace tables.
Public classTraceReplayOptionsThe TraceReplayOptions object is a Replay object that represents the configuration settings required when replaying a trace.
Public classTraceServerThe TraceServer class is a Trace object that represents a new trace on an instance of SQL Server.
Public classTraceTableThe TraceTable class is a Trace object that represents a table of trace information.
  InterfaceDescription
Public interfaceIDataRecordChangerThe IDataRecordChanger object is a Trace and Replay object that represents the current record.
Public interfaceITraceDataWriterThe ITraceDataWriter object provides programmatic access to the data writer for the SQL Trace.
  DelegateDescription
Public delegateReplayEventHandlerRepresents the ReplayEventHandler event handler.
Public delegateReplayPauseHandlerRepresents the ReplayPauseHandler event handler.
Public delegateReplayResultEventHandlerRepresents the ReplayResultEventHandler event handler.
Public delegateReplayStartHandlerRepresents the ReplayStartHandler event handler.
Public delegateReplayStopHandlerRepresents the ReplayStopHandler event handler.
Public delegateWriteNotifyEventHandlerRepresents the WriteNotifyEventHandler handler.
  EnumerationDescription
Public enumerationReplayModeThe ReplayMode enumeration contains values that are used to specify the type of synchronization used during the trace replay.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.