Partager via


Classe ServerTraceEventSet

The ServerTraceEventSet object represents a set server trace events.

Hiérarchie d'héritage

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

Espace de noms :  Microsoft.SqlServer.Management.Smo
Assembly :  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Syntaxe

'Déclaration
Public NotInheritable Class ServerTraceEventSet _
    Inherits EventSetBase
'Utilisation
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

Le type ServerTraceEventSet expose les membres suivants.

Constructeurs

  Nom Description
Méthode publique ServerTraceEventSet() Initializes a new instance of the ServerTraceEventSet class.
Méthode publique ServerTraceEventSet(ServerTraceEvent) Initializes a new instance of the ServerTraceEventSet class with a specified event.
Méthode publique ServerTraceEventSet(array<ServerTraceEvent[]) Initializes a new instance of the ServerTraceEventSet class with the specified set of events.
Méthode publique ServerTraceEventSet(ServerTraceEventSet) Initializes a new instance of the ServerTraceEventSet class with the specified set of events.

Haut de la page

Propriétés

  Nom Description
Propriété publique AssemblyLoad Gets or sets a boolean property value that specifies whether the event is included in the event set.
Propriété publique AuditAddDBUserEvent Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique AuditFulltext Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique BitmapWarning Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Propriété publique 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.
Propriété publique CpuThresholdExceeded Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Propriété publique 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.
Propriété publique DatabaseSuspectDataPage Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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).
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique NumberOfElements Gets the number of elements in the event set. (remplace EventSetBase.NumberOfElements.)
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique OledbCallEvent Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Propriété publique OledbDatareadEvent Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Propriété publique 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.
Propriété publique OledbProviderInformation Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Propriété publique OledbQueryinterfaceEvent Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Propriété publique Qn_dynamics Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Propriété publique Qn_parameterTable Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Propriété publique Qn_subscription Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Propriété publique Qn_template Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Propriété publique 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.
Propriété publique 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.
Propriété publique ShowplanXml Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Propriété publique 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.
Propriété publique ShowplanXmlStatisticsProfile Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique SqlStmtrecompile Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Propriété protégée Storage Gets or sets the bit array for event set storage. (hérité de EventSetBase.)
Propriété publique TraceAllEvents Gets or sets a Boolean property value that specifies whether all events are included in the trace or not.
Propriété publique TraceClr Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Propriété publique TraceDatabase Gets or sets a Boolean property value that specifies whether the Database category events are recorded in the trace.
Propriété publique TraceDeprecation Gets or sets a Boolean property value that specifies whether Deprecation category events are recorded in the trace.
Propriété publique TraceErrorsAndWarnings Gets or sets a Boolean property value that specifies whether errors and warnings are recorded in the trace.
Propriété publique 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.
Propriété publique TraceFullText Gets or sets a Boolean property value that specifies whether Full Text category events are recorded in the trace.
Propriété publique TraceLocks Gets or sets a Boolean property value that specifies whether Lock category events are recorded in the trace.
Propriété publique TraceObjects Gets or sets a Boolean property value that specifies whether Object category events are recorded in the trace.
Propriété publique TraceOledb Gets or sets a Boolean property value that specifies whether OLE DB category events are recorded in the trace.
Propriété publique TracePerformance Gets or sets a Boolean property value that specifies whether Performance category events are recorded in the trace.
Propriété publique TraceQueryNotifications Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Propriété publique TraceSecurityAudit Gets or sets a Boolean property value that specifies whether Security Audit category events are recorded in the trace.
Propriété publique TraceServer Gets or sets a Boolean property value that specifies whether Server category events are recorded in the trace.
Propriété publique TraceStoredProcedures Gets or sets a Boolean property value that specifies whether Stored Procedure category events are recorded in the trace.
Propriété publique TraceTsql Gets or sets a Boolean property value that specifies whether Transact-SQL category events are recorded in the trace.
Propriété publique TraceUserConfigurable Gets or sets a Boolean property value that specifies whether Lock category events are recorded in the trace.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique UserErrorMessage Gets or sets a Boolean value that specifies whether the UserErrorMessage event is included in the event set.
Propriété publique XqueryStaticType Gets or sets a Boolean property value that specifies whether the event is included in the event set.

Haut de la page

Méthodes

  Nom Description
Méthode publique Add(ServerTraceEvent) Returns a trace event set after adding a trace event to an existing event set.
Méthode publiqueMembre statique Add(ServerTraceEventSet, ServerTraceEvent) Returns a trace event set after adding a trace event to an existing event set.
Méthode publique Copy Returns a copy of the event set. (remplace EventSetBase.Copy().)
Méthode publique Equals (hérité de Object.)
Méthode publique GetHashCode (hérité de Object.)
Méthode publique GetType (hérité de Object.)
Méthode publique Remove Removes an event from the event set.
Méthode publiqueMembre statique Subtract Returns a trace event set after subtracting a trace event from an existing event set.
Méthode publique ToString Returns a string that represents the ServerTraceEventSet object. (remplace Object.ToString().)

Haut de la page

Opérateurs

  Nom Description
Opérateur publicMembre statique Addition Creates a server trace event set by performing an addition operation on a ServerTraceEvent object and a ServerTraceEventSet object.
Opérateur publicMembre statique Subtraction Creates a server trace event set by performing a subtraction operation on a ServerTraceEvent object and a ServerTraceEventSet object.

Haut de la page

Notes

The ServerTraceEventSet object contains a property for each event to which the server trace responds. The events fall into categories, which are described in Référence de classe d'événements 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.

Cet espace de noms, cette classe ou ce membre est pris en charge uniquement par la version 2.0 de Microsoft .NET Framework.

Thread Safety

Tout membre statique public (Partagé dans Microsoft Visual Basic) de ce type est sûr dans le cadre des opérations à plusieurs threads. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.

Exemples

Gestion des événements SMO

Sécurité des threads

Tous les membres publics static (Shared dans Visual Basic) de ce type sont thread-safe. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.

Voir aussi

Référence

Espace de noms Microsoft.SqlServer.Management.Smo

Autres ressources

Événements de traçage et de relecture

Monitoring Events

Référence de classe d'événements SQL Server

sp_trace_setevent (Transact-SQL)