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.
In This Section
Topic |
Description |
|---|---|
Indicates that an automatic updating of index and column statistics has occurred. |
|
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. |
|
Monitors performance of the queries that are being executed. |
|
Identifies Showplan operators within a SQL statement. |
|
Displays compile time data for Showplan operators. |
|
Displays the estimated cost of a query. |
|
Identifies the Showplan operators on SQL Server 2000 or SQL Server 7.0. Event information is formatted as binary data. |
|
Identifies the Showplan operators on SQL Server 2000 or SQL Server 7.0. Event information is formatted as a string. |
|
Identifies the Showplan operators in a SQL statement. The event class stores each event as a well defined XML document. |
|
Displays compile time data for Showplan operators in XML format. |
|
Identifies the Showplan operators associated with a SQL statement. The output is an XML document. |
|
Indicates that SQL Server has executed a full-text query. |
|
Indicates that SQL Server successfully produced an execution plan for a query or batch that contained a plan guide. |
|
Indicates that SQL Server could not produce an execution plan for a query or batch that contained a plan guide. |