SQL Server 2016
- 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 type convert issue affects the plan. The expression value indicates the conversion that can cause inaccurate ...
- 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 a value() method is used in a query, specifying a sql type that differs from the type specified during selective ...
- 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 background task for moving history data of memory-optimized temporal table from internal history table to history ...
- Occurs when background task for moving history data of memory-optimized temporal table from internal history table to history ...
- Occurs when background task for moving history data of memory-optimized temporal table from internal history table to history ...
- Occurs when batch operator runs out of granted memory and initiates spilling to disk of another partition of in-memory data. ...
- Occurs when clustered index on the table was rebuilt. This event is raised three times for ALTER index rebuild operation ...
- 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 SQL Server initializes an OLEDB provider for a distributed query or remote stored procedure. Use this event to ...
- 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 ...
- Occurs when the Microsoft SQL Server 2005 Database Engine executes a Transact-SQL statement that is not supported by server ...
- Occurs when the Microsoft SQL Server Database Engine compiles a SELECT statement associated with a cursor into an execution ...
- Occurs when the Microsoft SQL Server Database Engine executes a Transact-SQL statement that is not supported by server cursors ...
- Occurs when the optimizer cannot get enough join selectivity information. Use this event to look at the queries where spatial ...
- Occurs when the optimizer cannot use a filtered index due to parameterization. For each such index an event is fired. The ...
- Occurs when the optimizer times out either due to spending too much time or hitting a memory limit. Use this event to look ...
- Occurs when the permissions to change the owner of a database is checked. This happens when the ALTER AUTHORIZATION statement ...
- Occurs when the permissions to change the owner of schema object (such as a table, procedure, or function) is checked. This ...
- Occurs when the request for a lock was canceled, such as when the query requesting the lock was canceled. Use this event ...
- Occurs when the server determines a state change in term of session recovery on a connection resilency-enabled connection. ...
- Occurs when the server memory usage increases or decreases by more than either 1 megabyte (MB) or 5% of the maximum server ...