Skip to content

performance-event-category.md

Latest commit

 

History

History
43 lines (37 loc) · 3.74 KB

performance-event-category.md

File metadata and controls

43 lines (37 loc) · 3.74 KB
title Performance Event Category
description Performance Event Category
author MikeRayMSFT
ms.author mikeray
ms.date 03/14/2017
ms.service sql
ms.subservice supportability
ms.topic reference
ms.custom
ignite-2025
helpviewer_keywords
SQL Server event classes, Performance event category
Performance event category [SQL Server]
event classes [SQL Server], Performance event category
monikerRange =azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric-sqldb

Performance Event Category

[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance FabricSQLDB] 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
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 [!INCLUDEssNoVersion] 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 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 [!INCLUDEssNoVersion] has executed a full-text query.
Plan Guide Successful Event Class Indicates that [!INCLUDEssNoVersion] successfully produced an execution plan for a query or batch that contained a plan guide.
Plan Guide Unsuccessful Event Class Indicates that [!INCLUDEssNoVersion] could not produce an execution plan for a query or batch that contained a plan guide.

See Also

Extended Events