Occurs when a plan is created for a query or batch that includes a plan guide. Use this event to determine when plan guides are successfully applied.
Occurs when a fine-grain lock is converted into a coarser-grain lock, such as when a row lock is converted into an object ...
Occurs when a lock is acquired on an object. Use this event to troubleshoot data contention issues that are caused by locks ...
Occurs when a lock on an object has been released. Use this troubleshoot data contention issues that are caused by locks ...
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. ...