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.

See Also

TSQL Event Category

TSQL Event Classes