Performance Event Category

Article
12/03/2008

Use the Performance event category to monitor Showplan event classes and event classes that are produced from the execution of SQL data manipulation language (DML) operators.

In This Section

Topic	Description
Degree of Parallelism (7.0 Insert) Event Class	Indicates that SQL Server has executed an INSERT statement.
Performance Statistics Event Class	Monitors performance of the queries that are being executed.
Showplan All Event Class	Identifies Showplan operators within a SQL statement.
Showplan All for Query Compile Event Class	Displays compile time data for Showplan operators.
Showplan Statistics Profile Event Class	Displays the estimated cost of a query.
Showplan Text Event Class	Identifies the Showplan operators on SQL Server 2000 or SQL Server 7.0. Event information is formatted as binary data.
Showplan Text (Unencoded) Event Class	Identifies the Showplan operators on SQL Server 2000 or SQL Server 7.0. Event information is formatted as a string.
Showplan XML Event Class	Identifies the Showplan operators in a SQL statement. The event class stores each event as a well defined XML document.
Showplan XML For Query Compile Event Class	Displays compile time data for Showplan operators in XML format.
Showplan XML Statistics Profile Event Class	Identifies the Showplan operators associated with a SQL statement. The output is an XML document.
SQL:FullTextQuery Event Class	Indicates that SQL Server has executed a full-text query.

See Also

Other Resources

Monitoring Events

Help and Information

Getting SQL Server 2005 Assistance