Delen via


SQL Server Event Class Reference

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 Category

Event 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/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