문서를 영문으로 보려면 영문 확인란을 선택하세요. 마우스 포인터를 텍스트 위로 이동시켜 팝업 창에서 영문 텍스트를 표시할 수도 있습니다.
번역
영문

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 sealed class ServerTraceEventSet : 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(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.
맨 위로 이동

  이름설명
공용 속성AssemblyLoadGets or sets a boolean property value that specifies whether the event is included in the event set.
공용 속성AuditAddDBUserEventGets or sets a Boolean property value that specifies whether the event is included in the event set.
공용 속성AuditAddloginEventGets 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.
공용 속성AuditAddLoginToServerRoleEventGets 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.
공용 속성AuditAddMemberToDBRoleEventGets 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.
공용 속성AuditAddRoleEventGets 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.
공용 속성AuditAppRoleChangePasswordEventGets 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.
공용 속성AuditBackupRestoreEventGets 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.
공용 속성AuditChangeAuditEventGets 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.
공용 속성AuditChangeDatabaseOwnerGets 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.
공용 속성AuditDatabaseManagementEventGets 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.
공용 속성AuditDatabaseObjectAccessEventGets 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.
공용 속성AuditDatabaseObjectGdrEventGets 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.
공용 속성AuditDatabaseObjectManagementEventGets 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.
공용 속성AuditDatabaseObjectTakeOwnershipEventGets 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.
공용 속성AuditDatabaseOperationEventGets 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.
공용 속성AuditDatabasePrincipalImpersonationEventGets 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.
공용 속성AuditDatabasePrincipalManagementEventGets 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.
공용 속성AuditDatabaseScopeGdrEventGets 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.
공용 속성AuditDbccEventGets 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.
공용 속성AuditFulltextGets or sets a Boolean property value that specifies whether the event is included in the event set.
공용 속성AuditLoginGets 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.
공용 속성AuditLoginChangePasswordEventGets 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.
공용 속성AuditLoginChangePropertyEventGets 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.
공용 속성AuditLoginFailedGets 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.
공용 속성AuditLoginGdrEventGets 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.
공용 속성AuditLogoutGets 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.
공용 속성AuditSchemaObjectAccessEventGets 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.
공용 속성AuditSchemaObjectGdrEventGets 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.
공용 속성AuditSchemaObjectManagementEventGets 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.
공용 속성AuditSchemaObjectTakeOwnershipEventGets 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.
공용 속성AuditServerAlterTraceEventGets 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.
공용 속성AuditServerObjectGdrEventGets 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.
공용 속성AuditServerObjectManagementEventGets 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.
공용 속성AuditServerObjectTakeOwnershipEventGets 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.
공용 속성AuditServerOperationEventGets 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.
공용 속성AuditServerPrincipalImpersonationEventGets 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.
공용 속성AuditServerPrincipalManagementEventGets 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.
공용 속성AuditServerScopeGdrEventGets 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.
공용 속성BitmapWarningGets or sets a Boolean property value that specifies whether the event is included in the event set.
공용 속성BlockedProcessReportGets 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.
공용 속성CpuThresholdExceededGets or sets a Boolean property value that specifies whether the event is included in the event set.
공용 속성DatabaseMirroringStateChangeGets 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.
공용 속성DatabaseSuspectDataPageGets or sets a Boolean property value that specifies whether the event is included in the event set.
공용 속성DataFileAutoGrowGets 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.
공용 속성DataFileAutoShrinkGets 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.
공용 속성DeadlockGraphGets 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.
공용 속성DeprecationAnnouncementGets 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.
공용 속성DeprecationFinalSupportGets 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.
공용 속성ErrorlogGets 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.
공용 속성EventlogGets 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.
공용 속성ExceptionGets 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
공용 속성ExchangeSpillEventGets 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.
공용 속성ExecutionWarningsGets 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.
공용 속성FtCrawlAbortedGets 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.
공용 속성FtCrawlStartedGets 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.
공용 속성FtCrawlStoppedGets 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.
공용 속성HashWarningGets 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.
공용 속성LockDeadlockGets 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.
공용 속성LockDeadlockChainGets 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.
공용 속성LockEscalationGets 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).
공용 속성LogFileAutoGrowGets 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.
공용 속성LogFileAutoShrinkGets 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.
공용 속성MissingColumnStatisticsGets 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.
공용 속성MissingJoinPredicateGets 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.
공용 속성MountTapeGets 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.
공용 속성NumberOfElementsGets the number of elements in the event set. (EventSetBase.NumberOfElements을(를) 재정의함)
공용 속성ObjectAlteredGets 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.
공용 속성ObjectCreatedGets 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.
공용 속성ObjectDeletedGets 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.
공용 속성OledbCallEventGets or sets a Boolean property value that specifies whether the event is included in the event set.
공용 속성OledbDatareadEventGets or sets a Boolean property value that specifies whether the event is included in the event set.
공용 속성OledbErrorsGets 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.
공용 속성OledbProviderInformationGets or sets a Boolean property value that specifies whether the event is included in the event set.
공용 속성OledbQueryinterfaceEventGets or sets a Boolean property value that specifies whether the event is included in the event set.
공용 속성Qn_dynamicsGets or sets a Boolean property value that specifies whether the event is included in the event set.
공용 속성Qn_parameterTableGets or sets a Boolean property value that specifies whether the event is included in the event set.
공용 속성Qn_subscriptionGets or sets a Boolean property value that specifies whether the event is included in the event set.
공용 속성Qn_templateGets or sets a Boolean property value that specifies whether the event is included in the event set.
공용 속성ServerMemoryChangeGets 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.
공용 속성ShowplanAllForQueryCompileGets 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.
공용 속성ShowplanXmlGets or sets a Boolean property value that specifies whether the event is included in the event set.
공용 속성ShowplanXmlForQueryCompileGets 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.
공용 속성ShowplanXmlStatisticsProfileGets or sets a Boolean property value that specifies whether the event is included in the event set.
공용 속성SortWarningsGets 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.
공용 속성SpCacheinsertGets 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.
공용 속성SpCachemissGets 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.
공용 속성SpCacheremoveGets 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.
공용 속성SpRecompileGets 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.
공용 속성SqlStmtrecompileGets or sets a Boolean property value that specifies whether the event is included in the event set.
보호된 속성StorageGets or sets the bit array for event set storage. (EventSetBase에서 상속됨)
공용 속성TraceAllEventsGets or sets a Boolean property value that specifies whether all events are included in the trace or not.
공용 속성TraceClrGets or sets a Boolean property value that specifies whether the event is included in the event set.
공용 속성TraceDatabaseGets or sets a Boolean property value that specifies whether the Database category events are recorded in the trace.
공용 속성TraceDeprecationGets or sets a Boolean property value that specifies whether Deprecation category events are recorded in the trace.
공용 속성TraceErrorsAndWarningsGets or sets a Boolean property value that specifies whether errors and warnings are recorded in the trace.
공용 속성TraceFileCloseGets 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.
공용 속성TraceFullTextGets or sets a Boolean property value that specifies whether Full Text category events are recorded in the trace.
공용 속성TraceLocksGets or sets a Boolean property value that specifies whether Lock category events are recorded in the trace.
공용 속성TraceObjectsGets or sets a Boolean property value that specifies whether Object category events are recorded in the trace.
공용 속성TraceOledbGets or sets a Boolean property value that specifies whether OLE DB category events are recorded in the trace.
공용 속성TracePerformanceGets or sets a Boolean property value that specifies whether Performance category events are recorded in the trace.
공용 속성TraceQueryNotificationsGets or sets a Boolean property value that specifies whether the event is included in the event set.
공용 속성TraceSecurityAuditGets or sets a Boolean property value that specifies whether Security Audit category events are recorded in the trace.
공용 속성TraceServerGets or sets a Boolean property value that specifies whether Server category events are recorded in the trace.
공용 속성TraceStoredProceduresGets or sets a Boolean property value that specifies whether Stored Procedure category events are recorded in the trace.
공용 속성TraceTsqlGets or sets a Boolean property value that specifies whether Transact-SQL category events are recorded in the trace.
공용 속성TraceUserConfigurableGets or sets a Boolean property value that specifies whether Lock category events are recorded in the trace.
공용 속성Userconfigurable0Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.
공용 속성Userconfigurable1Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.
공용 속성Userconfigurable2Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.
공용 속성Userconfigurable3Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.
공용 속성Userconfigurable4Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.
공용 속성Userconfigurable5Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.
공용 속성Userconfigurable6Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.
공용 속성Userconfigurable7Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.
공용 속성Userconfigurable8Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.
공용 속성Userconfigurable9Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.
공용 속성UserErrorMessageGets or sets a Boolean value that specifies whether the UserErrorMessage event is included in the event set.
공용 속성XqueryStaticTypeGets 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.
공용 메서드CopyReturns a copy of the event set. (EventSetBase.Copy()을(를) 재정의함)
공용 메서드Equals (Object에서 상속됨)
공용 메서드GetHashCode (Object에서 상속됨)
공용 메서드GetType (Object에서 상속됨)
공용 메서드RemoveRemoves an event from the event set.
공용 메서드정적 멤버SubtractReturns a trace event set after subtracting a trace event from an existing event set.
공용 메서드ToStringReturns a string that represents the ServerTraceEventSet object. (Object.ToString()을(를) 재정의함)
맨 위로 이동

  이름설명
공용 연산자정적 멤버AdditionCreates a server trace event set by performing an addition operation on a ServerTraceEvent object and a ServerTraceEventSet object.
공용 연산자정적 멤버SubtractionCreates 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 프로파일러 or the SMO Trace objects.

이 네임스페이스, 클래스 또는 멤버는 Microsoft .NET Framework 2.0 버전에서만 지원됩니다.

Thread Safety

이 유형의 모든 public static(Microsoft Visual Basic의 경우 공유) 멤버는 다중 스레드 작업을 수행하기에 안전합니다. 인스턴스 멤버는 스레드로부터의 안전성이 보장되지 않습니다.

이 유형의 모든 공용 static(Visual Basic에서는 Shared) 멤버는 스레드로부터 안전합니다. 인스턴스 멤버는 스레드로부터의 안전성이 보장되지 않습니다.

커뮤니티 추가 항목

추가
표시: