Occurs when the memory communication buffers for a query with multiple Parallelism operators become full, resulting in one ...

Occurs when the memory communication buffers for a query with multiple Parallelism operators become full, resulting in one of the operators writing to TempDB. If this happens multiple times in a single query plan the query performance is impacted. Use this event in conjunction with any of the *_showplan events to determine which operation in the generated plan is causing the exchange spill using the node_id field

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 ... 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 ...