共用方式為


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)