Occurs when a record is added to the SQL Server transaction log. This is a very high volume event that will affect the performance of the server. Therefore, you should use appropriate filtering to reduce the number of events, and only use this event for targeted troubleshooting during a short time period.
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 ...
Occurs when a request to load an assembly is executed. This can be useful when troubleshooting a query that uses CLR, when ...
Occurs when a request to load an assembly is executed. Use this event to troubleshoot queries that are running common language ...