Referência de classe de evento do SQL ServerSQL Server Event Class Reference

APLICA-SE A: simSQL Server simBanco de Dados SQL do Azure nãoAzure Synapse Analytics (SQL DW) nãoParallel Data Warehouse APPLIES TO: yesSQL Server yesAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

SQL Server ProfilerSQL Server Profiler permite registrar eventos à medida que eles ocorrem em uma instância do MicrosoftMicrosoft Mecanismo de Banco de Dados do SQL ServerSQL Server Database Engine.lets you record events as they occur in an instance of the MicrosoftMicrosoft Mecanismo de Banco de Dados do SQL ServerSQL Server Database Engine. Os eventos registrados são instâncias das classes de evento na definição de rastreamento.The recorded events are instances of the event classes in the trace definition. No SQL Server ProfilerSQL Server Profiler, as classes de evento e suas categorias estão disponíveis na guia Seleção de Eventos da caixa de diálogo Propriedades do Arquivo de Rastreamento .In SQL Server ProfilerSQL Server Profiler, event classes and their event categories are available on the Events Selection tab of the Trace File Properties dialog box.

A tabela a seguir descreve as categorias de evento e lista suas classes de evento associadas.The following table describes the event categories and lists their associated event classes.

Categoria de eventoEvent Category Classes de eventoEvent Classes
A Categoria de Evento de Agente contém as classes de evento que são produzidas pelo Service BrokerService Broker.The Broker Event Category includes event classes that are produced by the Service BrokerService Broker. Classe de evento Broker:ActivationBroker:Activation Event Class

Classe de evento Broker:ConnectionBroker:Connection Event Class

Classe de evento Broker:ConversationBroker:Conversation Event Class

Classe de evento Broker:Conversation GroupBroker:Conversation Group Event Class

Classe de evento Broker:Corrupted MessageBroker:Corrupted Message Event Class

Classe de evento Broker:Forwarded Message DroppedBroker:Forwarded Message Dropped Event Class

Classe de evento Broker:Forwarded Message SentBroker:Forwarded Message Sent Event Class

Classe de evento Broker:Message ClassifyBroker:Message Classify Event Class

Classe de evento Broker:Message DropBroker:Message Drop Event Class

Agente: Classe de evento Remote Message AckBroker:Remote Message Ack Event Class
A Categoria de Evento de Cursores contém as classes de evento que são produzidas por operações de cursor.The Cursors Event Category includes event classes that are produced by cursor operations. Classe de evento CursorCloseCursorClose Event Class

Classe de evento CursorExecuteCursorExecute Event Class

Classe de evento CursorImplicitConversionCursorImplicitConversion Event Class

Classe de evento CursorOpenCursorOpen Event Class

Classe de evento CursorPrepareCursorPrepare Event Class

Classe de evento CursorRecompileCursorRecompile Event Class

Classe de evento CursorUnprepareCursorUnprepare Event Class
A Categoria de evento CLR inclui classes de evento que são produzidas pela execução de objetos CLR (Common Language Runtime) do .NET.The CLR Event Category includes event classes that are produced by the execution of .NET common language runtime (CLR) objects. Classe de evento Assembly LoadAssembly Load Event Class
A Categoria de Evento de Banco de Dados contém as classes de evento que são produzidas quando os arquivos de dados ou de log aumentam ou diminuem automaticamente.The Database Event Category includes event classes that are produced when data or log files grow or shrink automatically. Classe de evento Data File Auto GrowData File Auto Grow Event Class

Classe de evento Data File Auto ShrinkData File Auto Shrink Event Class

Classe de evento Database Mirroring State ChangeDatabase Mirroring State Change Event Class

Classe de evento Log File Auto GrowLog File Auto Grow Event Class

Classe de evento Log File Auto ShrinkLog File Auto Shrink Event Class
A Categoria de Evento de Reprovação inclui eventos relacionados à reprovação.The Deprecation Event Category includes deprecation related events. Classe de evento Deprecation AnnouncementDeprecation Announcement Event Class

Classe de evento Deprecation Final SupportDeprecation Final Support Event Class
A Categoria de Evento de Erros e Avisos (Mecanismo de Banco de Dados) contém as classes de evento que são produzidas quando um erro ou aviso do SQL ServerSQL Server é retornado. Por exemplo, se ocorrer um erro durante a compilação de um procedimento armazenado ou se ocorrer uma exceção no SQL ServerSQL Server.The Errors and Warnings Event Category (Database Engine) includes event classes that are produced when a SQL ServerSQL Server error or warning is returned, for example, if an error occurs during the compilation of a stored procedure or an exception occurs in SQL ServerSQL Server. Classe de evento AttentionAttention Event Class

Classe de evento Background Job ErrorBackground Job Error Event Class

Classe de evento Blocked Process ReportBlocked Process Report Event Class

Classe de evento CPU Threshold ExceededCPU Threshold Exceeded Event Class

Classe de evento ErrorLogErrorLog Event Class

Classe de evento EventLogEventLog Event Class

Classe de evento ExceptionException Event Class

Classe de evento Exchange SpillExchange Spill Event Class

Classe de evento Execution WarningsExecution Warnings Event Class

Classe de evento Hash WarningHash Warning Event Class

Classe de evento Missing Column StatisticsMissing Column Statistics Event Class

Classe de evento Missing Join PredicateMissing Join Predicate Event Class

Classe de evento Sort WarningsSort Warnings Event Class

Classe de evento User Error MessageUser Error Message Event Class
A Categoria de Evento de Texto Completo contém as classes de evento que são produzidas quando as pesquisas de texto completo são iniciadas, interrompidas ou paradas.The Full Text Event Category includes event classes that are produced when full-text searches are started, interrupted, or stopped. Classe de evento FT:Crawl AbortedFT:Crawl Aborted Event Class

Classe de evento FT:Crawl StartedFT:Crawl Started Event Class

Classe de evento FT:Crawl StoppedFT:Crawl Stopped Event Class
A Categoria de Evento de Bloqueios contém as classes de evento que são produzidas quando um bloqueio é adquirido, cancelado, liberado, ou quando qualquer outra ação é executada nele.The Locks Event Category includes event classes that are produced when a lock is acquired, cancelled, released, or has some other action performed on it. Classe de evento Deadlock GraphDeadlock Graph Event Class

Classe de evento Lock:AcquiredLock:Acquired Event Class

Classe de evento Lock:CancelLock:Cancel Event Class

Classe de evento Lock:Deadlock ChainLock:Deadlock Chain Event Class

Classe de evento Lock:DeadlockLock:Deadlock Event Class

Classe de evento Lock:EscalationLock:Escalation Event Class

Classe de evento Lock:ReleasedLock:Released Event Class

Classe de evento Lock:Timeout (timeout > 0)Lock:Timeout (timeout > 0) Event Class

Classe de evento Lock:TimeoutLock:Timeout Event Class
A Categoria de Evento de Objetos contém as classes de evento que são produzidas quando os objetos de banco de dados são criados, abertos, fechados, descartados ou excluídos.The Objects Event Category includes event classes that are produced when database objects are created, opened, closed, dropped, or deleted. Classe de evento Auto StatsAuto Stats Event Class

Classe de evento Object:AlteredObject:Altered Event Class

Classe de evento Object:CreatedObject:Created Event Class

Classe de evento Object:DeletedObject:Deleted Event Class
A Categoria de Evento OLEDB contém as classes de evento que são produzidas pelo OLE DB.The OLEDB Event Category includes event classes that are produced by OLE DB calls. Classe de evento OLEDB CallOLEDB Call Event Class

Classe de evento OLEDB DataReadOLEDB DataRead Event Class

Classe de evento OLEDB ErrorsOLEDB Errors Event Class

Classe de evento OLEDB Provider InformationOLEDB Provider Information Event Class

Classe de evento OLEDB QueryInterfaceOLEDB QueryInterface Event Class
A Categoria de Evento de Desempenho contém as classes de evento que são produzidas quando os operadores DML (linguagem de manipulação de dados) do SQL são executados.The Performance Event Category includes event classes that are produced when SQL data manipulation language (DML) operators execute. Classe de evento Grau de Paralelismo (7.0 Insert)Degree of Parallelism (7.0 Insert) Event Class

Classe de evento Performance StatisticsPerformance Statistics Event Class

Classe de evento Showplan AllShowplan All Event Class

Classe de evento Showplan All for Query CompileShowplan All for Query Compile Event Class

Classe de Evento Showplan Statistics ProfileShowplan Statistics Profile Event Class

Classe de evento Showplan TextShowplan Text Event Class

Texto do plano de execução (Não codificado) Classe de EventoShowplan Text (Unencoded) Event Class

Classe de evento Showplan XMLShowplan XML Event Class

Classe de evento Showplan XML for Query CompileShowplan XML for Query Compile Event Class

Classe de evento Showplan XML Statistics ProfileShowplan XML Statistics Profile Event Class

Classe de evento SQL:FullTextQuerySQL:FullTextQuery Event Class
A Categoria de Evento Relatório de Progresso inclui a classe de evento Relatório de Progresso: Operação de Índice Online.The Progress Report Event Category includes the Progress Report: Online Index Operation event class. Relatório de andamento: Classe de evento Operação de Índice OnlineProgress Report: Online Index Operation Event Class
A Categoria de Evento de Varreduras contém as classes de evento que são produzidas quando tabelas e índices são verificados.The Scans Event Category includes event classes that are produced when tables and indexes are scanned. Classe de evento Scan:StartedScan:Started Event Class

Classe de evento Scan:StoppedScan:Stopped Event Class
A Categoria de evento de Auditoria de Segurança contém as classes de evento que são usadas para auditoria da atividade do servidor.The Security Audit Event Category includes event classes that are used to audit server activity. Classe de evento Audit Add DB UserAudit Add DB User Event Class

Classe de evento Audit Add Login to Server RoleAudit Add Login to Server Role Event Class

Classe de evento Audit Add Member to DB RoleAudit Add Member to DB Role Event Class

Classe de evento Audit Add RoleAudit Add Role Event Class

Classe de evento Audit AddloginAudit Addlogin Event Class

Classe de evento Audit App Role Change PasswordAudit App Role Change Password Event Class

Classe de evento Audit Backup e RestoreAudit Backup and Restore Event Class

Classe de evento Audit Broker ConversationAudit Broker Conversation Event Class

Classe de evento Audit Broker LoginAudit Broker Login Event Class

Classe de evento Audit Change AuditAudit Change Audit Event Class

Classe de evento Audit Change Database OwnerAudit Change Database Owner Event Class

Classe de evento Audit Database ManagementAudit Database Management Event Class

Classe de evento Audit Database Object AccessAudit Database Object Access Event Class

Classe de evento Audit Database Object GDRAudit Database Object GDR Event Class

Classe de evento Audit Database Object ManagementAudit Database Object Management Event Class

Classe de evento Audit Database Object Take OwnershipAudit Database Object Take Ownership Event Class

Classe de evento Audit Database OperationAudit Database Operation Event Class

Classe de evento Audit Database Principal ImpersonationAudit Database Principal Impersonation Event Class

Classe de evento Audit Database Principal ManagementAudit Database Principal Management Event Class

Classe de evento Audit Database Scope GDRAudit Database Scope GDR Event Class

Classe de evento Audit DBCCAudit DBCC Event Class

Classe de evento Audit Login Change PasswordAudit Login Change Password Event Class

Classe de evento Audit Login Change PropertyAudit Login Change Property Event Class

Classe de evento Audit LoginAudit Login Event Class

Classe de evento Audit Login FailedAudit Login Failed Event Class

Classe de evento Audit Login GDRAudit Login GDR Event Class

Classe de evento Audit LogoutAudit Logout Event Class

Classe de evento Audit Object Derived PermissionAudit Object Derived Permission Event Class

Classe de evento Audit Schema Object AccessAudit Schema Object Access Event Class

Classe de evento Audit Schema Object GDRAudit Schema Object GDR Event Class

Classe de evento Audit Schema Object ManagementAudit Schema Object Management Event Class

Classe de evento Audit Schema Object Take OwnershipAudit Schema Object Take Ownership Event Class

Classe de evento Audit Server Alter TraceAudit Server Alter Trace Event Class

Classe de evento Audit Server Object GDRAudit Server Object GDR Event Class

Classe de evento Audit Server Object ManagementAudit Server Object Management Event Class

Classe de evento Audit Server Object Take OwnershipAudit Server Object Take Ownership Event Class

Classe de evento Audit Server OperationAudit Server Operation Event Class

Classe de evento Audit Server Principal ImpersonationAudit Server Principal Impersonation Event Class

Classe de evento Audit Server Principal ManagementAudit Server Principal Management Event Class

Classe de evento Audit Server Scope GDRAudit Server Scope GDR Event Class

Classe de evento Audit Server Starts and StopsAudit Server Starts and Stops Event Class

Classe de evento Audit Statement PermissionAudit Statement Permission Event Class
A Categoria de Evento de Servidor contém eventos gerais de servidor.The Server Event Category contains general server events. Classe de evento Mount TapeMount Tape Event Class

Classe de evento Server Memory ChangeServer Memory Change Event Class

Classe de evento Trace File CloseTrace File Close Event Class
A Categoria de Evento de Sessões contém as classes de evento produzidas por clientes que se conectam e desconectam de uma instância do SQL ServerSQL Server.The Sessions Event Category includes event classes produced by clients connecting to and disconnecting from an instance of SQL ServerSQL Server. Classe de evento ExistingConnectionExistingConnection Event Class
A Categoria de Evento de Procedimentos Armazenados inclui as classes de evento produzidas pela execução de procedimentos armazenados.The Stored Procedures Event Category includes event classes produced by the execution of stored procedures. Classe de evento PreConnect:CompletedPreConnect:Completed Event Class

Classe de evento PreConnect:StartingPreConnect:Starting Event Class

Classe de evento RPC:CompletedRPC:Completed Event Class

Classe de evento RPC Output ParameterRPC Output Parameter Event Class

Classe de evento RPC:StartingRPC:Starting Event Class

Classe de evento SP:CacheHitSP:CacheHit Event Class

Classe de evento SP:CacheInsertSP:CacheInsert Event Class

Classe de evento SP:CacheMissSP:CacheMiss Event Class

Classe de evento SP:CacheRemoveSP:CacheRemove Event Class

Classe de evento SP:CompletedSP:Completed Event Class

Classe de evento SP:RecompileSP:Recompile Event Class

Classe de evento SP:StartingSP:Starting Event Class

Classe de evento SP:StmtCompletedSP:StmtCompleted Event Class

Classe de evento SP:StmtStartingSP:StmtStarting Event Class
A Categoria de Evento de Transações contém as classes de evento produzidas pela execução de transações do Coordenador de transações distribuídas da MicrosoftMicrosoft ou pela gravação no log de transações.The Transactions Event Category includes event classes produced by the execution of MicrosoftMicrosoft Distributed Transaction Coordinator transactions or by writing to the transaction log. Classe de evento DTCTransactionDTCTransaction Event Class

Classe de evento SQLTransactionSQLTransaction Event Class

TM: Classe de evento Begin Tran CompletedTM: Begin Tran Completed Event Class

TM: Classe de evento Begin Tran StartingTM: Begin Tran Starting Event Class

TM: Classe de evento Commit Tran CompletedTM: Commit Tran Completed Event Class

TM: Classe de evento Commit Tran StartingTM: Commit Tran Starting Event Class

TM: Classe de evento Promote Tran CompletedTM: Promote Tran Completed Event Class

TM: Classe de evento Promote Tran StartingTM: Promote Tran Starting Event Class

TM: Classe de evento Rollback Tran CompletedTM: Rollback Tran Completed Event Class

TM: Classe de evento Rollback Tran StartingTM: Rollback Tran Starting Event Class

TM: Classe de evento Save Tran CompletedTM: Save Tran Completed Event Class

TM: Classe de evento Save Tran StartingTM: Save Tran Starting Event Class

Classe de evento TransactionLogTransactionLog Event Class
A Categoria de Evento TSQL contém as classes de evento produzidas pela execução de instruções Transact-SQL passadas do cliente para uma instância do SQL ServerSQL Server .The TSQL Event Category includes event classes produced by the execution of Transact-SQL statements passed to an instance of SQL ServerSQL Server from the client. Classe de evento Exec Prepared SQLExec Prepared SQL Event Class

Classe de evento Prepare SQLPrepare SQL Event Class

Classe de evento SQL:BatchCompletedSQL:BatchCompleted Event Class

Classe de evento SQL:BatchStartingSQL:BatchStarting Event Class

Classe de evento SQL:StmtCompletedSQL:StmtCompleted Event Class

Classe de evento SQL:StmtRecompileSQL:StmtRecompile Event Class

Classe de evento SQL:StmtStartingSQL:StmtStarting Event Class

Classe de evento Unprepare SQLUnprepare SQL Event Class

Classe de evento XQuery Static TypeXQuery Static Type Event Class
A Categoria de Evento Configurável pelo Usuário inclui classes de evento que você pode definir.The User-Configurable Event Category includes event classes that you can define. Classe de evento User-ConfigurableUser-Configurable Event Class

Consulte TambémSee Also

SQL Server ProfilerSQL Server Profiler