Errors and Warnings Event Category (Database Engine)

Errors and Warnings Event Category (Database Engine)

 

Applies To: SQL Server 2016

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

TopicDescription
Attention Event ClassIndicates that an Attention event has occurred.
Background Job Error Event ClassIndicates that a background job has terminated abnormally.
Bitmap Warning Event ClassIndicates that bitmap filtering has been disabled in a query.
Blocked Process Report Event ClassIndicates that a task has been blocked for more than a specified amount of time.
CPU Threshold Exceeded Event ClassIndicates that the Resource Governor detects a query that exceeds the specified CPU threshold.
ErrorLog Event ClassIndicates that error events have been logged in the SQL Server error log.
EventLog Event ClassIndicates that events have been logged in the Windows event log.
Exception Event ClassIndicates that an exception has occurred in SQL Server.
Exchange Spill Event ClassIndicates that communication buffers in a parallel query plan have been written to the tempdb database.
Execution Warnings Event ClassIndicates that memory grant warnings occurred during the execution of a SQL Server statement or stored procedure.
Hash Warning Event ClassIndicates that a hash recursion or hash bailout has occurred during a hashing operation.
Missing Column Statistics Event ClassIndicates that column statistics that could have been useful for the optimizer are not available.
Missing Join Predicate Event ClassIndicates that a query is being executed that has no join predicate.
Sort Warnings Event ClassIndicates that sort operations do not fit into memory.
User Error Message Event ClassDisplays error messages that are seen by the user.

sp_trace_setevent (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft