Occurs when a page is added to the suspect_pages table in the msdb database. This event is issued asynchronously from the insertion of a corresponding page into the suspect_pages table. Therefore, a job that is listening to this event may not find the correlating suspect_pages entry immediately.
Occurs when a DML operation that is intended to overwrite only part of a large column value is forced to rewrite the entire ...
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. ...