Export (0) Print
Expand All

Performance Event Category

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.

Topic

Description

Auto Stats Event Class

Indicates that an automatic updating of index and column statistics has occurred.

Degree of Parallelism (7.0 Insert) Event Class

Indicates that SQL Server has executed a SELECT, INSERT, UPDATE, or DELETE statement using either a serial or parallel plan. The number of CPUs used to perform the operation is also reported.

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.

Plan Guide Successful Event Class

Indicates that SQL Server successfully produced an execution plan for a query or batch that contained a plan guide.

Plan Guide Unsuccessful Event Class

Indicates that SQL Server could not produce an execution plan for a query or batch that contained a plan guide.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft