TechNet
Export (0) Print
Expand All

SQL Server Event Class Reference

 

Applies To: SQL Server 2016

SQL Server Profiler lets you record events as they occur in an instance of the Microsoft SQL Server Database Engine. The recorded events are instances of the event classes in the trace definition. In SQL Server Profiler, 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 CategoryEvent Classes
The Broker Event Category includes event classes that are produced by the Service Broker.Broker:Activation Event Class

 Broker:Connection Event Class

 Broker:Conversation Event Class

 Broker:Conversation Group Event Class

 Broker:Corrupted Message Event Class

 Broker:Forwarded Message Dropped Event Class

 Broker:Forwarded Message Sent Event Class

 Broker:Message Classify Event Class

 Broker:Message Drop Event Class

 Broker:Remote Message Ack Event Class
The Cursors Event Category includes event classes that are produced by cursor operations.CursorClose Event Class

 CursorExecute Event Class

 CursorImplicitConversion Event Class

 CursorOpen Event Class

 CursorPrepare Event Class

 CursorRecompile Event Class

 CursorUnprepare Event Class
The CLR Event Category includes event classes that are produced by the execution of .NET common language runtime (CLR) objects.Assembly Load Event Class
The Database Event Category includes event classes that are produced when data or log files grow or shrink automatically.Data File Auto Grow Event Class

 Data File Auto Shrink Event Class

 Database Mirroring State Change Event Class

 Log File Auto Grow Event Class

 Log File Auto Shrink Event Class
The Deprecation Event Category includes deprecation related events.Deprecation Announcement Event Class

 Deprecation Final Support Event Class
The Errors and Warnings Event Category (Database Engine) includes event classes that are produced when a SQL 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 Server.Attention Event Class

 Background Job Error Event Class

 Blocked Process Report Event Class

 CPU Threshold Exceeded Event Class

 ErrorLog Event Class

 EventLog Event Class

 Exception Event Class

 Exchange Spill Event Class

 Execution Warnings Event Class

 Hash Warning Event Class

 Missing Column Statistics Event Class

 Missing Join Predicate Event Class

 Sort Warnings Event Class

 User Error Message Event Class
The Full Text Event Category includes event classes that are produced when full-text searches are started, interrupted, or stopped.FT:Crawl Aborted Event Class

 FT:Crawl Started Event Class

 FT:Crawl Stopped Event Class
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.Deadlock Graph Event Class

 Lock:Acquired Event Class

 Lock:Cancel Event Class

 Lock:Deadlock Chain Event Class

 Lock:Deadlock Event Class

 Lock:Escalation Event Class

 Lock:Released Event Class

 Lock:Timeout (timeout > 0) Event Class

 Lock:Timeout Event Class
The Objects Event Category includes event classes that are produced when database objects are created, opened, closed, dropped, or deleted.Auto Stats Event Class

 Object:Altered Event Class

 Object:Created Event Class

 Object:Deleted Event Class
The OLEDB Event Category includes event classes that are produced by OLE DB calls.OLEDB Call Event Class

 OLEDB DataRead Event Class

 OLEDB Errors Event Class

 OLEDB Provider Information Event Class

 OLEDB QueryInterface Event Class
The Performance Event Category includes event classes that are produced when SQL data manipulation language (DML) operators execute.Degree of Parallelism (7.0 Insert) Event Class

 Performance Statistics Event Class

 Showplan All Event Class

 Showplan All for Query Compile Event Class

 Showplan Statistics Profile Event Class

 Showplan Text Event Class

 Showplan Text (Unencoded) Event Class

 Showplan XML Event Class

 Showplan XML for Query Compile Event Class

 Showplan XML Statistics Profile Event Class

 SQL:FullTextQuery Event Class
The Progress Report Event Category includes the Progress Report: Online Index Operation event class.Progress Report: Online Index Operation Event Class
The Scans Event Category includes event classes that are produced when tables and indexes are scanned.Scan:Started Event Class

 Scan:Stopped Event Class
The Security Audit Event Category includes event classes that are used to audit server activity.Audit Add DB User Event Class

 Audit Add Login to Server Role Event Class

 Audit Add Member to DB Role Event Class

 Audit Add Role Event Class

 Audit Addlogin Event Class

 Audit App Role Change Password Event Class

 Audit Backup and Restore Event Class

 Audit Broker Conversation Event Class

 Audit Broker Login Event Class

 Audit Change Audit Event Class

 Audit Change Database Owner Event Class

 Audit Database Management Event Class

 Audit Database Object Access Event Class

 Audit Database Object GDR Event Class

 Audit Database Object Management Event Class

 Audit Database Object Take Ownership Event Class

 Audit Database Operation Event Class

 Audit Database Principal Impersonation Event Class

 Audit Database Principal Management Event Class

 Audit Database Scope GDR Event Class

 Audit DBCC Event Class

 Audit Login Change Password Event Class

 Audit Login Change Property Event Class

 Audit Login Event Class

 Audit Login Failed Event Class

 Audit Login GDR Event Class

 Audit Logout Event Class

 Audit Object Derived Permission Event Class

 Audit Schema Object Access Event Class

 Audit Schema Object GDR Event Class

 Audit Schema Object Management Event Class

 Audit Schema Object Take Ownership Event Class

 Audit Server Alter Trace Event Class

 Audit Server Object GDR Event Class

 Audit Server Object Management Event Class

 Audit Server Object Take Ownership Event Class

 Audit Server Operation Event Class

 Audit Server Principal Impersonation Event Class

 Audit Server Principal Management Event Class

 Audit Server Scope GDR Event Class

 Audit Server Starts and Stops Event Class

 Audit Statement Permission Event Class
The Server Event Category contains general server events.Mount Tape Event Class

 Server Memory Change Event Class

 Trace File Close Event Class
The Sessions Event Category includes event classes produced by clients connecting to and disconnecting from an instance of SQL Server.ExistingConnection Event Class
The Stored Procedures Event Category includes event classes produced by the execution of stored procedures.PreConnect:Completed Event Class

 PreConnect:Starting Event Class

 RPC:Completed Event Class

 RPC Output Parameter Event Class

 RPC:Starting Event Class

 SP:CacheHit Event Class

 SP:CacheInsert Event Class

 SP:CacheMiss Event Class

 SP:CacheRemove Event Class

 SP:Completed Event Class

 SP:Recompile Event Class

 SP:Starting Event Class

 SP:StmtCompleted Event Class

 SP:StmtStarting Event Class
The Transactions Event Category includes event classes produced by the execution of Microsoft Distributed Transaction Coordinator transactions or by writing to the transaction log.DTCTransaction Event Class

 SQLTransaction Event Class

 TM: Begin Tran Completed Event Class

 TM: Begin Tran Starting Event Class

 TM: Commit Tran Completed Event Class

 TM: Commit Tran Starting Event Class

 TM: Promote Tran Completed Event Class

 TM: Promote Tran Starting Event Class

 TM: Rollback Tran Completed Event Class

 TM: Rollback Tran Starting Event Class

 TM: Save Tran Completed Event Class

 TM: Save Tran Starting Event Class

 TransactionLog Event Class
The TSQL Event Category includes event classes produced by the execution of Transact-SQL statements passed to an instance of SQL Server from the client.Exec Prepared SQL Event Class

 Prepare SQL Event Class

 SQL:BatchCompleted Event Class

 SQL:BatchStarting Event Class

 SQL:StmtCompleted Event Class

 SQL:StmtRecompile Event Class

 SQL:StmtStarting Event Class

 Unprepare SQL Event Class

 XQuery Static Type Event Class
The User-Configurable Event Category includes event classes that you can define.User-Configurable Event Class

SQL Server Profiler

Community Additions

ADD
Show:
© 2016 Microsoft