Administering SQL Server
TSQL Data Columns
The following table lists the data columns for each event class in the TSQL event category.
| Event class | Data column | Description |
|---|---|---|
| Exec Prepared SQL | Event Class | Type of event recorded = 72. |
| Handle | Handle of the prepared TSQL statement. | |
| Prepare SQL | Event Class | Type of event recorded = 71. |
| Handle | Handle of the prepared TSQL statement. | |
| SQL:BatchCompleted | Event Class | Type of event recorded = 12. |
| Duration | The duration of the event. | |
| End Time | The end time of the event. | |
| Reads | The number of page read I/Os caused by the batch. | |
| Writes | The number of page write I/Os caused by the batch. | |
| CPU | The CPU used during the batch. | |
| Text Data | The text of the batch. | |
| SQL:BatchStarting | Event Class | Type of event recorded = 13. |
| Text Data | The text of the batch. | |
| SQL:StmtCompleted | Event Class | Type of event recorded = 41. |
| Duration | The duration of the event. | |
| End Time | The end time of the event. | |
| Reads | The number of page reads issued by the SQL statement. | |
| Writes | The number of page writes issued by the SQL statement. | |
| CPU | The CPU used by the SQL statement. | |
| Integer Data | The number of rows returned by the SQL statement. | |
| Object ID | The object ID of the parent stored procedure, if the SQL statement was run within a stored procedure. | |
| Nest Level | The nest level of the stored procedure, if the SQL statement was run within a stored procedure. | |
| Text Data | The text of the statement that is about to be executed. | |
| SQL:StmtStarting | Event Class | Type of event recorded = 40. |
| Object ID | The object ID of the parent stored procedure, if the SQL statement was run within a stored procedure. | |
| Nest Level | The next level of the stored procedure, if the SQL statement was run within a stored procedure. | |
| Text Data | The text of the statement that is about to be executed. | |
| Unprepare SQL | Event Class | Type of event recorded = 73. |
| Handle | The handle of the prepared TSQL statement. |