Occurs when a statement that contains a cursor declaration is compiled into an execution plan, but before the cursor is opened. Use this event to troubleshoot cursor performance issues.
Occurs when a SQL Server transaction begins, completes, rolls back or executes a savepoint. Use this event to monitor transaction ...
Occurs when a statement in a batch (including stored procedures) recompiles. This event should be used in SQL Server 2005 ...
Occurs when a statement in a batch (including stored procedures) recompiles. This event should be used starting in SQL Server ...
Occurs when a statement is defined for a cursor, the cursor properties are set, and the cursor is populated. Use this event ...
Occurs when a statement that contains a cursor declaration is compiled into an execution plan, but before the cursor is opened. ...
Occurs when a statement-level recompilation is required by any kind of batch. This includes stored procedures, triggers, ...
Occurs when a stored procedure is inserted into the procedure cache. Use this event together with other sp_cache_* events ...
Occurs when a stored procedure is not found in the procedure cache. Frequent occurrences of this event could indicate that ...
Occurs when a stored procedure is removed from the procedure cache. Use this event together with other sp_cache_* events ...