Administering SQL Server
Performance Data Columns
The following table lists the data columns for each event class in the Performance event category.
| Event class | Data column | Description |
|---|---|---|
| Degree of Parallelism1 | Event Class | Type of event recorded = 28. |
| Event Sub Class | If you are tracing a Microsoft® SQL Server™ 2000 server, the Event Sub Class can have these values, which reflect the type of statement:
1 = Select 2 = Insert 3 = Update 4 = Delete |
|
| Binary Data | Supplied binary data, which is the number of CPUs used to perform the statement. | |
| Integer Data | Pages used in memory for the query plan. | |
| Degree of Parallelism2 | Event Class | Type of event recorded =28. |
| Event Sub Class | If you are tracing a SQL Server 2000 server, the Event Sub Class can have these values, which reflect the type of statement:
1 = Select 2 = Insert 3 = Update 4 = Delete |
|
| Binary Data | Supplied binary data, which is the number of CPUs used to perform the statement. | |
| Integer Data | Pages used in memory for the query plan. | |
| Degree of Parallelism3 | Event Class | Type of event recorded = 28. |
| Event Sub Class | If you are tracing a SQL Server 2000 server, the Event Sub Class can have these values, which reflect the type of statement:
1 = Select 2 = Insert 3 = Update 4 = Delete |
|
| Binary Data | Supplied binary data, which is the number of CPUs used to perform the statement. | |
| Integer Data | Pages used in memory for the query plan. | |
| Degree of Parallelism4 | Event Class | Type of event recorded = 28. |
| Event Sub Class | If you are tracing a SQL Server 2000 server, the Event Sub Class can have these values, which reflect the type of statement:
1 = Select 2 = Insert 3 = Update 4 = Delete |
|
| Binary Data | Supplied binary data, which is the number of CPUs used to perform the statement. | |
| Integer Data | Pages used in memory for the query plan. | |
| Execution Plan | Event Class | Type of event recorded = 68. |
| Binary Data | Estimated cost of the execution plan. | |
| Object ID | ID of the object that had its statistics updated. | |
| Integer Data | Estimated number of rows returned. | |
| Text Data | Execution plan tree. Only SQL statements are expressed. Transact-SQL constructs are not represented. | |
| Show Plan All | Event Class | Type of event recorded = 97. |
| Binary Data | Estimated cost of the query. | |
| Integer Data | Expected number of rows to be returned. | |
| Text Data | Showplan ALL results of the statement. | |
| Show Plan Statistics | Event Class | Type of event recorded = 98. |
| Binary Data | Estimated cost of the query. | |
| Integer Data | Expected number of rows to be returned. | |
| Text Data | Showplan Statistics results of the statement. | |
| Show Plan Text | Event Class | Type of event recorded = 96. |
| Binary Data | Estimated cost of the query. | |
| Integer Data | Expected number of rows to be returned. | |
| Text Data | Showplan Text results of the statement. |