ServerTraceEventSet 類別

The ServerTraceEventSet object represents a set server trace events.

繼承階層

System.Object
  Microsoft.SqlServer.Management.Smo.EventSetBase
    Microsoft.SqlServer.Management.Smo.ServerTraceEventSet

命名空間：  Microsoft.SqlServer.Management.Smo
組件：  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
Public NotInheritable Class ServerTraceEventSet _
    Inherits EventSetBase
'用途
Dim instance As ServerTraceEventSet

public sealed class ServerTraceEventSet : EventSetBase

public ref class ServerTraceEventSet sealed : public EventSetBase

[<SealedAttribute>]
type ServerTraceEventSet =  
    class 
        inherit EventSetBase 
    end

public final class ServerTraceEventSet extends EventSetBase

ServerTraceEventSet 型別公開下列成員。

建構函式

	名稱	說明
	ServerTraceEventSet()	Initializes a new instance of the ServerTraceEventSet class.
	ServerTraceEventSet(ServerTraceEvent)	Initializes a new instance of the ServerTraceEventSet class with a specified event.
	ServerTraceEventSet(array<ServerTraceEvent[])	Initializes a new instance of the ServerTraceEventSet class with the specified set of events.
	ServerTraceEventSet(ServerTraceEventSet)	Initializes a new instance of the ServerTraceEventSet class with the specified set of events.

上層

屬性

	名稱	說明
	AssemblyLoad	Gets or sets a boolean property value that specifies whether the event is included in the event set.
	AuditAddDBUserEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AuditAddloginEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a new login is added.
	AuditAddLoginToServerRoleEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a login is added to a server role.
	AuditAddMemberToDBRoleEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a new member is added to a database role.
	AuditAddRoleEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a new role is added.
	AuditAppRoleChangePasswordEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when the password for an application role is changed.
	AuditBackupRestoreEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a backup and restore operation is issued.
	AuditChangeAuditEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when audit trace modifications are made.
	AuditChangeDatabaseOwner	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when the database owner is changed.
	AuditDatabaseManagementEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database is created, altered, or dropped.
	AuditDatabaseObjectAccessEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database object is accessed, such as a schema.
	AuditDatabaseObjectGdrEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when grant, deny, or revoke operation is issued on a database object, such as a schema.
	AuditDatabaseObjectManagementEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database object is created, altered or dropped.
	AuditDatabaseObjectTakeOwnershipEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when ownership of an object in the database scope is changed.
	AuditDatabaseOperationEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database operation occurs, such as a checkpoint.
	AuditDatabasePrincipalImpersonationEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when there is an impersonation within the scope of the database, such as a SETUSER or an EXECUTE AS USER.
	AuditDatabasePrincipalManagementEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a principal, such as users, are created, altered, or dropped from the database.
	AuditDatabaseScopeGdrEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a grant, deny, or revoke operation is issued within the scope of the database.
	AuditDbccEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when DBCC commands are issued.
	AuditFulltext	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AuditLogin	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a user successfully logs on to Microsoft SQL Server.
	AuditLoginChangePasswordEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a SQL Server login password is changed.
	AuditLoginChangePropertyEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a login property, other than password, is changed.
	AuditLoginFailed	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an attempt to log in to SQL Server fails.
	AuditLoginGdrEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a grant, deny, or revoke operation is issued on a login object.
	AuditLogout	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a user successfully logs out of SQL Server.
	AuditSchemaObjectAccessEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an object permission, such as SELECT, is used both successfully or unsuccessfully.
	AuditSchemaObjectGdrEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an object grant, deny, or revoke operation is issued.
	AuditSchemaObjectManagementEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an object is created, altered or dropped.
	AuditSchemaObjectTakeOwnershipEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an ALTER AUTHORIZATION command is used to change the owner of an object.
	AuditServerAlterTraceEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a statement checks for the ALTER TRACE permission.
	AuditServerObjectGdrEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a grant, deny, or revoke operation is issued on a schema object, such as a table or a function.
	AuditServerObjectManagementEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a server objects are created, altered, or dropped.
	AuditServerObjectTakeOwnershipEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when the ownership is changed for objects within the scope of the server.
	AuditServerOperationEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when Security Audit operations such as altering settings, resources, external access, or authorization are used.
	AuditServerPrincipalImpersonationEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when there is an impersonation within scope of the server, such as EXECUTE AS LOGIN.
	AuditServerPrincipalManagementEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a server principals are created, altered, or dropped.
	AuditServerScopeGdrEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a grant, deny, or revoke operation for permissions is issued in the scope of the server, such as creating a login.
	BitmapWarning	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	BlockedProcessReport	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a process has been blocked for more than a specified amount of time.
	CpuThresholdExceeded	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DatabaseMirroringStateChange	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when the state of a mirrored database changes.
	DatabaseSuspectDataPage	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DataFileAutoGrow	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a data file is extended automatically by the server.
	DataFileAutoShrink	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a data file is reduced automatically by the server.
	DeadlockGraph	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an attempt to acquire a lock is canceled because the attempt was part of a deadlock and was chosen as the deadlock victim.
	DeprecationAnnouncement	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a feature is used that will be removed from a future version of SQL Server.
	DeprecationFinalSupport	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a feature is used that will be removed from the next major version of SQL Server.
	Errorlog	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when error events are logged in the SQL Server error log.
	Eventlog	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when error events are logged in the SQL Server application.
	Exception	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an exception occurs in SQL Server
	ExchangeSpillEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when communication buffers in a parallel query plan have been temporarily written to the tempdb database.
	ExecutionWarnings	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when warnings are issued during the execution of a SQL Server statement or stored procedure.
	FtCrawlAborted	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an exception is encountered during a full-text crawl.
	FtCrawlStarted	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a full-text crawl (population) starts.
	FtCrawlStopped	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a full-text crawl (population) starts.
	HashWarning	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a hashing operation that is not processing on a buffer partition has reverted to an alternate plan.
	LockDeadlock	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when two concurrent transactions have deadlocked each other by trying to obtain incompatible locks on resources that the other transaction owns.
	LockDeadlockChain	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs for each of the events leading up to a deadlock.
	LockEscalation	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a fine-grained lock has been converted to a coarse-grained lock (for example, a page lock escalated or converted to a table lock).
	LogFileAutoGrow	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a log file was extended automatically by the server.
	LogFileAutoShrink	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a log file was reduced automatically by the server.
	MissingColumnStatistics	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when column statistics that would be useful for the optimizer are not available.
	MissingJoinPredicate	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a query that has no join predicate is being executed.
	MountTape	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a request to mount a tape is received.
	NumberOfElements	Gets the number of elements in the event set. (覆寫 EventSetBase.NumberOfElements。)
	ObjectAltered	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an object is altered.
	ObjectCreated	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an object is created.
	ObjectDeleted	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an object is deleted.
	OledbCallEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	OledbDatareadEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	OledbErrors	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an OLE DB error occurs.
	OledbProviderInformation	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	OledbQueryinterfaceEvent	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	Qn_dynamics	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	Qn_parameterTable	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	Qn_subscription	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	Qn_template	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	ServerMemoryChange	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when SQL Server memory usage has increased or decreased by either 1 MB or 5 percent of the maximum server memory, whichever is greater.
	ShowplanAllForQueryCompile	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an SQL statement compiles and displays complete, compile-time data.
	ShowplanXml	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	ShowplanXmlForQueryCompile	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an SQL statement executes and displays the complete, compile-time data.
	ShowplanXmlStatisticsProfile	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	SortWarnings	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a sort warning is generated.
	SpCacheinsert	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an item is inserted into the procedure cache.
	SpCachemiss	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a procedure is not found in the procedure cache.
	SpCacheremove	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an item is removed from the procedure cache.
	SpRecompile	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a procedure is recompiled.
	SqlStmtrecompile	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	Storage	Gets or sets the bit array for event set storage. (繼承自 EventSetBase。)
	TraceAllEvents	Gets or sets a Boolean property value that specifies whether all events are included in the trace or not.
	TraceClr	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	TraceDatabase	Gets or sets a Boolean property value that specifies whether the Database category events are recorded in the trace.
	TraceDeprecation	Gets or sets a Boolean property value that specifies whether Deprecation category events are recorded in the trace.
	TraceErrorsAndWarnings	Gets or sets a Boolean property value that specifies whether errors and warnings are recorded in the trace.
	TraceFileClose	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs if a trace file closes when a transaction is rolled back.
	TraceFullText	Gets or sets a Boolean property value that specifies whether Full Text category events are recorded in the trace.
	TraceLocks	Gets or sets a Boolean property value that specifies whether Lock category events are recorded in the trace.
	TraceObjects	Gets or sets a Boolean property value that specifies whether Object category events are recorded in the trace.
	TraceOledb	Gets or sets a Boolean property value that specifies whether OLE DB category events are recorded in the trace.
	TracePerformance	Gets or sets a Boolean property value that specifies whether Performance category events are recorded in the trace.
	TraceQueryNotifications	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	TraceSecurityAudit	Gets or sets a Boolean property value that specifies whether Security Audit category events are recorded in the trace.
	TraceServer	Gets or sets a Boolean property value that specifies whether Server category events are recorded in the trace.
	TraceStoredProcedures	Gets or sets a Boolean property value that specifies whether Stored Procedure category events are recorded in the trace.
	TraceTsql	Gets or sets a Boolean property value that specifies whether Transact-SQL category events are recorded in the trace.
	TraceUserConfigurable	Gets or sets a Boolean property value that specifies whether Lock category events are recorded in the trace.
	Userconfigurable0	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.
	Userconfigurable1	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.
	Userconfigurable2	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.
	Userconfigurable3	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.
	Userconfigurable4	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.
	Userconfigurable5	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.
	Userconfigurable6	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.
	Userconfigurable7	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.
	Userconfigurable8	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.
	Userconfigurable9	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.
	UserErrorMessage	Gets or sets a Boolean value that specifies whether the UserErrorMessage event is included in the event set.
	XqueryStaticType	Gets or sets a Boolean property value that specifies whether the event is included in the event set.

上層

方法

	名稱	說明
	Add(ServerTraceEvent)	Returns a trace event set after adding a trace event to an existing event set.
	Add(ServerTraceEventSet, ServerTraceEvent)	Returns a trace event set after adding a trace event to an existing event set.
	Copy	Returns a copy of the event set. (覆寫 EventSetBase.Copy()。)
	Equals	(繼承自 Object。)
	GetHashCode	(繼承自 Object。)
	GetType	(繼承自 Object。)
	Remove	Removes an event from the event set.
	Subtract	Returns a trace event set after subtracting a trace event from an existing event set.
	ToString	Returns a string that represents the ServerTraceEventSet object. (覆寫 Object.ToString()。)

上層

運算子

	名稱	說明
	Addition	Creates a server trace event set by performing an addition operation on a ServerTraceEvent object and a ServerTraceEventSet object.
	Subtraction	Creates a server trace event set by performing a subtraction operation on a ServerTraceEvent object and a ServerTraceEventSet object.

上層

備註

The ServerTraceEventSet object contains a property for each event to which the server trace responds. The events fall into categories, which are described in SQL Server 事件類別參考. The ServerTraceEventSet class is used to define a set of events that can be traced by SQL Server Profiler or the SMO Trace objects.

只有 Microsoft .NET Framework 2.0 版支援此命名空間、類別或成員。

Thread Safety

此型別的任何公用靜態 (在 Microsoft Visual Basic 為共用) 成員具備多執行緒作業安全。並非所有的執行個體成員都是安全執行緒。

範例

處理 SMO 事件

執行緒安全性

這個型別的任何公用 static (在 Visual Basic 中為 Shared) 成員都是執行緒安全的。並不是所有的執行個體成員都保證可以用於所有的執行緒。

請參閱

參考

Microsoft.SqlServer.Management.Smo 命名空間

其他資源

追蹤及重新執行事件

Monitoring Events

SQL Server 事件類別參考

sp_trace_setevent (Transact-SQL)