SQL Server 2012
- 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 ...
- Occurs when a ROLLBACK TRANSACTION request that was sent from a client application through the transaction management interface ...
- Occurs when a ROLLBACK TRANSACTION request that was sent from a client application through the transaction management interface ...
- Occurs when a SAVE TRANSACTION request that was sent from a client application through the transaction management interface ...
- Occurs when a SAVE TRANSACTION request that was sent from a client application through the transaction management interface ...
- Occurs when a Service Broker message cannot be delivered. This can occur for several reasons, such as the target Service ...
- Occurs when a Service Broker queue monitor starts an activation stored procedure, sends a QUEUE_ACTIVATION notification, ...
- 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 ...
- Occurs when a stored procedure is retrieve from the procedure cache. Use this event along with other sp_cache_* events to ...
- Occurs when a successful connection is made to the Server. This event is fired for new connection or when connections are ...
- Occurs when a successful connection to the Server is reported to Windows using the User Access Logging API. This event is ...
- Occurs when a T-SQL statement or stored procedure waits more than one second for a memory grant or when the initial attempt ...
- Occurs when a tape mount request is received. Use this event class any time you want to monitor tape mount requests and their ...
- Occurs when a task has been blocked longer than the time that is specified by the sp_configure blocked process threshold ...
- Occurs when a user has logged out of (logged off) the Server. This event is required in traces that will be used for Replay ...
- Occurs when an ALTER TABLE ADD column operation results in an UPDATE that affects every row. This event signals a potentially ...
- Occurs when an attempt to acquire a lock generates a deadlock. This event is raised for each participant in the deadlock. ...
- Occurs when an executed query is missing a join predicate. Use this event to identify a query that may perform slowly because ...
- Occurs when an execution plan is created for a query or batch without using the provided plan guide. Use this event to identify ...
- Occurs when an execution plan that contains a cursor is discarded. Use this event to troubleshoot cursor performance issues. ...
- Occurs when an execution plan that contains a cursor is recompiled. Use this event to troubleshoot cursor performance issues. ...
- Occurs when an expression is not natively supported in batch processing mode and a wrapper of row-by-row evaluation is used. ...
- Occurs when an Extended Events session is started. To avoid duplicate (or secondary) existing_connection events when other ...
- Occurs when an object was altered by the ALTER statement. This event is raised two times for every ALTER operation. The event ...
- Occurs when an object was created by the CREATE statement. This event is raised two times for every CREATE operation. The ...
- Occurs when an object was deleted by the DROP statement. This event is raised two times for every DROP operation. The event ...
- Occurs when an OLEDB Call to a remote provider returns an error. Use this event to view the Hresult returned from failed ...
- Occurs when an operation is performed that is related to query notification subscriptions. Use this event to monitor when ...
- Occurs when an operation is performed that is related to the parameter tables that are used in query notifications. Use this ...
- Occurs when an operator outputs significantly more rows than estimated by the Query Optimizer. Use this event to identify ...
- Occurs when any of the data or log files for a database changes size. Use this event to monitor changes to the size of database ...
- Occurs when background activity to support query notifications is performed. Use this event to track subscription time-outs, ...
- Occurs when index and column statistics are automatically updated. This event can be generated multiple times per statistics ...
- Occurs when matrix restore recovery has completed. It may not occur if there are no in-doubt transactions with commit outcomes ...
- Occurs when Microsoft SQL Server 2005 Database Engine creates and populates a cursor from the execution plan created by a ...
- Occurs when Microsoft SQL Server Database Engine creates and populates a cursor from the execution plan created by a cursor ...
- Occurs when new extents are allocated during index building. Use this event to indentify how extents are used by an index. ...
- Occurs when operations are performed related to the query templates used by the Database Engine to share information about ...
- Occurs when Resource Governor detects that a query has exceeded the CPU threshold that is specified for REQUEST_MAX_CPU_TIME_SEC. ...
- Occurs when Service Broker determines the routing for a message. A message is classified for either local, remote, or delayed ...
- Occurs when Service Broker is unable to retain a received message that should have been delivered to a service in this instance. ...
- Occurs when sp_repl_generateevent is called. this event is an internal repl event for tracing repl stored procedures. The ...
- Occurs when sp_trace_generateevent is called. Use this event to monitor user-defined events in your application code during ...
- Occurs when SQL Server 2005 executes an XQuery. This event class provides the static type of the XQuery expression. In case ...
- Occurs when SQL Server calls on OLEDB provider for a distributed query or remote stored procedure. Use this event to monitor ...
- Occurs when SQL Server calls on OLEDB provider for a distributed query or remote stored procedure. Use this event to monitor ...
- Occurs when SQL Server calls on OLEDB provider for a distributed query or remote stored procedure. Use this event to monitor ...
- Occurs when SQL Server compiles a SQL Statement. Include the Showplan All for Query Compile event class to identify the Showplan ...
- Occurs when SQL Server compiles a SQL Statement. Include the Showplan All for Query Compile event class to identify the Showplan ...
- Occurs when SQL Server compiles a SQL Statement. Include the Showplan XML For Query Compile event class to identify the Showplan ...
- Occurs when SQL Server compiles a SQL Statement. Include the Showplan XML For Query Compile event class to identify the Showplan ...
- Occurs when SQL Server executes a SQL Statement. Include the Showplan XML event class to identify the Showplan operators. ...
- Occurs when SQL Server executes a SQL Statement. Include the Showplan XML Statististics Profile event class to identify the ...
- Occurs when SQL Server executes a SQL Statement. Include the Showplan XML Statististics Profile event class to identify the ...
- Occurs when SQL Server executes an XQuery. This event class provides the static type of the XQuery expression. In case of ...
- Occurs when the batch operation to build a hash table encounters low memory condition and switches to row mode operation. ...
- Occurs when the failover validates the readiness of replica as a primary. For instance, the failover validation will return ...
- Occurs when the memory communication buffers for a query with multiple Parallelism operators become full, resulting in one ...
- Occurs when the Microsoft SQL Server 2005 Database Engine compiles a SELECT statement associated with a cursor into an execution ...