Occurs when the optimizer times out either due to spending too much time or hitting a memory limit. Use this event to look at all the queries that are impacted by the optimizer timeout in a particular workload. This can be very useful when tuning a particular workload.
Occurs when the Microsoft SQL Server Database Engine compiles a SELECT statement associated with a cursor into an execution ...
Occurs when the Microsoft SQL Server Database Engine executes a Transact-SQL statement that is not supported by server cursors ...
Occurs when the optimizer cannot get enough join selectivity information. Use this event to look at the queries where spatial ...
Occurs when the optimizer cannot use a filtered index due to parameterization. For each such index an event is fired. The ...
Occurs when the optimizer times out either due to spending too much time or hitting a memory limit. Use this event to look ...
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 determines a state change in term of session recovery on a connection resilency-enabled connection. ...