Classe ServerTraceEvent

Artigo
04/26/2013

The ServerTraceEvent object represents the SQL Server server trace events that can be included in a server trace event set.

Hierarquia de herança

System.Object
Microsoft.SqlServer.Management.Smo.ServerTraceEvent

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (em Microsoft.SqlServer.Smo.dll)

Sintaxe

'Declaração
Public NotInheritable Class ServerTraceEvent
'Uso
Dim instance As ServerTraceEvent

public sealed class ServerTraceEvent

public ref class ServerTraceEvent sealed

[<SealedAttribute>]
type ServerTraceEvent =  class end

public final class ServerTraceEvent

O tipo ServerTraceEvent expõe os membros a seguir.

Propriedades

	Nome	Descrição
	AssemblyLoad	Gets a server trace event that can be included in the event set.
	AuditAddDBUserEvent	Gets a server trace event that can be included in the event set.
	AuditAddloginEvent	Gets a server trace event that can be included in the event set.
	AuditAddLoginToServerRoleEvent	Gets a server trace event that can be included in the event set.
	AuditAddMemberToDBRoleEvent	Gets a server trace event that can be included in the event set.
	AuditAddRoleEvent	Gets a server trace event that can be included in the event set.
	AuditAppRoleChangePasswordEvent	Gets a server trace event that can be included in the event set.
	AuditBackupRestoreEvent	Gets a server trace event that can be included in the event set.
	AuditChangeAuditEvent	Gets a server trace event that can be included in the event set.
	AuditChangeDatabaseOwner	Gets a server trace event that can be included in the event set.
	AuditDatabaseManagementEvent	Gets a server trace event that can be included in the event set.
	AuditDatabaseObjectAccessEvent	Gets a server trace event that can be included in the event set.
	AuditDatabaseObjectGdrEvent	Gets a server trace event that can be included in the event set.
	AuditDatabaseObjectManagementEvent	Gets a server trace event that can be included in the event set.
	AuditDatabaseObjectTakeOwnershipEvent	Gets a server trace event that can be included in the event set.
	AuditDatabaseOperationEvent	Gets a server trace event that can be included in the event set.
	AuditDatabasePrincipalImpersonationEvent	Gets a server trace event that can be included in the event set.
	AuditDatabasePrincipalManagementEvent	Gets a server trace event that can be included in the event set.
	AuditDatabaseScopeGdrEvent	Gets a server trace event that can be included in the event set.
	AuditDbccEvent	Gets a server trace event that can be included in the event set.
	AuditFulltext	Gets a server trace event that can be included in the event set.
	AuditLogin	Gets a server trace event that can be included in the event set.
	AuditLoginChangePasswordEvent	Gets a server trace event that can be included in the event set.
	AuditLoginChangePropertyEvent	Gets a server trace event that can be included in the event set.
	AuditLoginFailed	Gets a server trace event that can be included in the event set.
	AuditLoginGdrEvent	Gets a server trace event that can be included in the event set.
	AuditLogout	Gets a server trace event that can be included in the event set.
	AuditSchemaObjectAccessEvent	Gets a server trace event that can be included in the event set.
	AuditSchemaObjectGdrEvent	Gets a server trace event that can be included in the event set.
	AuditSchemaObjectManagementEvent	Gets a server trace event that can be included in the event set.
	AuditSchemaObjectTakeOwnershipEvent	Gets a server trace event that can be included in the event set.
	AuditServerAlterTraceEvent	Gets a server trace event that can be included in the event set.
	AuditServerObjectGdrEvent	Gets a server trace event that can be included in the event set.
	AuditServerObjectManagementEvent	Gets a server trace event that can be included in the event set.
	AuditServerObjectTakeOwnershipEvent	Gets a server trace event that can be included in the event set.
	AuditServerOperationEvent	Gets a server trace event that can be included in the event set.
	AuditServerPrincipalImpersonationEvent	Gets a server trace event that can be included in the event set.
	AuditServerPrincipalManagementEvent	Gets a server trace event that can be included in the event set.
	AuditServerScopeGdrEvent	Gets a server trace event that can be included in the event set.
	BitmapWarning	Gets a server trace event that can be included in the event set.
	BlockedProcessReport	Gets a server trace event that can be included in the event set.
	CpuThresholdExceeded	Gets a server trace event that can be included in the event set.
	DatabaseMirroringStateChange	Gets a server trace event that can be included in the event set.
	DatabaseSuspectDataPage	Gets a server trace event that can be included in the event set.
	DataFileAutoGrow	Gets a server trace event that can be included in the event set.
	DataFileAutoShrink	Gets a server trace event that can be included in the event set.
	DeadlockGraph	Gets a server trace event that can be included in the event set.
	DeprecationAnnouncement	Gets a server trace event that can be included in the event set.
	DeprecationFinalSupport	Gets a server trace event that can be included in the event set.
	Errorlog	Gets a server trace event that can be included in the event set.
	Eventlog	Gets a server trace event that can be included in the event set.
	Exception	Gets a server trace event that can be included in the event set.
	ExchangeSpillEvent	Gets a server trace event that can be included in the event set.
	ExecutionWarnings	Gets a server trace event that can be included in the event set.
	FtCrawlAborted	Gets a server trace event that can be included in the event set.
	FtCrawlStarted	Gets a server trace event that can be included in the event set.
	FtCrawlStopped	Gets a server trace event that can be included in the event set.
	HashWarning	Gets a server trace event that can be included in the event set.
	LockDeadlock	Gets a server event that can be included in the event set.
	LockDeadlockChain	Gets a server trace event that can be included in the event set.
	LockEscalation	Gets a server trace event that can be included in the event set.
	LogFileAutoGrow	Gets a server trace event that can be included in the event set.
	LogFileAutoShrink	Gets a server trace event that can be included in the event set.
	MissingColumnStatistics	Gets a server trace event that can be included in the event set.
	MissingJoinPredicate	Gets a server trace event that can be included in the event set.
	MountTape	Gets a server trace event that can be included in the event set.
	ObjectAltered	Gets a server trace event that can be included in the event set.
	ObjectCreated	Gets a server trace event that can be included in the event set.
	ObjectDeleted	Gets a server trace event that can be included in the event set.
	OledbCallEvent	Gets a server trace event that can be included in the event set.
	OledbDatareadEvent	Gets a server trace event that can be included in the event set.
	OledbErrors	Gets a server trace event that can be included in the event set.
	OledbProviderInformation	Gets a server trace event that can be included in the event set.
	OledbQueryinterfaceEvent	Gets a server trace event that can be included in the event set.
	Qn_dynamics	Gets a server trace event that can be included in the event set.
	Qn_parameterTable	Gets a server trace event that can be included in the event set.
	Qn_subscription	Gets a server trace event that can be included in the event set.
	Qn_template	Gets a server trace event that can be included in the event set.
	ServerMemoryChange	Gets a server trace event that can be included in the event set.
	ShowplanAllForQueryCompile	Gets a server trace event that can be included in the event set.
	ShowplanXml	Gets a server trace event that can be included in the event set.
	ShowplanXmlForQueryCompile	Gets a server trace event that can be included in the event set.
	ShowplanXmlStatisticsProfile	Gets a server trace event that can be included in the event set.
	SortWarnings	Gets a server trace event that can be included in the event set.
	SpCacheinsert	Gets a server trace event that can be included in the event set.
	SpCachemiss	Gets a server trace event that can be included in the event set.
	SpCacheremove	Gets a server trace event that can be included in the event set.
	SpRecompile	Gets a server trace event that can be included in the event set.
	SqlStmtrecompile	Gets a server trace event that can be included in the event set.
	TraceAllEvents	Gets a server trace event category that can be included in the event set.
	TraceClr	Gets a server trace event category that can be included in the event set.
	TraceDatabase	Gets a server trace event category that can be included in the event set.
	TraceDeprecation	Gets a server trace event category that can be included in the event set.
	TraceErrorsAndWarnings	Gets a server trace event category that can be included in the event set.
	TraceFileClose	Gets a server trace event category that can be included in the event set.
	TraceFullText	Gets a server trace event category that can be included in the event set.
	TraceLocks	Gets a server trace event category that can be included in the event set.
	TraceObjects	Gets a server trace event that can be included in the event set.
	TraceOledb	Gets a server trace event category that can be included in the event set.
	TracePerformance	Gets a server trace event category that can be included in the event set.
	TraceQueryNotifications	Gets a server trace event category that can be included in the event set.
	TraceSecurityAudit	Gets a server trace event category that can be included in the event set.
	TraceServer	Gets a server trace event category that can be included in the event set.
	TraceStoredProcedures	Gets a server trace event category that can be included in the event set.
	TraceTsql	Gets a server trace event that can be included in the event set.
	TraceUserConfigurable	Gets a server trace event category that can be included in the event set.
	Userconfigurable0	Gets a server trace event that can be included in the event set.
	Userconfigurable1	Gets a server trace event that can be included in the event set.
	Userconfigurable2	Gets a server trace event that can be included in the event set.
	Userconfigurable3	Gets a server trace event that can be included in the event set.
	Userconfigurable4	Gets a server trace event that can be included in the event set.
	Userconfigurable5	Gets a server trace event that can be included in the event set.
	Userconfigurable6	Gets a server trace event that can be included in the event set.
	Userconfigurable7	Gets a server trace event that can be included in the event set.
	Userconfigurable8	Gets a server trace event that can be included in the event set.
	Userconfigurable9	Gets a server trace event that can be included in the event set.
	UserErrorMessage	Gets a server trace event that can be included in the event set.
	XqueryStaticType	Gets a server trace event that can be included in the event set.

Início

Métodos

	Nome	Descrição
	Add	Returns a server trace event set by adding two server trace events.
	BitwiseOr	Returns a new server trace event that includes both of the named Server Trace Events.
	Equals	Determines whether the referenced server trace event object is equal to a specified object. (Substitui Object.Equals(Object).)
	GetHashCode	Identificado apenas para fins informativos. Sem suporte. A compatibilidade futura não está garantida. (Substitui Object.GetHashCode().)
	GetType	(Herdado de Object.)
	ToString	Returns the referenced object in string format. (Substitui Object.ToString().)

Início

Operadores

	Nome	Descrição
	Addition	Creates a server trace event set by performing an addition operation on two server trace event objects.
	BitwiseOr	Creates a server trace event set by performing a bitwise OR operation on two ServerTraceEvent objects.
	Equality	Creates a server trace event set by comparing two ServerTraceEvent objects.
	Implicit(ServerTraceEvent to ServerTraceEventSet)	Converts a single server trace event to a server trace event set.
	Inequality	Creates a server event set by comparing on two ServerTraceEvent objects.

Início

Comentários

The ServerTraceEvent object contains a property for each trace event to which the instance of SQL Server can respond. The actual set of trace events is specified using the ServerTraceEventSet object.

Só há suporte para esse namespace, classe ou membro na versão 2.0 do Microsoft .NET Framework.

Thread Safety

Qualquer membro público estático (Compartilhado no Microsoft Visual Basic) desse tipo é seguro para operações multi-threaded. Não há garantia de que qualquer membro de instância seja seguro para threads.

Exemplos

Manipulando eventos SMO

Segurança de thread

Qualquer membro público static (Shared no Visual Basic) desse tipo é seguro para threads. Não há garantia de que qualquer membro de instância seja seguro para threads.

Partilhar via

Classe ServerTraceEvent

Hierarquia de herança

Sintaxe

Propriedades

Métodos

Operadores

Comentários

Thread Safety

Exemplos

Segurança de thread

Consulte também

Referência

Outros recursos

Recursos adicionais