--- title: "SQL Server Event Class Reference | Microsoft Docs" ms.custom: "" ms.date: "07/24/2017" ms.prod: "sql-server-2014" ms.reviewer: "" ms.suite: "" ms.technology: - "database-engine" ms.tgt_pltfrm: "" ms.topic: "article" topic_type: - "apiref" helpviewer_keywords: - "events [SQL Server], event classes" - "event classes [SQL Server], listed" - "event classes [SQL Server]" - "SQL Server event classes, listed" - "SQL Server event classes" ms.assetid: 0f0fe567-e115-4ace-b63c-73dc3428c0f6 caps.latest.revision: 33 author: "JennieHubbard" ms.author: "jhubbard" manager: "jhubbard" --- # SQL Server Event Class Reference [!INCLUDE[ssSqlProfiler](../includes/sssqlprofiler-md.md)] lets you record events as they occur in an instance of the [!INCLUDE[msCoName](../includes/msconame-md.md)] [!INCLUDE[ssDEnoversion](../includes/ssdenoversion-md.md)]. The recorded events are instances of the event classes in the trace definition. In [!INCLUDE[ssSqlProfiler](../includes/sssqlprofiler-md.md)], event classes and their event categories are available on the **Events Selection** tab of the **Trace File Properties** dialog box. The following table describes the event categories and lists their associated event classes. |Event Category|Event Classes| |--------------------|-------------------| |The [Broker Event Category](../../2014/database-engine/broker-event-category.md) includes event classes that are produced by the [!INCLUDE[ssSB](../includes/sssb-md.md)].|[Broker:Activation Event Class](../../2014/database-engine/broker-activation-event-class.md)

[Broker:Connection Event Class](../../2014/database-engine/broker-connection-event-class.md)

[Broker:Conversation Event Class](../../2014/database-engine/broker-conversation-event-class.md)

[Broker:Conversation Group Event Class](../../2014/database-engine/broker-conversation-group-event-class.md)

[Broker:Corrupted Message Event Class](../../2014/database-engine/broker-corrupted-message-event-class.md)

[Broker:Forwarded Message Dropped Event Class](../../2014/database-engine/broker-forwarded-message-dropped-event-class.md)

[Broker:Forwarded Message Sent Event Class](../../2014/database-engine/broker-forwarded-message-sent-event-class.md)

[Broker:Message Classify Event Class](../../2014/database-engine/broker-message-classify-event-class.md)

[Broker:Message Drop Event Class](../Topic/Broker:Message%20Drop%20Event%20Class.md)

[Broker:Remote Message Ack Event Class](../../2014/database-engine/broker-remote-message-ack-event-class.md)| |The [Cursors Event Category](../../2014/database-engine/cursors-event-category.md) includes event classes that are produced by cursor operations.|[CursorClose Event Class](../../2014/database-engine/cursorclose-event-class.md)

[CursorExecute Event Class](../../2014/database-engine/cursorexecute-event-class.md)

[CursorImplicitConversion Event Class](../../2014/database-engine/cursorimplicitconversion-event-class.md)

[CursorOpen Event Class](../../2014/database-engine/cursoropen-event-class.md)

[CursorPrepare Event Class](../../2014/database-engine/cursorprepare-event-class.md)

[CursorRecompile Event Class](../../2014/database-engine/cursorrecompile-event-class.md)

[CursorUnprepare Event Class](../../2014/database-engine/cursorunprepare-event-class.md)| |The [CLR Event Category](../../2014/database-engine/clr-event-category.md) includes event classes that are produced by the execution of .NET common language runtime (CLR) objects.|[Assembly Load Event Class](../../2014/database-engine/assembly-load-event-class.md)| |The [Database Event Category](../../2014/database-engine/database-event-category.md) includes event classes that are produced when data or log files grow or shrink automatically.|[Data File Auto Grow Event Class](../../2014/database-engine/data-file-auto-grow-event-class.md)

[Data File Auto Shrink Event Class](../../2014/database-engine/data-file-auto-shrink-event-class.md)

[Database Mirroring State Change Event Class](../../2014/database-engine/database-mirroring-state-change-event-class.md)

[Log File Auto Grow Event Class](../../2014/database-engine/log-file-auto-grow-event-class.md)

[Log File Auto Shrink Event Class](../../2014/database-engine/log-file-auto-shrink-event-class.md)| |The [Deprecation Event Category](../../2014/database-engine/deprecation-event-category.md) includes deprecation related events.|[Deprecation Announcement Event Class](../../2014/database-engine/deprecation-announcement-event-class.md)

[Deprecation Final Support Event Class](../../2014/database-engine/deprecation-final-support-event-class.md)| |The [Errors and Warnings Event Category (Database Engine)](../../2014/database-engine/errors-and-warnings-event-category-database-engine.md) includes event classes that are produced when a [!INCLUDE[ssNoVersion](../includes/ssnoversion-md.md)] error or warning is returned, for example, if an error occurs during the compilation of a stored procedure or an exception occurs in [!INCLUDE[ssNoVersion](../includes/ssnoversion-md.md)].|[Attention Event Class](../../2014/database-engine/attention-event-class.md)

[Background Job Error Event Class](../../2014/database-engine/background-job-error-event-class.md)

[Blocked Process Report Event Class](../../2014/database-engine/blocked-process-report-event-class.md)

[CPU Threshold Exceeded Event Class](../../2014/database-engine/cpu-threshold-exceeded-event-class.md)

[ErrorLog Event Class](../../2014/database-engine/errorlog-event-class.md)

[EventLog Event Class](../../2014/database-engine/eventlog-event-class.md)

[Exception Event Class](../../2014/database-engine/exception-event-class.md)

[Exchange Spill Event Class](../../2014/database-engine/exchange-spill-event-class.md)

[Execution Warnings Event Class](../../2014/database-engine/execution-warnings-event-class.md)

[Hash Warning Event Class](../../2014/database-engine/hash-warning-event-class.md)

[Missing Column Statistics Event Class](../../2014/database-engine/missing-column-statistics-event-class.md)

[Missing Join Predicate Event Class](../../2014/database-engine/missing-join-predicate-event-class.md)

[Sort Warnings Event Class](../../2014/database-engine/sort-warnings-event-class.md)

[User Error Message Event Class](../../2014/database-engine/user-error-message-event-class.md)| |The [Full Text Event Category](../../2014/database-engine/full-text-event-category.md) includes event classes that are produced when full-text searches are started, interrupted, or stopped.|[FT:Crawl Aborted Event Class](../../2014/database-engine/ft-crawl-aborted-event-class.md)

[FT:Crawl Started Event Class](../../2014/database-engine/ft-crawl-started-event-class.md)

[FT:Crawl Stopped Event Class](../../2014/database-engine/ft-crawl-stopped-event-class.md)| |The [Locks Event Category](../../2014/database-engine/locks-event-category.md) includes event classes that are produced when a lock is acquired, cancelled, released, or has some other action performed on it.|[Deadlock Graph Event Class](../../2014/database-engine/deadlock-graph-event-class.md)

[Lock:Acquired Event Class](../../2014/database-engine/lock-acquired-event-class.md)

[Lock:Cancel Event Class](../../2014/database-engine/lock-cancel-event-class.md)

[Lock:Deadlock Chain Event Class](../../2014/database-engine/lock-deadlock-chain-event-class.md)

[Lock:Deadlock Event Class](../../2014/database-engine/lock-deadlock-event-class.md)

[Lock:Escalation Event Class](../../2014/database-engine/lock-escalation-event-class.md)

[Lock:Released Event Class](../../2014/database-engine/lock-released-event-class.md)

[Lock:Timeout (timeout > 0) Event Class](../../2014/database-engine/lock-timeout-timeout-0-event-class.md)

[Lock:Timeout Event Class](../../2014/database-engine/lock-timeout-event-class.md)| |The [Objects Event Category](../../2014/database-engine/objects-event-category.md) includes event classes that are produced when database objects are created, opened, closed, dropped, or deleted.|[Auto Stats Event Class](../../2014/database-engine/auto-stats-event-class.md)

[Object:Altered Event Class](../../2014/database-engine/object-altered-event-class.md)

[Object:Created Event Class](../../2014/database-engine/object-created-event-class.md)

[Object:Deleted Event Class](../../2014/database-engine/object-deleted-event-class.md)| |The [OLEDB Event Category](../../2014/database-engine/oledb-event-category.md) includes event classes that are produced by OLE DB calls.|[OLEDB Call Event Class](../../2014/database-engine/oledb-call-event-class.md)

[OLEDB DataRead Event Class](../../2014/database-engine/oledb-dataread-event-class.md)

[OLEDB Errors Event Class](../../2014/database-engine/oledb-errors-event-class.md)

[OLEDB Provider Information Event Class](../../2014/database-engine/oledb-provider-information-event-class.md)

[OLEDB QueryInterface Event Class](../../2014/database-engine/oledb-queryinterface-event-class.md)| |The [Performance Event Category](../../2014/database-engine/performance-event-category.md) includes event classes that are produced when SQL data manipulation language (DML) operators execute.|[Degree of Parallelism (7.0 Insert) Event Class](../../2014/database-engine/degree-of-parallelism-7-0-insert-event-class.md)

[Performance Statistics Event Class](../../2014/database-engine/performance-statistics-event-class.md)

[Showplan All Event Class](../../2014/database-engine/showplan-all-event-class.md)

[Showplan All for Query Compile Event Class](../../2014/database-engine/showplan-all-for-query-compile-event-class.md)

[Showplan Statistics Profile Event Class](../../2014/database-engine/showplan-statistics-profile-event-class.md)

[Showplan Text Event Class](../../2014/database-engine/showplan-text-event-class.md)

[Showplan Text (Unencoded) Event Class](../../2014/database-engine/showplan-text-unencoded-event-class.md)

[Showplan XML Event Class](../../2014/database-engine/showplan-xml-event-class.md)

[Showplan XML for Query Compile Event Class](../../2014/database-engine/showplan-xml-for-query-compile-event-class.md)

[Showplan XML Statistics Profile Event Class](../../2014/database-engine/showplan-xml-statistics-profile-event-class.md)

[SQL:FullTextQuery Event Class](../../2014/database-engine/sql-fulltextquery-event-class.md)| |The [Progress Report Event Category](../../2014/database-engine/progress-report-event-category.md) includes the **Progress Report: Online Index Operation** event class.|[Progress Report: Online Index Operation Event Class](../../2014/database-engine/progress-report-online-index-operation-event-class.md)| |The [Scans Event Category](../../2014/database-engine/scans-event-category.md) includes event classes that are produced when tables and indexes are scanned.|[Scan:Started Event Class](../../2014/database-engine/scan-started-event-class.md)

[Scan:Stopped Event Class](../../2014/database-engine/scan-stopped-event-class.md)| |The [Security Audit Event Category](../../2014/database-engine/security-audit-event-category-sql-server-profiler.md) includes event classes that are used to audit server activity.|[Audit Add DB User Event Class](../../2014/database-engine/audit-add-db-user-event-class.md)

[Audit Add Login to Server Role Event Class](../../2014/database-engine/audit-add-login-to-server-role-event-class.md)

[Audit Add Member to DB Role Event Class](../../2014/database-engine/audit-add-member-to-db-role-event-class.md)

[Audit Add Role Event Class](../../2014/database-engine/audit-add-role-event-class.md)

[Audit Addlogin Event Class](../../2014/database-engine/audit-addlogin-event-class.md)

[Audit App Role Change Password Event Class](../../2014/database-engine/audit-app-role-change-password-event-class.md)

[Audit Backup and Restore Event Class](../../2014/database-engine/audit-backup-and-restore-event-class.md)

[Audit Broker Conversation Event Class](../../2014/database-engine/audit-broker-conversation-event-class.md)

[Audit Broker Login Event Class](../../2014/database-engine/audit-broker-login-event-class.md)

[Audit Change Audit Event Class](../../2014/database-engine/audit-change-audit-event-class.md)

[Audit Change Database Owner Event Class](../../2014/database-engine/audit-change-database-owner-event-class.md)

[Audit Database Management Event Class](../../2014/database-engine/audit-database-management-event-class.md)

[Audit Database Object Access Event Class](../../2014/database-engine/audit-database-object-access-event-class.md)

[Audit Database Object GDR Event Class](../../2014/database-engine/audit-database-object-gdr-event-class.md)

[Audit Database Object Management Event Class](../../2014/database-engine/audit-database-object-management-event-class.md)

[Audit Database Object Take Ownership Event Class](../../2014/database-engine/audit-database-object-take-ownership-event-class.md)

[Audit Database Operation Event Class](../../2014/database-engine/audit-database-operation-event-class.md)

[Audit Database Principal Impersonation Event Class](../../2014/database-engine/audit-database-principal-impersonation-event-class.md)

[Audit Database Principal Management Event Class](../../2014/database-engine/audit-database-principal-management-event-class.md)

[Audit Database Scope GDR Event Class](../../2014/database-engine/audit-database-scope-gdr-event-class.md)

[Audit DBCC Event Class](../../2014/database-engine/audit-dbcc-event-class.md)

[Audit Login Change Password Event Class](../../2014/database-engine/audit-login-change-password-event-class.md)

[Audit Login Change Property Event Class](../../2014/database-engine/audit-login-change-property-event-class.md)

[Audit Login Event Class](../../2014/database-engine/audit-login-event-class.md)

[Audit Login Failed Event Class](../../2014/database-engine/audit-login-failed-event-class.md)

[Audit Login GDR Event Class](../../2014/database-engine/audit-login-gdr-event-class.md)

[Audit Logout Event Class](../../2014/database-engine/audit-logout-event-class.md)

[Audit Object Derived Permission Event Class](../../2014/database-engine/audit-object-derived-permission-event-class.md)

[Audit Schema Object Access Event Class](../../2014/database-engine/audit-schema-object-access-event-class.md)

[Audit Schema Object GDR Event Class](../../2014/database-engine/audit-schema-object-gdr-event-class.md)

[Audit Schema Object Management Event Class](../../2014/database-engine/audit-schema-object-management-event-class.md)

[Audit Schema Object Take Ownership Event Class](../../2014/database-engine/audit-schema-object-take-ownership-event-class.md)

[Audit Server Alter Trace Event Class](../../2014/database-engine/audit-server-alter-trace-event-class.md)

[Audit Server Object GDR Event Class](../../2014/database-engine/audit-server-object-gdr-event-class.md)

[Audit Server Object Management Event Class](../../2014/database-engine/audit-server-object-management-event-class.md)

[Audit Server Object Take Ownership Event Class](../../2014/database-engine/audit-server-object-take-ownership-event-class.md)

[Audit Server Operation Event Class](../../2014/database-engine/audit-server-operation-event-class.md)

[Audit Server Principal Impersonation Event Class](../../2014/database-engine/audit-server-principal-impersonation-event-class.md)

[Audit Server Principal Management Event Class](../../2014/database-engine/audit-server-principal-management-event-class.md)

[Audit Server Scope GDR Event Class](../../2014/database-engine/audit-server-scope-gdr-event-class.md)

[Audit Server Starts and Stops Event Class](../../2014/database-engine/audit-server-starts-and-stops-event-class.md)

[Audit Statement Permission Event Class](../../2014/database-engine/audit-statement-permission-event-class.md)| |The [Server Event Category](../../2014/database-engine/server-event-category.md) contains general server events.|[Mount Tape Event Class](../../2014/database-engine/mount-tape-event-class.md)

[Server Memory Change Event Class](../../2014/database-engine/server-memory-change-event-class.md)

[Trace File Close Event Class](../../2014/database-engine/trace-file-close-event-class.md)| |The [Sessions Event Category](../../2014/database-engine/sessions-event-category.md) includes event classes produced by clients connecting to and disconnecting from an instance of [!INCLUDE[ssNoVersion](../includes/ssnoversion-md.md)].|[ExistingConnection Event Class](../../2014/database-engine/existingconnection-event-class.md)| |The [Stored Procedures Event Category](../../2014/database-engine/stored-procedures-event-category.md) includes event classes produced by the execution of stored procedures.|[PreConnect:Completed Event Class](../../2014/database-engine/preconnect-completed-event-class.md)

[PreConnect:Starting Event Class](../../2014/database-engine/preconnect-starting-event-class.md)

[RPC:Completed Event Class](../../2014/database-engine/rpc-completed-event-class.md)

[RPC Output Parameter Event Class](../../2014/database-engine/rpc-output-parameter-event-class.md)

[RPC:Starting Event Class](../../2014/database-engine/rpc-starting-event-class.md)

[SP:CacheHit Event Class](../../2014/database-engine/sp-cachehit-event-class.md)

[SP:CacheInsert Event Class](../../2014/database-engine/sp-cacheinsert-event-class.md)

[SP:CacheMiss Event Class](../../2014/database-engine/sp-cachemiss-event-class.md)

[SP:CacheRemove Event Class](../../2014/database-engine/sp-cacheremove-event-class.md)

[SP:Completed Event Class](../../2014/database-engine/sp-completed-event-class.md)

[SP:Recompile Event Class](../../2014/database-engine/sp-recompile-event-class.md)

[SP:Starting Event Class](../../2014/database-engine/sp-starting-event-class.md)

[SP:StmtCompleted Event Class](../../2014/database-engine/sp-stmtcompleted-event-class.md)

[SP:StmtStarting Event Class](../../2014/database-engine/sp-stmtstarting-event-class.md)| |The [Transactions Event Category](../../2014/database-engine/transactions-event-category.md) includes event classes produced by the execution of [!INCLUDE[msCoName](../includes/msconame-md.md)] Distributed Transaction Coordinator transactions or by writing to the transaction log.|[DTCTransaction Event Class](../../2014/database-engine/dtctransaction-event-class.md)

[SQLTransaction Event Class](../../2014/database-engine/sqltransaction-event-class.md)

[TM: Begin Tran Completed Event Class](../../2014/database-engine/tm-begin-tran-completed-event-class.md)

[TM: Begin Tran Starting Event Class](../../2014/database-engine/tm-begin-tran-starting-event-class.md)

[TM: Commit Tran Completed Event Class](../../2014/database-engine/tm-commit-tran-completed-event-class.md)

[TM: Commit Tran Starting Event Class](../../2014/database-engine/tm-commit-tran-starting-event-class.md)

[TM: Promote Tran Completed Event Class](../../2014/database-engine/tm-promote-tran-completed-event-class.md)

[TM: Promote Tran Starting Event Class](../../2014/database-engine/tm-promote-tran-starting-event-class.md)

[TM: Rollback Tran Completed Event Class](../../2014/database-engine/tm-rollback-tran-completed-event-class.md)

[TM: Rollback Tran Starting Event Class](../../2014/database-engine/tm-rollback-tran-starting-event-class.md)

[TM: Save Tran Completed Event Class](../../2014/database-engine/tm-save-tran-completed-event-class.md)

[TM: Save Tran Starting Event Class](../../2014/database-engine/tm-save-tran-starting-event-class.md)

[TransactionLog Event Class](../../2014/database-engine/transactionlog-event-class.md)| |The [TSQL Event Category](../../2014/database-engine/tsql-event-category.md) includes event classes produced by the execution of Transact-SQL statements passed to an instance of [!INCLUDE[ssNoVersion](../includes/ssnoversion-md.md)] from the client.|[Exec Prepared SQL Event Class](../../2014/database-engine/exec-prepared-sql-event-class.md)

[Prepare SQL Event Class](../../2014/database-engine/prepare-sql-event-class.md)

[SQL:BatchCompleted Event Class](../../2014/database-engine/sql-batchcompleted-event-class.md)

[SQL:BatchStarting Event Class](../../2014/database-engine/sql-batchstarting-event-class.md)

[SQL:StmtCompleted Event Class](../../2014/database-engine/sql-stmtcompleted-event-class.md)

[SQL:StmtRecompile Event Class](../../2014/database-engine/sql-stmtrecompile-event-class.md)

[SQL:StmtStarting Event Class](../../2014/database-engine/sql-stmtstarting-event-class.md)

[Unprepare SQL Event Class](../../2014/database-engine/unprepare-sql-event-class.md)

[XQuery Static Type Event Class](../../2014/database-engine/xquery-static-type-event-class.md)| |The [User-Configurable Event Category](../../2014/database-engine/user-configurable-event-category.md) includes event classes that you can define.|[User-Configurable Event Class](../../2014/database-engine/user-configurable-event-class.md)| ## See Also [SQL Server Profiler](../../2014/database-engine/sql-server-profiler.md)