Occurs when the sort operation on an executing query does not fit into memory. This event is not generated for sort operations caused by index creation, only for sort operations in a query. (For example, an Order By in a Select statement.) Use this event to identify queries that perform slowly because of the sort operation, particularly when the warning_type = 2, indicating multiple passes over the data were required to sort
Occurs when the permissions to change the owner of a database is checked. This happens when the ALTER AUTHORIZATION statement ...
Occurs when the permissions to change the owner of schema object (such as a table, procedure, or function) is checked. This ...
Occurs when the request for a lock was canceled, such as when the query requesting the lock was canceled. Use this event ...
Occurs when the server memory usage increases or decreases by more than either 1 megabyte (MB) or 5% of the maximum server ...
Occurs when the sort operation on an executing query does not fit into memory. This event is not generated for sort operations ...
Occurs when the state of an active mirrored route (i.e. a route containing a mirror address that is currently being used ...
Occurs when there is a connectivity issue between the cluster and the Availability Group resulting in a failure to renew ...
Occurs when there is a wait on a SQLOS controlled resource. Use this event to track resource waits that occur during task ...
Occurs when there is insufficient memory to process the build input of a hash join. This results in either a hash recursion ...