--- title: "SQL Server Event Class Reference | Microsoft Docs" ms.custom: "" ms.date: "03/14/2017" ms.prod: "sql" ms.prod_service: "database-engine, sql-database" ms.service: "" ms.component: "event-classes" ms.reviewer: "" ms.suite: "sql" ms.technology: - "database-engine" ms.tgt_pltfrm: "" ms.topic: "article" 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: 34 author: "stevestein" ms.author: "sstein" manager: "craigg" ms.workload: "On Demand" monikerRange: "= azuresqldb-current || >= sql-server-2016 || = sqlallproducts-allversions" --- # SQL Server Event Class Reference [!INCLUDE[appliesto-ss-asdb-xxxx-xxx-md](../../includes/appliesto-ss-asdb-xxxx-xxx-md.md)] [!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](../../relational-databases/event-classes/broker-event-category.md) includes event classes that are produced by the [!INCLUDE[ssSB](../../includes/sssb-md.md)].|[Broker:Activation Event Class](../../relational-databases/event-classes/broker-activation-event-class.md)

[Broker:Connection Event Class](../../relational-databases/event-classes/broker-connection-event-class.md)

[Broker:Conversation Event Class](../../relational-databases/event-classes/broker-conversation-event-class.md)

[Broker:Conversation Group Event Class](../../relational-databases/event-classes/broker-conversation-group-event-class.md)

[Broker:Corrupted Message Event Class](../../relational-databases/event-classes/broker-corrupted-message-event-class.md)

[Broker:Forwarded Message Dropped Event Class](../../relational-databases/event-classes/broker-forwarded-message-dropped-event-class.md)

[Broker:Forwarded Message Sent Event Class](../../relational-databases/event-classes/broker-forwarded-message-sent-event-class.md)

[Broker:Message Classify Event Class](../../relational-databases/event-classes/broker-message-classify-event-class.md)

[Broker:Message Drop Event Class](../../relational-databases/event-classes/broker-message-drop-event-class.md)

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

[CursorExecute Event Class](../../relational-databases/event-classes/cursorexecute-event-class.md)

[CursorImplicitConversion Event Class](../../relational-databases/event-classes/cursorimplicitconversion-event-class.md)

[CursorOpen Event Class](../../relational-databases/event-classes/cursoropen-event-class.md)

[CursorPrepare Event Class](../../relational-databases/event-classes/cursorprepare-event-class.md)

[CursorRecompile Event Class](../../relational-databases/event-classes/cursorrecompile-event-class.md)

[CursorUnprepare Event Class](../../relational-databases/event-classes/cursorunprepare-event-class.md)| |The [CLR Event Category](../../relational-databases/event-classes/clr-event-category.md) includes event classes that are produced by the execution of .NET common language runtime (CLR) objects.|[Assembly Load Event Class](http://msdn.microsoft.com/library/cfb0b69d-4ce0-4067-a3df-d82775e57886)| |The [Database Event Category](../../relational-databases/event-classes/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](../../relational-databases/event-classes/data-file-auto-grow-event-class.md)

[Data File Auto Shrink Event Class](../../relational-databases/event-classes/data-file-auto-shrink-event-class.md)

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

[Log File Auto Grow Event Class](../../relational-databases/event-classes/log-file-auto-grow-event-class.md)

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

[Deprecation Final Support Event Class](../../relational-databases/event-classes/deprecation-final-support-event-class.md)| |The [Errors and Warnings Event Category (Database Engine)](../../relational-databases/event-classes/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](../../relational-databases/event-classes/attention-event-class.md)

[Background Job Error Event Class](../../relational-databases/event-classes/background-job-error-event-class.md)

[Blocked Process Report Event Class](../../relational-databases/event-classes/blocked-process-report-event-class.md)

[CPU Threshold Exceeded Event Class](../../relational-databases/event-classes/cpu-threshold-exceeded-event-class.md)

[ErrorLog Event Class](../../relational-databases/event-classes/errorlog-event-class.md)

[EventLog Event Class](../../relational-databases/event-classes/eventlog-event-class.md)

[Exception Event Class](../../relational-databases/event-classes/exception-event-class.md)

[Exchange Spill Event Class](../../relational-databases/event-classes/exchange-spill-event-class.md)

[Execution Warnings Event Class](../../relational-databases/event-classes/execution-warnings-event-class.md)

[Hash Warning Event Class](../../relational-databases/event-classes/hash-warning-event-class.md)

[Missing Column Statistics Event Class](../../relational-databases/event-classes/missing-column-statistics-event-class.md)

[Missing Join Predicate Event Class](../../relational-databases/event-classes/missing-join-predicate-event-class.md)

[Sort Warnings Event Class](../../relational-databases/event-classes/sort-warnings-event-class.md)

[User Error Message Event Class](../../relational-databases/event-classes/user-error-message-event-class.md)| |The [Full Text Event Category](../../relational-databases/event-classes/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](../../relational-databases/event-classes/ft-crawl-aborted-event-class.md)

[FT:Crawl Started Event Class](../../relational-databases/event-classes/ft-crawl-started-event-class.md)

[FT:Crawl Stopped Event Class](../../relational-databases/event-classes/ft-crawl-stopped-event-class.md)| |The [Locks Event Category](../../relational-databases/event-classes/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](../../relational-databases/event-classes/deadlock-graph-event-class.md)

[Lock:Acquired Event Class](../../relational-databases/event-classes/lock-acquired-event-class.md)

[Lock:Cancel Event Class](../../relational-databases/event-classes/lock-cancel-event-class.md)

[Lock:Deadlock Chain Event Class](../../relational-databases/event-classes/lock-deadlock-chain-event-class.md)

[Lock:Deadlock Event Class](../../relational-databases/event-classes/lock-deadlock-event-class.md)

[Lock:Escalation Event Class](../../relational-databases/event-classes/lock-escalation-event-class.md)

[Lock:Released Event Class](../../relational-databases/event-classes/lock-released-event-class.md)

[Lock:Timeout (timeout > 0) Event Class](../../relational-databases/event-classes/lock-timeout-timeout-0-event-class.md)

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

[Object:Altered Event Class](../../relational-databases/event-classes/object-altered-event-class.md)

[Object:Created Event Class](../../relational-databases/event-classes/object-created-event-class.md)

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

[OLEDB DataRead Event Class](../../relational-databases/event-classes/oledb-dataread-event-class.md)

[OLEDB Errors Event Class](../../relational-databases/event-classes/oledb-errors-event-class.md)

[OLEDB Provider Information Event Class](../../relational-databases/event-classes/oledb-provider-information-event-class.md)

[OLEDB QueryInterface Event Class](../../relational-databases/event-classes/oledb-queryinterface-event-class.md)| |The [Performance Event Category](../../relational-databases/event-classes/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](../../relational-databases/event-classes/degree-of-parallelism-7-0-insert-event-class.md)

[Performance Statistics Event Class](../../relational-databases/event-classes/performance-statistics-event-class.md)

[Showplan All Event Class](../../relational-databases/event-classes/showplan-all-event-class.md)

[Showplan All for Query Compile Event Class](../../relational-databases/event-classes/showplan-all-for-query-compile-event-class.md)

[Showplan Statistics Profile Event Class](../../relational-databases/event-classes/showplan-statistics-profile-event-class.md)

[Showplan Text Event Class](../../relational-databases/event-classes/showplan-text-event-class.md)

[Showplan Text (Unencoded) Event Class](../../relational-databases/event-classes/showplan-text-unencoded-event-class.md)

[Showplan XML Event Class](../../relational-databases/event-classes/showplan-xml-event-class.md)

[Showplan XML for Query Compile Event Class](../../relational-databases/event-classes/showplan-xml-for-query-compile-event-class.md)

[Showplan XML Statistics Profile Event Class](../../relational-databases/event-classes/showplan-xml-statistics-profile-event-class.md)

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

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

[Audit Add Login to Server Role Event Class](../../relational-databases/event-classes/audit-add-login-to-server-role-event-class.md)

[Audit Add Member to DB Role Event Class](../../relational-databases/event-classes/audit-add-member-to-db-role-event-class.md)

[Audit Add Role Event Class](../../relational-databases/event-classes/audit-add-role-event-class.md)

[Audit Addlogin Event Class](../../relational-databases/event-classes/audit-addlogin-event-class.md)

[Audit App Role Change Password Event Class](../../relational-databases/event-classes/audit-app-role-change-password-event-class.md)

[Audit Backup and Restore Event Class](../../relational-databases/event-classes/audit-backup-and-restore-event-class.md)

[Audit Broker Conversation Event Class](../../relational-databases/event-classes/audit-broker-conversation-event-class.md)

[Audit Broker Login Event Class](../../relational-databases/event-classes/audit-broker-login-event-class.md)

[Audit Change Audit Event Class](../../relational-databases/event-classes/audit-change-audit-event-class.md)

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

[Audit Database Management Event Class](../../relational-databases/event-classes/audit-database-management-event-class.md)

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

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

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

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

[Audit Database Operation Event Class](../../relational-databases/event-classes/audit-database-operation-event-class.md)

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

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

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

[Audit DBCC Event Class](../../relational-databases/event-classes/audit-dbcc-event-class.md)

[Audit Login Change Password Event Class](../../relational-databases/event-classes/audit-login-change-password-event-class.md)

[Audit Login Change Property Event Class](../../relational-databases/event-classes/audit-login-change-property-event-class.md)

[Audit Login Event Class](../../relational-databases/event-classes/audit-login-event-class.md)

[Audit Login Failed Event Class](../../relational-databases/event-classes/audit-login-failed-event-class.md)

[Audit Login GDR Event Class](../../relational-databases/event-classes/audit-login-gdr-event-class.md)

[Audit Logout Event Class](../../relational-databases/event-classes/audit-logout-event-class.md)

[Audit Object Derived Permission Event Class](../../relational-databases/event-classes/audit-object-derived-permission-event-class.md)

[Audit Schema Object Access Event Class](../../relational-databases/event-classes/audit-schema-object-access-event-class.md)

[Audit Schema Object GDR Event Class](../../relational-databases/event-classes/audit-schema-object-gdr-event-class.md)

[Audit Schema Object Management Event Class](../../relational-databases/event-classes/audit-schema-object-management-event-class.md)

[Audit Schema Object Take Ownership Event Class](../../relational-databases/event-classes/audit-schema-object-take-ownership-event-class.md)

[Audit Server Alter Trace Event Class](../../relational-databases/event-classes/audit-server-alter-trace-event-class.md)

[Audit Server Object GDR Event Class](../../relational-databases/event-classes/audit-server-object-gdr-event-class.md)

[Audit Server Object Management Event Class](../../relational-databases/event-classes/audit-server-object-management-event-class.md)

[Audit Server Object Take Ownership Event Class](../../relational-databases/event-classes/audit-server-object-take-ownership-event-class.md)

[Audit Server Operation Event Class](../../relational-databases/event-classes/audit-server-operation-event-class.md)

[Audit Server Principal Impersonation Event Class](../../relational-databases/event-classes/audit-server-principal-impersonation-event-class.md)

[Audit Server Principal Management Event Class](../../relational-databases/event-classes/audit-server-principal-management-event-class.md)

[Audit Server Scope GDR Event Class](../../relational-databases/event-classes/audit-server-scope-gdr-event-class.md)

[Audit Server Starts and Stops Event Class](../../relational-databases/event-classes/audit-server-starts-and-stops-event-class.md)

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

[Server Memory Change Event Class](../../relational-databases/event-classes/server-memory-change-event-class.md)

[Trace File Close Event Class](../../relational-databases/event-classes/trace-file-close-event-class.md)| |The [Sessions Event Category](../../relational-databases/event-classes/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](../../relational-databases/event-classes/existingconnection-event-class.md)| |The [Stored Procedures Event Category](../../relational-databases/event-classes/stored-procedures-event-category.md) includes event classes produced by the execution of stored procedures.|[PreConnect:Completed Event Class](../../relational-databases/event-classes/preconnect-completed-event-class.md)

[PreConnect:Starting Event Class](../../relational-databases/event-classes/preconnect-starting-event-class.md)

[RPC:Completed Event Class](../../relational-databases/event-classes/rpc-completed-event-class.md)

[RPC Output Parameter Event Class](../../relational-databases/event-classes/rpc-output-parameter-event-class.md)

[RPC:Starting Event Class](../../relational-databases/event-classes/rpc-starting-event-class.md)

[SP:CacheHit Event Class](../../relational-databases/event-classes/sp-cachehit-event-class.md)

[SP:CacheInsert Event Class](../../relational-databases/event-classes/sp-cacheinsert-event-class.md)

[SP:CacheMiss Event Class](../../relational-databases/event-classes/sp-cachemiss-event-class.md)

[SP:CacheRemove Event Class](../../relational-databases/event-classes/sp-cacheremove-event-class.md)

[SP:Completed Event Class](../../relational-databases/event-classes/sp-completed-event-class.md)

[SP:Recompile Event Class](../../relational-databases/event-classes/sp-recompile-event-class.md)

[SP:Starting Event Class](../../relational-databases/event-classes/sp-starting-event-class.md)

[SP:StmtCompleted Event Class](../../relational-databases/event-classes/sp-stmtcompleted-event-class.md)

[SP:StmtStarting Event Class](../../relational-databases/event-classes/sp-stmtstarting-event-class.md)| |The [Transactions Event Category](../../relational-databases/event-classes/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](../../relational-databases/event-classes/dtctransaction-event-class.md)

[SQLTransaction Event Class](../../relational-databases/event-classes/sqltransaction-event-class.md)

[TM: Begin Tran Completed Event Class](../../relational-databases/event-classes/tm-begin-tran-completed-event-class.md)

[TM: Begin Tran Starting Event Class](../../relational-databases/event-classes/tm-begin-tran-starting-event-class.md)

[TM: Commit Tran Completed Event Class](../../relational-databases/event-classes/tm-commit-tran-completed-event-class.md)

[TM: Commit Tran Starting Event Class](../../relational-databases/event-classes/tm-commit-tran-starting-event-class.md)

[TM: Promote Tran Completed Event Class](../../relational-databases/event-classes/tm-promote-tran-completed-event-class.md)

[TM: Promote Tran Starting Event Class](../../relational-databases/event-classes/tm-promote-tran-starting-event-class.md)

[TM: Rollback Tran Completed Event Class](../../relational-databases/event-classes/tm-rollback-tran-completed-event-class.md)

[TM: Rollback Tran Starting Event Class](../../relational-databases/event-classes/tm-rollback-tran-starting-event-class.md)

[TM: Save Tran Completed Event Class](../../relational-databases/event-classes/tm-save-tran-completed-event-class.md)

[TM: Save Tran Starting Event Class](../../relational-databases/event-classes/tm-save-tran-starting-event-class.md)

[TransactionLog Event Class](../../relational-databases/event-classes/transactionlog-event-class.md)| |The [TSQL Event Category](../../relational-databases/event-classes/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](../../relational-databases/event-classes/exec-prepared-sql-event-class.md)

[Prepare SQL Event Class](../../relational-databases/event-classes/prepare-sql-event-class.md)

[SQL:BatchCompleted Event Class](../../relational-databases/event-classes/sql-batchcompleted-event-class.md)

[SQL:BatchStarting Event Class](../../relational-databases/event-classes/sql-batchstarting-event-class.md)

[SQL:StmtCompleted Event Class](../../relational-databases/event-classes/sql-stmtcompleted-event-class.md)

[SQL:StmtRecompile Event Class](../../relational-databases/event-classes/sql-stmtrecompile-event-class.md)

[SQL:StmtStarting Event Class](../../relational-databases/event-classes/sql-stmtstarting-event-class.md)

[Unprepare SQL Event Class](../../relational-databases/event-classes/unprepare-sql-event-class.md)

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