Occurs when a query uses a bitmap filter and the bitmap filter is disabled. Use this event to troubleshoot performance problems for queries with bitmap filters, and to identify queries where the bitmap filter was disabled because it is nonselective.
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 ...
Occurs when a record is added to the SQL Server transaction log. This is a very high volume event that will affect the performance ...
Occurs when a request for a lock times out because another transaction holds a blocking lock on the required resource. The ...
Occurs when a request for a lock times out because of a blocking lock that is being held by a different resource. This event ...