Freigeben über


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 (Referenz), or by using the Einführung in die SQL-Ablaufverfolgung set of Transact-SQL stored procedures.

HinweisHinweis

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

Klassen

  Klasse Beschreibung
Öffentliche Klasse 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.
Öffentliche Klasse SqlTraceException The SQLTraceException class represents the general exception raised by the SMO trace objects.
Öffentliche Klasse SqlTraceFailToInstantiateTypeException The SQLTraceFailToInstantiateTypeException class represents the exception raised when an SMO trace object operation fails to instantiate an object.
Öffentliche Klasse SqlTraceFailToLoadInstAPIAssemblyException The SQLTraceFailToLoadInstAPIAssemblyException class represents the exception raised by the SMO trace objects when an Inst API assembly fails to load.
Öffentliche Klasse 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.
Öffentliche Klasse TraceFile The TraceFile class is a Trace object that represents a trace log file.
Öffentliche Klasse 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.
Öffentliche Klasse TraceReaderWriter The TraceReaderWriter class is an abstract Trace Objects class that is used in the construction of the TraceTable class and the TraceFile class.
Öffentliche Klasse TraceReplay The TraceReplay object is a Replay object that represents the replay operation for trace log files and trace tables.
Öffentliche Klasse TraceReplayOptions The TraceReplayOptions object is a Replay object that represents the configuration settings required when replaying a trace.
Öffentliche Klasse TraceServer The TraceServer class is a Trace object that represents a new trace on an instance of SQL Server.
Öffentliche Klasse TraceTable The TraceTable class is a Trace object that represents a table of trace information.

Schnittstellen

  Schnittstelle Beschreibung
Öffentliche Schnittstelle IDataRecordChanger The IDataRecordChanger object is a Trace and Replay object that represents the current record.
Öffentliche Schnittstelle ITraceDataWriter The ITraceDataWriter object provides programmatic access to the data writer for the SQL Trace.

Delegaten

  Delegat Beschreibung
Öffentlicher Delegat ReplayEventHandler Represents the ReplayEventHandler event handler.
Öffentlicher Delegat ReplayPauseHandler Represents the ReplayPauseHandler event handler.
Öffentlicher Delegat ReplayResultEventHandler Represents the ReplayResultEventHandler event handler.
Öffentlicher Delegat ReplayStartHandler Represents the ReplayStartHandler event handler.
Öffentlicher Delegat ReplayStopHandler Represents the ReplayStopHandler event handler.
Öffentlicher Delegat WriteNotifyEventHandler Represents the WriteNotifyEventHandler handler.

Enumerationen

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

Siehe auch

Verweis

Andere Ressourcen

SQL Server Profiler (Referenz)

Einführung in die SQL-Ablaufverfolgung