Classe TraceServer

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

Gerarchia di ereditarietà

System.Object
  Microsoft.SqlServer.Management.Trace.TraceReader
    Microsoft.SqlServer.Management.Trace.TraceServer

Spazio dei nomi  Microsoft.SqlServer.Management.Trace
Assembly:  Microsoft.SqlServer.ConnectionInfoExtended (in Microsoft.SqlServer.ConnectionInfoExtended.dll)

Sintassi

'Dichiarazione
<ComVisibleAttribute(False)> _
Public Class TraceServer _
    Inherits TraceReader
'Utilizzo
Dim instance As TraceServer

[ComVisibleAttribute(false)]
public class TraceServer : TraceReader

[ComVisibleAttribute(false)]
public ref class TraceServer : public TraceReader

[<ComVisibleAttribute(false)>]
type TraceServer =  
    class 
        inherit TraceReader 
    end

public class TraceServer extends TraceReader

Nel tipo TraceServer sono esposti i membri seguenti.

Costruttori

	Nome	Descrizione
	TraceServer	Initializes a new instance of the TraceServer class.

In alto

Proprietà

	Nome	Descrizione
	Depth	Gets the depth value for the trace reader. Ereditato da TraceReader.
	FieldCount	Gets the number of columns in the data. Ereditato da TraceReader.
	IsClosed	Gets the Boolean property value that specifies whether the trace reader is closed. Ereditato da TraceReader.
	Item[Int32]	Gets the column specified by the index position. Ereditato da TraceReader.
	Item[String]	Gets the column with the specified name. Ereditato da TraceReader.
	RecordsAffected	Gets the number of records of data. Ereditato da TraceReader.

In alto

Metodi

	Nome	Descrizione
	Close	Closes the trace reader. Ereditato da TraceReader.
	Dispose	Deletes the trace reader information. Ereditato da TraceReader.
	Equals	Ereditato da Object.
	Finalize	Ereditato da Object.
	GetBoolean	Returns a Boolean value from the record at the specified column position. Ereditato da TraceReader.
	GetByte	Returns a Byte value from the record at the specified column position. Ereditato da TraceReader.
	GetBytes	Gets a stream of bytes from the specified column offset into the buffer as an array, starting at the given buffer offset. Ereditato da TraceReader.
	GetChar	Gets a character value of the specified column. Ereditato da TraceReader.
	GetChars(Int32, array<Char[], Int32, Int32, Int32)	Gets a character array value from the record at the specified column position. Ereditato da TraceReader.
	GetChars(Int32, Int64, array<Char[], Int32, Int32)	Gets a character array value from the record at the specified column position. Ereditato da TraceReader.
	GetData	Returns IDataReader object used when the field points to a remote data structure. Ereditato da TraceReader.
	GetDataTypeName	Gets the data type of the data value at the specified column position. Ereditato da TraceReader.
	GetDateTime	Gets a DateTime value of the data value at the specified column position. Ereditato da TraceReader.
	GetDecimal	Gets a Decimal value of the data value at the specified column position. Ereditato da TraceReader.
	GetDouble	Gets a floating point value of the data value at the specified column position. Ereditato da TraceReader.
	GetFieldType	Returns the field type of the data value at the specified column position. Ereditato da TraceReader.
	GetFloat	Gets a floating point value of the data value at the specified column position. Ereditato da TraceReader.
	GetGuid	Gets a Guid system value of the data value at the specified column position. Ereditato da TraceReader.
	GetHashCode	Ereditato da Object.
	GetInt16	Gets a small integer value of the data value at the specified column position. Ereditato da TraceReader.
	GetInt32	Gets an integer value of the data value at the specified column position. Ereditato da TraceReader.
	GetInt64	Gets a long integer value of the data value at the specified column position. Ereditato da TraceReader.
	GetName	Gets the name of the field at the specified column position. Ereditato da TraceReader.
	GetOrdinal	Gets the ordinal value of the data value at the specified column position. Ereditato da TraceReader.
	GetSchemaTable	Gets a table that describes the schema. Ereditato da TraceReader.
	GetStream	Gets the stream of data. Ereditato da TraceReader.
	GetString	Gets a String value at the specified column position. Ereditato da TraceReader.
	GetTimeSpan	Gets a TimeSpan value of the data value at the specified column position. Ereditato da TraceReader.
	GetType	Ereditato da Object.
	GetValue	Gets a value of the data value at the specified column position. Ereditato da TraceReader.
	GetValues	Gets an array of values from the data value at the specified column position. Ereditato da TraceReader.
	InitializeAsReader	Initializes the server as a trace reader.
	IsDBNull	Specifies whether the specified column is set to null. Ereditato da TraceReader.
	IsNull	Gets a Boolean value that specifies whether value of the data at the specified column position is null. Ereditato da TraceReader.
	MemberwiseClone	Ereditato da Object.
	NextResult	Moves to the next result in the trace. Ereditato da TraceReader.
	Pause	Pauses the trace.
	Read	Reads the trace record. Ereditato da TraceReader.
	Restart	Restarts the trace.
	Stop	Stops the trace.
	ToString	Ereditato da Object.
	TranslateSubclass	Translates the sub class. Ereditato da TraceReader.

In alto

Campi

	Nome	Descrizione
	currentRow	Specifies the current row. Ereditato da TraceReader.

In alto

Osservazioni

With the TraceServer object you can:

• Start a new trace.

• Read a trace.

In addition to the Trace and Replay objects, the trace can be created manually by using Guida di riferimento a SQL Server Profiler or by using a set of Transact-SQL stored procedures called Introduzione a Traccia SQL.

Esempi

Readme_Tracer

Protezione dei thread

I membri static (Shared in Visual Basic) pubblici di questo tipo sono affidabili. Non è invece garantita la sicurezza dei membri dell'istanza.

Vedere anche

Riferimento

Spazio dei nomi Microsoft.SqlServer.Management.Trace

Altre risorse

Flag di traccia (Transact-SQL)

Modelli e autorizzazioni di SQL Server Profiler