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 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.	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

See Also

Concepts

Describing Events by Using Data Columns

Other Resources

Monitoring Events

Help and Information

Getting SQL Server 2005 Assistance