Occurs when a query accesses a column that does not have statistics available that could have been useful for query optimization. Use this event to identify queries that may be using sub-optimal plans. This event is only generated when the Auto Create Statistics option is turned off.
Occurs when a page is added to the suspect_pages table in the msdb database. This event is issued asynchronously from the ...
Occurs when a plan is created for a query or batch that includes a plan guide. Use this event to determine when plan guides ...
Occurs when a PROMOTE TRANSACTION request that was sent from a client application through the transaction management interface ...
Occurs when a PROMOTE TRANSACTION request that was sent from a client application through the transaction management interface ...
Occurs when a query accesses a column that does not have statistics available that could have been useful for query optimization. ...
Occurs when a query plan is removed from the plan cache and the historical statistics for the object are about to be destroyed. ...
Occurs when a query tries to get more memory grant during execution. Failure to get this additional memory grant may cause ...
Occurs when a query uses a bitmap filter and the bitmap filter is disabled. Use this event to troubleshoot performance problems ...
Occurs when a queue monitor starts an activation stored procedure, sends a QUEUE_ACTIVATION notification, or when an activation ...