Errors and Warnings Data Columns

These are the data columns for each event class in the Errors and Warnings event category.

Event class	Data column	Description
Attention	Event Class	Type of event recorded = 16.
ErrorLog	Event Class	Type of event recorded = 22.
	Error	Error number.
	Severity	Severity of the error generated.
	Text Data	Text of the error message.
EventLog	Event Class	Type of event recorded = 21.
	Binary Data	Binary value dependent on the event class captured in the trace.
	Error	Error number.
	Severity	Error severity.
	Text Data	Text of the error message, if available.
Exception	Event Class	Type of event recorded = 33.
	Error	Error number.
	State	Server state.
	Severity	Error severity.
Execution Warnings	Event Class	Type of event recorded = 67.
	Event Sub Class	The type of execution warning. Can have these values: 1 = Query wait. The query must wait for resources (for example, memory) before it can execute. 2 = Query time-out. The query timed out while waiting for required resources to execute.
	Error	Error number.
Hash Warning	Event Class	Type of event recorded = 55.
	Event Sub Class	Type of hash operation. Can have these values: 0 = Hash recursion. 1 = Hash bail.
	Integer Data	Recursion level (hash recursion only).
	Object ID	Node ID of the root of the hash involved in the repartition.
Missing Column Statistics	Event Class	Type of event recorded = 79.
	Text Data	List of the columns with missing statistics.
Missing Join Predicate	Event Class	Type of event recorded = 80.
OLEDB Errors	Event Class	Type of event recorded = 61.
	Text Data	Error message from OLE DB.
Sort Warnings	Event Class	Type of event recorded = 69.
	Event Sub Class	Type of sort warning. Can have these values: 1 = Single pass. When the sort table was written to disk, only a single additional pass over the data to be sorted was required to obtain sorted output. 2 = Multiple pass. When the sort table was written to disk, multiple passes over the data were required to obtain sorted output.

Errors and Warnings Data Columns

See Also