Administering SQL Server
Monitoring with SQL Profiler Event Categories
In SQL Profiler, use event categories to monitor events in Microsoft® SQL Server™. Event categories contain event classes that have been grouped together within the SQL Profiler user interface. For more information, see SQL Profiler Terminology.
The following table describes the SQL Profiler event categories and their associated event classes.
| Event category | Description |
|---|---|
| Cursors | Collection of event classes produced by cursor operations. |
| Database | Collection of event classes produced when data or log files grow or shrink automatically. |
| Errors and Warnings | Collection of event classes produced when a SQL Server error or warning occurs (for example, an error during the compilation of a stored procedure or an exception in SQL Server). |
| Locks | Collection of event classes produced when a lock is acquired, cancelled, released, etc. |
| Objects | Collection of event classes produced when database objects are created, opened, closed, dropped, or deleted. |
| Performance | Collection of event classes produced when SQL data manipulation (DML) operators execute. |
| Scans | Collection tables and indexes are scanned. |
| Security Audit | Collection of event classes used to audit server activity. |
| Sessions | Collection of event classes produced by clients connecting to and disconnecting from an instance of SQL Server. |
| Stored Procedures | Collection of event classes produced by the execution of stored procedures. |
| Transactions | Collection of event classes produced by the execution of Microsoft Distributed Transaction Coordinator (MS DTC) transactions or by writing to the transaction log. |
| TSQL | Collection of event classes produced by the execution of Transact-SQL statements passed to an instance of SQL Server from the client. |
| User Configurable | Collection of user-configurable event classes. |