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 프로파일러 or the SMO Trace objects.

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

Thread Safety

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

예

SMO 이벤트 처리

스레드 보안

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

참고 항목

참조

Microsoft.SqlServer.Management.Smo 네임스페이스

관련 자료

이벤트 추적 및 재생

Monitoring Events

SQL Server 이벤트 클래스 참조

sp_trace_setevent(Transact-SQL)