Errors and Warnings Event Category (Database Engine)

The Errors and Warnings event category contains general error and warning events.

In This Section

Topic Description

Attention Event Class

Indicates that an Attention event has occurred.

Background Job Error Event Class

Indicates that a background job has terminated abnormally.

Blocked Process Report Event Class

Indicates that a task has been blocked for more than a specified amount of time.

ErrorLog Event Class

Indicates that error events have been logged in the Microsoft SQL Server error log.

EventLog Event Class

Indicates that events have been logged in the Microsoft Windows event log.

Exception Event Class

Indicates that an exception has occurred in SQL Server.

Exchange Spill Event Class

Indicates that communication buffers in a parallel query plan have been written to the tempdb database.

Execution Warnings Event Class

Indicates that memory grant warnings occurred during the execution of a SQL Server statement or stored procedure.

Hash Warning Event Class

Indicates that a hash recursion or hash bailout has occurred during a hashing operation.

Missing Column Statistics Event Class

Indicates that column statistics that could have been useful for the optimizer are not available.

Missing Join Predicate Event Class

Indicates that a query is being executed that has no join predicate.

Sort Warnings Event Class

Indicates that sort operations do not fit into memory.

User Error Message Event Class

Displays error messages that are seen by the user.

See Also

Other Resources

Monitoring Events
sp_trace_setevent (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance