Package Event Name Event Description SQL 2008 SQL 2008R2 SQL 2012 SQL 2014
filestream filetable_application_error Reports extended information on specific errors that due to the limited error reporting of Win32 silently fail from the application's perspective.     X X
filestream filetable_file_io_request Occurs when a FileTable file I/O streaming access request is received from the RsFx filesystem filter driver.     X X
filestream filetable_file_io_response Occurs when a FileTable file I/O streaming access response is sent to the RsFx filesystem filter driver.     X X
filestream filetable_nso_error Occurs when there has been an error during the operation of the FileTable namespace owner component. May also encompass informational traces.     X X
filestream filetable_nso_kill Occurs when the FileTable namespace owner has killed a handle, either explicitly or due to termination clause processing on alter database operations.     X X
filestream filetable_nso_operation Occurs when the FileTable namespace owner has completed processing an operational event.     X X
filestream filetable_store_database_operation Occurs when the FileTable store component has completed processing an operational event related to a database.     X X
filestream filetable_store_enumerate_getitem Occurs during an enumeration operation on a FileTable store. The event is raised on each GetItem call which can happen multiple times in a single IRP.     X X
filestream filetable_store_item_get Occurs when the FileTable store has processed a request to retrieve an item. Contains both the original item request and the details of the returned item.     X X
filestream filetable_store_item_modify Occurs when the FileTable store has processed a request to modify an item. Contains both the original item details and the newly updated details.     X X
filestream filetable_store_item_moverename Occurs when the FileTable store has processed a request to move or rename an item. Contains both the original item id / name and the newly updated details.     X X
filestream filetable_store_operation Occurs when the FileTable store component has completed processing an operational event.     X X
filestream filetable_store_table_operation Occurs when the FileTable store component has completed processing an operational event related to a table.     X X
package0 NullEvent Null event in package 0. X X X X
qds query_store_async_shutdown_failed Fired when query store encounters an error during async query store shutdown       X
qds query_store_background_cleanup_task_failed Fired if the background task for cleanup of QDS stale data is not completed successfully       X
qds query_store_background_task_creation_failed Fired if the background task for QDS data persistence could not be created       X
qds query_store_background_task_initialization_failed Fired if the background task for QDS data persistence could not be initialized       X
qds query_store_background_task_persist_failed Fired if the background task for QDS data persistence is not completed successfully       X
qds query_store_begin_persist_runtime_stat Fired immediately before current runtime statistics for a query plan is persisted to the database.       X
qds query_store_bloom_filter_false_positive Fired if the Bloom filter for QDS statement texts gives a false positive result       X
qds query_store_check_consistency_init_failed Fired when check consistency task fails during initialization       X
qds query_store_database_initialization_failed Fired if initialization of the Query Store for database has failed. The Query Store will be disabled for this database       X
qds query_store_db_cleanup__finished Fired if cleanup of QDS stale data finished for particular database.       X
qds query_store_db_cleanup__started Fired if cleanup of QDS stale data started for particular database.       X
qds query_store_disk_size_check_failed Fired when a check against Query Store on-disk size limit fails       X
qds query_store_disk_size_info Fired when a check against QDS on-disk size is performed       X
qds query_store_execution_runtime_info Fired when runtime information is sent to the query store.       X
qds query_store_execution_runtime_info_discarded Fired when runtime information sent to the query store is discarded.       X
qds query_store_execution_runtime_info_evicted Fired when runtime information sent to the query store is evicted.       X
qds query_store_flush_failed Fired when query store failed to flush dirty data       X
qds query_store_loaded Fired when query store is loaded       X
qds query_store_notify_dirty_shutdown_on_partition_startup Fired when previous instance of query store for the partition is shutdown by force in order to allow creation of a new instance       X
qds query_store_notify_force_failure_failed Fired when query store failed to notify force failure       X
qds query_store_persist_task_init_failed Fired when persist task fails during initialization       X
qds query_store_plan_forcing_failed Occurs when forcing of plan from qds fail       X
qds query_store_plan_persistence_failure Fired if there's a failure to persist plan       X
qds query_store_plan_removal Fired when plan is removed       X
qds query_store_query_persistence_failure Fired if there's a failure to persist query       X
qds query_store_read_write_failed Fired if the read/write to Query Store internal tables failed       X
qds query_store_statement_not_found Fired in case when statement couldn't be found due to race condition or ambiguous user request.       X
qds query_store_unloaded Fired when query store is unloaded from memory       X
SecAudit audit_event Security audit event X X X X
sqlclr clr_allocation_failure A memory allocation failed.     X X
sqlclr clr_init_failure CLR initialization failed     X X
sqlclr clr_virtual_alloc_failure A virtual memory allocation failed     X X
sqlclr gc_suspension Threads are being suspended for a garbage collection     X X
sqlos allocation_failure Allocation failure     X X
sqlos assert_fired Assert fired X X X X
sqlos async_io_completed Asynchronous I/O completed X X X X
sqlos async_io_requested Asynchronous I/O requested X X X X
sqlos context_switch_callback_executed Context switch callback executed X X    
sqlos cpu_config_changed CPU configuration has changed X X X X
sqlos crt_out_of_memory_routine_executed CRT out-of-memory routine executed X X X X
sqlos crt_signal_abort_called CRT signal abort handler called X X X X
sqlos deadlock_scheduler_callback_executed Deadlock scheduler callback executed X X X X
sqlos dump_exception_routine_executed Dump exception routine executed X X X X
sqlos ex_terminator_called ex_terminator called X X X X
sqlos exception_ring_buffer_recorded Occurs when an exception in the ring buffer is recorded. X X X X
sqlos exit_routine_executed Exit routine executed X X X X
sqlos function_hook_changed Function hook changed X X X X
sqlos idle_server_callback_executed Idle server callback executed X X X X
sqlos large_cache_caching_decision Occurs when we apply eviction/insertion policy to a large cache store entry.     X X
sqlos large_cache_entry_value_change Occurs when we recompute the value of a large cache store entry.     X X
sqlos large_cache_memory_pressure Occurs when we try to reclaim memory from a large cache store due to memory pressure.     X X
sqlos large_cache_state_change Occurs when an entry in a large cache changes its state or is destroyed.     X X
sqlos large_cache_sweep Records the result of a large-cache sweep     X X
sqlos malloc_spy_corrupted_memory_detected MallocSpy detected corrupted memory X X X X
sqlos malloc_spy_memory_allocated MallocSpy allocated memory X X X X
sqlos malloc_spy_memory_freed MallocSpy freed memory X X X X
sqlos memory_broker_clerks_ring_buffer_recorded Memory broker clerks ring buffer recorded     X X
sqlos memory_broker_ring_buffer_recorded Memory broker ring buffer recorded X X X X
sqlos memory_node_oom_ring_buffer_recorded Memory node OOM ring buffer recorded X X X X
sqlos memory_utilization_effect_callback_executed Memory utilization effect callback executed X X X X
sqlos multiple_tasks_enqueued Multiple tasks enqueued X X X X
sqlos node_affinity_changed Node affinity mask changed X X X X
sqlos node_created Node created X X X X
sqlos non_yielding_iocp_listener_callback_executed Non-yielding IOCP listener callback executed X X X X
sqlos non_yielding_rm_callback_executed Non-yielding RM callback executed X X X X
sqlos non_yielding_scheduler_callback_executed Non-yielding scheduler callback executed X X X X
sqlos nonpreemptive_long_syncio record long sync io operation in nonpreemptive worker       X
sqlos page_allocated Occurs when memory page is allocated     X X
sqlos page_freed Occurs when memory page is freed     X X
sqlos page_heap_memory_allocated PageHeap allocated memory X X X X
sqlos page_heap_memory_freed PageHeap freed memory X X X X
sqlos process_killed Process killed X X X X
sqlos quantum_thief Occurs when a task takes too long before yielding the scheduler.     X X
sqlos resource_monitor_ring_buffer_recorded Resource monitor ring buffer recorded X X X X
sqlos scheduler_created Scheduler created X X X X
sqlos scheduler_destroyed Scheduler destroyed X X X X
sqlos scheduler_monitor_deadlock_ring_buffer_recorded Deadlock ring buffer recorded for scheduler monitor X X X X
sqlos scheduler_monitor_non_yielding_iocp_ring_buffer_recorded Nonyielding IOCP ring buffer recorded for scheduler monitor X X X X
sqlos scheduler_monitor_non_yielding_ring_buffer_recorded Nonyielding ring buffer recorded for scheduler monitor X X X X
sqlos scheduler_monitor_non_yielding_rm_ring_buffer_recorded Non-yielding resource manager ring buffer recorded for scheduler monitor X X X X
sqlos scheduler_monitor_stalled_dispatcher_ring_buffer_recorded Stalled dispatcher event recorded for scheduler monitor X X X X
sqlos scheduler_monitor_system_health_ring_buffer_recorded System health ring buffer recorded for scheduler monitor X X X X
sqlos scheduler_online_state_changed Scheduler has been set online/offline X X X X
sqlos scheduler_ring_buffer_recorded Scheduler ring buffer recorded X X X X
sqlos security_handler_routine_executed Security handler routine executed X X X X
sqlos set_abort_callback_executed SetAbort callback executed X X X X
sqlos spinlock_backoff Spinlock backoff X X X X
sqlos spinlock_backoff_warning Occurs when spinlock backoff warning is sent to errorlog     X X
sqlos stuck_dispatcher_callback_executed Stuck dispatcher callback executed       X
sqlos task_aborted Occurs when a task is aborted.     X X
sqlos task_completed Occurs when a task finishes.     X X
sqlos task_enqueued Task enqueued X X X X
sqlos task_started Occurs when a task starts.     X X
sqlos thread_attached Thread attached X X X X
sqlos thread_detached Thread detached X X X X
sqlos wait_completed Occurs when there is a wait completed on a SQLOS controlled resource.  Use this event to track wait completion.       X
sqlos wait_info Occurs when there is a wait on a SQLOS controlled resource.  Use this event to track resource waits that occur during task execution. X X X X
sqlos wait_info_external Occurs when a SQLOS task switches to preemptive mode to execute potentially long running operations. X X X X
sqlos worker_state_callback_executed Worker state callback executed X X    
sqlserver additional_memory_grant Occurs when a query tries to get more memory grant during execution. Failure to get this additional memory grant may cause the query slowdown.     X X
sqlserver after_natively_compiled_proc_entry_removal_on_drop Fired after the procedure cache entry is flushed when dropping a natively compiled procedure.       X
sqlserver after_snipping_some_log After some amount of log is snipped but not all.     X X
sqlserver allocation_ring_buffer_recorded Allocation ring buffer recorded X X X X
sqlserver alter_table_update_data Occurs when an ALTER TABLE ADD column operation results in an UPDATE that affects every row. This event signals a potentially expensive DDL statement.     X X
sqlserver alwayson_ddl_executed Occurs when AlwaysOn DDL is executed including CREATE, ALTER or DROP     X X
sqlserver app_domain_ring_buffer_recorded AppDomain ring buffer recorded X X X X
sqlserver assembly_load Occurs when a request to load an assembly is executed. Use this event to troubleshoot queries that are running common language runtime (CLR) code to monitor server, database or user information that is related to loading the assembly.     X X
sqlserver attention Indicates that a cancel operation, client-interrupt request, or broken client connection has occurred. Be aware that cancel operations can also occur as the result of implementing data access driver time-outs.     X X
sqlserver auto_stats Occurs when index and column statistics are automatically updated. This event can be generated multiple times per statistics collection when the update is asynchronous.     X X
sqlserver availability_group_lease_expired Occurs when there is a connectivity issue between the cluster and the Availability Group resulting in a failure to renew the lease     X X
sqlserver availability_replica_automatic_failover_validation Occurs when the failover validates the readiness of replica as a primary. For instance, the failover validation will return false when not all databases are synchronized or not joined     X X
sqlserver availability_replica_manager_state_change Occurs when the state of the Availability Replica Manager has changed.     X X
sqlserver availability_replica_state Occurs when the Availability Replica is starting or shutting down.       X
sqlserver availability_replica_state_change Occurs when the state of the Availability Replica has changed.     X X
sqlserver background_job_error Occurs when a background job has ended abnormally.     X X
sqlserver bad_memory_detected Bad memory detected by the operating system     X X
sqlserver bad_memory_fixed Database page with bad memory detected by the operating system     X X
sqlserver batch_hash_join_separate_hash_column Occurs when batch hash join uses separate hash column in hash table.     X X
sqlserver batch_hash_table_build_bailout Occurs when the batch operation to build a hash table encounters low memory condition and switches to row mode operation.  Use this event to identify performance issues due to low memory condition.     X X
sqlserver before_natively_compiled_proc_entry_removal_on_drop Fired before the procedure cache entry is flushed when dropping a natively compiled procedure.       X
sqlserver before_redo_lsn_update Occurs just prior to the update of the EOL LSN       X
sqlserver begin_tran_completed Occurs when a BEGIN TRANSACTION request that was sent from a client application through the transaction management interface has completed.     X X
sqlserver begin_tran_starting Occurs when a BEGIN TRANSACTION request that was sent from a client application through the transaction management interface has started.     X X
sqlserver bitmap_disabled_warning Occurs when a query uses a bitmap filter and the bitmap filter is disabled. Use this event to troubleshoot performance problems for queries with bitmap filters, and to identify queries where the bitmap filter was disabled because it is nonselective.     X X
sqlserver blocked_process_report Occurs when a task has been blocked longer than the time that is specified by the sp_configure blocked process threshold setting. This event is not triggered by system tasks or by tasks that are waiting for non-deadlock-detectable resources. Use this event to troubleshoot blocked processes. (By default, blocked process reports are not generated.)     X X
sqlserver broker_activation Occurs when a Service Broker queue monitor starts an activation stored procedure, sends a QUEUE_ACTIVATION notification, or when an activation stored procedure exits.     X X
sqlserver broker_activation_stored_procedure_invoked Broker activation stored procedure invoked X X X X
sqlserver broker_activation_task_aborted Broker activation task aborted X X X X
sqlserver broker_activation_task_limit_reached Broker activation task limit reached X X X X
sqlserver broker_activation_task_started Broker activation task started X X X X
sqlserver broker_conversation Reports the progress of a Service Broker conversation. This event occurs when specific actions that are defined in the conversation_action field occur.     X X
sqlserver broker_conversation_group Occurs when Service Broker creates or deletes a conversation group.     X X
sqlserver broker_corrupted_message Occurs when Service Broker receives a corrupted message.     X X
sqlserver broker_dialog_state_change The state of a Service Broker dialog has changed X X    
sqlserver broker_dialog_transmission_body_dequeue A message was dequeued from a Service Broker transmission body table     X X
sqlserver broker_dialog_transmission_body_enqueue A message was enqueued into a Service Broker transmission body table     X X
sqlserver broker_dialog_transmission_queue_dequeue A message was dequeued from a Service Broker transmission queue X X X X
sqlserver broker_dialog_transmission_queue_enqueue A message was enqueued into a Service Broker transmission queue X X X X
sqlserver broker_forwarded_message_dropped Occurs when Service Broker drops a message that was intended to be forwarded.     X X
sqlserver broker_forwarded_message_sent Occurs when Service Broker forwards a message.     X X
sqlserver broker_message_classify Occurs when Service Broker drops a message that was intended to be forwarded.     X X
sqlserver broker_message_undeliverable Occurs when a Service Broker message cannot be delivered. This can occur for several reasons, such as the target Service Broker is unreachable, the target queue is unavailable, the message is out of order, there are time-outs because of in-memory lists, or there is a failure to classify the message.     X X
sqlserver broker_mirrored_route_state_changed Occurs every time Service Broker receives an open or close connection request from either of the mirrored instances.     X X
sqlserver broker_queue_activation_alert Occurs when no receive activity is detected on an activated queue with available messages     X X
sqlserver broker_queue_disabled Occurs when a Service Broker queue is disabled.     X X
sqlserver broker_remote_message_acknowledgement Occurs when Service Broker sends or receives a message acknowledgement.     X X
sqlserver broker_task_idempotent_invoke_begin Broker task idempotent invoke begin X X    
sqlserver broker_task_idempotent_invoke_end Broker task idempotent invoke end X X    
sqlserver broker_task_idempotent_submit Broker task idempotent submit X X    
sqlserver broker_transmission_acksm_action_fire Broker transmission outgoing ack state machine action fire X X X X
sqlserver broker_transmission_acksm_event_begin Broker transmission outgoing ack state machine event begin X X X X
sqlserver broker_transmission_acksm_event_end Broker transmission outgoing ack state machine event end X X X X
sqlserver broker_transmission_deliverysm_action_fire Broker transmission delivery state machine action fire X X X X
sqlserver broker_transmission_deliverysm_event_begin Broker transmission delivery state machine event begin X X X X
sqlserver broker_transmission_deliverysm_event_end Broker transmission delivery state machine event end X X X X
sqlserver broker_transmission_exception Occurs when an exception is encountered during the processing of transmission objects     X X
sqlserver broker_transmission_lazyflusher_processing_begin Broker transmission lazyflusher processing begin X X X X
sqlserver broker_transmission_lazyflusher_processing_end Broker transmission lazyflusher processing end X X X X
sqlserver broker_transmission_lazyflusher_remove Broker transmission lazyflusher remove X X X X
sqlserver broker_transmission_lazyflusher_submit Broker transmission lazyflusher submit X X X X
sqlserver broker_transmission_object_delete_begin Broker transmission object worktable save end X X X X
sqlserver broker_transmission_object_delete_end Broker transmission object worktable save end X X X X
sqlserver broker_transmission_object_get Broker transmission object load X X X X
sqlserver broker_transmission_object_worktable_load_begin Broker transmission object worktable load begin X X X X
sqlserver broker_transmission_object_worktable_load_end Broker transmission object worktable load end X X X X
sqlserver broker_transmission_object_worktable_save_begin Broker transmission object worktable save begin X X X X
sqlserver broker_transmission_object_worktable_save_end Broker transmission object worktable save end X X X X
sqlserver broker_transmission_timer_armed Broker transmission timer armed X X X X
sqlserver broker_transmission_timer_fire Broker transmission timer fire X X X X
sqlserver broker_transmission_timer_reset Broker transmission timer reset X X X X
sqlserver broker_transmission_timer_set Broker transmission timer set X X X X
sqlserver broker_transmitter_destination_connect Broker transmitter destination connect X X    
sqlserver broker_transmitter_destination_event_fire Broker transmitter destination event fire X X    
sqlserver broker_transmitter_destination_process_begin Broker transmitter destination process begin X X    
sqlserver broker_transmitter_destination_process_end Broker transmitter destination process end X X    
sqlserver broker_transmitter_destination_process_sender_process Broker transmitter destination process sender process X X    
sqlserver broker_transmitter_destination_reference Broker transmitter destination reference X X    
sqlserver broker_transmitter_destination_subscribe Broker transmitter destination subscribe X X    
sqlserver broker_transmitter_destination_unsubscribe Broker transmitter destination unsubscribe X X    
sqlserver broker_transmitter_dialog_reclassify Broker transmitter dialog reclassify X X    
sqlserver broker_transmitter_dialog_register Broker transmitter dialog register X X    
sqlserver broker_transmitter_dialog_unregister Broker transmitter dialog unregister X X    
sqlserver broker_transmitter_reclassification_phase_begin Broker transmitter reclassification phase begin X X    
sqlserver broker_transmitter_reclassification_phase_end Broker transmitter reclassification phase end X X    
sqlserver broker_transmitter_service_create Broker transmitter service created X X    
sqlserver broker_transmitter_service_match Broker transmitter service match X X    
sqlserver broker_transmitter_service_reclassify Broker transmitter service reclassify X X    
sqlserver broker_transmitter_service_send Broker transmitter service send X X    
sqlserver broker_transmitter_transport_stream_update Broker transmitter transport stream update X X    
sqlserver broker_transport_connection_action_fire Broker transport connection event action X X    
sqlserver broker_transport_connection_close Broker transport connection close X X    
sqlserver broker_transport_connection_delimit_message Broker transport connection delimit message X X    
sqlserver broker_transport_connection_dns_lookup Broker transport connection DNS lookup X X    
sqlserver broker_transport_connection_event_begin Broker transport connection event begin X X    
sqlserver broker_transport_connection_event_end Broker transport connection event begin X X    
sqlserver broker_transport_connection_incoming_connect_attempt Broker transport connection incoming connect attempt X X    
sqlserver broker_transport_connection_message_add Broker transport connection message add X X    
sqlserver broker_transport_connection_message_delete Broker transport connection message delete X X    
sqlserver broker_transport_connection_outgoing_connect_attempt Broker transport connection outgoing connect attempt X X    
sqlserver broker_transport_connection_process_receive_control_block Broker transport connection process receive control block X X    
sqlserver broker_transport_connection_read_complete Broker transport connection read complete X X    
sqlserver broker_transport_connection_receive_io_complete Broker transport connection receive I/O complete X X    
sqlserver broker_transport_connection_send_io_complete Broker transport connection send I/O complete X X    
sqlserver broker_transport_connection_winsock_connect_attempt Broker transport connection winsock connect attempt X X    
sqlserver broker_transport_connection_winsock_connect_fail Broker transport connection winsock connect fail X X    
sqlserver broker_transport_connection_winsock_connect_success Broker transport connection winsock connect success X X    
sqlserver broker_transport_connection_winsock_read Broker transport connection winsock read X X    
sqlserver broker_transport_connection_write_complete Broker transport connection write complete X X    
sqlserver broker_transport_flow_control Broker transmitter dialog reclassify X X    
sqlserver broker_transport_global_message_add Broker transport global message add X X    
sqlserver broker_transport_global_message_delete Broker transport global message delete X X    
sqlserver broker_transport_process_boxcar Broker transport process boxcar X X    
sqlserver broker_transport_send Broker transport send X X    
sqlserver buffer_manager_database_pages Buffer manager database pages X X X X
sqlserver buffer_manager_free_pages Buffer manager free pages X X    
sqlserver buffer_manager_page_life_expectancy Buffer manager page life expectancy in milliseconds X X X X
sqlserver buffer_manager_stolen_pages Buffer manager stolen pages X X    
sqlserver buffer_manager_target_pages Buffer manager target pages X X X X
sqlserver buffer_manager_total_pages Buffer manager total pages X X    
sqlserver buffer_node_database_pages Buffer node database pages X X X X
sqlserver buffer_node_free_pages Buffer node free pages X X    
sqlserver buffer_node_page_life_expectancy Buffer node page life expectancy in milliseconds X X X X
sqlserver buffer_node_stolen_pages Buffer node stolen pages X X    
sqlserver buffer_node_target_pages Buffer node target pages X X    
sqlserver buffer_node_total_pages Buffer node total pages X X    
sqlserver buffer_partition_free_list_empty Buffer partition free list empty X X    
sqlserver buffer_partition_free_list_requests Buffer partition free list requests X X    
sqlserver buffer_partition_free_pages Buffer partition free pages X X    
sqlserver buffer_pool_eviction_thresholds_recalculated Lazywriter and/or worker clock has wrapped the BUF array and thresholds are re-calculated.       X
sqlserver buffer_pool_extension_pages_evicted Page is evicted from the buffer pool extension cache.       X
sqlserver buffer_pool_extension_pages_read Page is read from the buffer pool extension cache.       X
sqlserver buffer_pool_extension_pages_written Page or contiguous set of pages evicted into the buffer pool extension cache.       X
sqlserver buffer_pool_page_allocated Page allocated     X X
sqlserver buffer_pool_page_freed Page freed     X X
sqlserver buffer_pool_ring_buffer_recorded Buffer pool ring buffer recorded X X    
sqlserver catalog_metadata_cache_entry_added Catalog metadata cache entry added X X X X
sqlserver catalog_metadata_cache_entry_pinned Catalog metadata cache entry pinned X X X X
sqlserver catalog_metadata_cache_entry_removed Catalog metadata cache entry removed X X X X
sqlserver catalog_metadata_cache_entry_unpinned Catalog metadata cache entry unpinned X X X X
sqlserver catalog_metadata_cache_hit Catalog metadata cache hit X X X X
sqlserver cdc_error CDC Error Information X X X X
sqlserver cdc_session CDC Logscan session Information X X X X
sqlserver change_tracking_cleanup Change Tracking Cleanup X X X X
sqlserver check_phase_tracing Occurs when DBCC CHECK enters a new phase of the checking. Use this event to trace the phases of DBCC CHECK process.       X
sqlserver check_thread_message_statistics Occurs when a phase of DBCC CHECK is finished. Use this event to collect the number of messages a DBCC CHECK thread has sent or received.       X
sqlserver check_thread_page_io_statistics Occurs when a phase of DBCC CHECK is finished. Use this event to collect the number of logical, physical, and read-ahead IOs a DBCC CHECK thread has performed.       X
sqlserver check_thread_page_latch_statistics Occurs when a phase of DBCC CHECK is finished. Use This event to collect the number and time of page latch and IO latch waits.       X
sqlserver checkpoint_begin Checkpoint has begun X X X X
sqlserver checkpoint_end Checkpoint has ended X X X X
sqlserver clustered_columnstore_index_rebuild Occurs when clustered index on the table was rebuilt. This event is raised three times for ALTER index rebuild operation on CCSI. The event is raised when the operation takes lock on index rebuild resource, when lock is taken on the table and when S lock on the table is upgraded to SCH_M lock to switch indexes in metadata.       X
sqlserver column_store_code_coverage Code coverage Xevent for columnstore code.       X
sqlserver column_store_index_build_low_memory Occurs when Storage Engine detects low memory condition and the rowgroup size is reduced.       X
sqlserver column_store_index_build_process_segment Occurs when a segment is processed       X
sqlserver column_store_index_build_throttle Shows the statistics of columnstore index build parallelism throttling       X
sqlserver column_store_object_pool_hit Occurs when a look up into the column store object pool, finds the object in the pool.     X X
sqlserver column_store_object_pool_miss Occurs when a look up into the column store object pool cannot find the object in the pool.     X X
sqlserver column_store_rowgroup_read_issued Occurs when we issue read for a rowgroup during a scan on a column store.     X X
sqlserver column_store_rowgroup_readahead_issued Occurs when we issue read-ahead for a rowgroup during a scan on a column store.     X X
sqlserver column_store_segment_eliminate Occurs when a filter eliminates column store segment during scan.     X X
sqlserver columnstore_tuple_mover_begin_compress Occurs when column store tuple mover starts compressing a deltastore.       X
sqlserver columnstore_tuple_mover_end_compress Occurs when column store tuple mover is done compressing a deltastore.       X
sqlserver commit_tran_completed Occurs when a COMMIT TRANSACTION request that was sent from a client application through the transaction management interface has completed.     X X
sqlserver commit_tran_starting Occurs when a COMMIT TRANSACTION request that was sent from a client application through the transaction management interface has started.     X X
sqlserver connectivity_ring_buffer_recorded Occurs when there is a server-initiated connection closure, such as login failed.     X X
sqlserver constant_page_corruption_detected A page that should have been constant has changed X X X X
sqlserver cpu_threshold_exceeded Occurs when Resource Governor detects that a query has exceeded the CPU threshold that is specified for REQUEST_MAX_CPU_TIME_SEC. The detection interval is five seconds. The event is guaranteed to detect the queries that exceed the threshold by at least five seconds. If a query exceeds the threshold by less than five seconds, the detection might be missed, depending on the timing of the query and the time of the last detection sweep.     X X
sqlserver cursor_close Occurs when a cursor is deallocated. This event is used for troubleshooting cursor performance issues.     X X
sqlserver cursor_execute Occurs when a cursor is created and executed. This event is used for troubleshooting cursor performance issues.     X X
sqlserver cursor_implicit_conversion Occurs when a cursor is converted to a different cursor type because the requested cursor does not support the statement that is being executed. This event is used to troubleshoot cursor performance issues.     X X
sqlserver cursor_manager_cached_cursor_added Cursor manager cached cursor added X X X X
sqlserver cursor_manager_cached_cursor_removed Cursor manager cached cursor removed X X X X
sqlserver cursor_manager_cursor_begin Cursor manager cursor begin X X X X
sqlserver cursor_manager_cursor_cache_attempt Cursor manager cursor cache attempt X X X X
sqlserver cursor_manager_cursor_cache_hit Cursor manager cursor cache hit X X X X
sqlserver cursor_manager_cursor_end Cursor manager cursor end X X X X
sqlserver cursor_manager_cursor_memory_usage Cursor manager cursor memory usage X X X X
sqlserver cursor_manager_cursor_plan_begin Cursor manager cursor plan begin X X X X
sqlserver cursor_manager_cursor_plan_end Cursor manager cursor plan end X X X X
sqlserver cursor_manager_cursor_worktable_use_begin Cursor manager cursor worktable use begin X X X X
sqlserver cursor_manager_cursor_worktable_use_end Cursor manager cursor worktable use end X X X X
sqlserver cursor_open Occurs when a statement is defined for a cursor, the cursor properties are set, and the cursor is populated. Use this event to troubleshoot cursor performance issues.     X X
sqlserver cursor_prepare 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.     X X
sqlserver cursor_recompile Occurs when an execution plan that contains a cursor is recompiled. Use this event to troubleshoot cursor performance issues.     X X
sqlserver cursor_unprepare Occurs when an execution plan that contains a cursor is discarded. Use this event to troubleshoot cursor performance issues.     X X
sqlserver database_attached Database attached X X X X
sqlserver database_created Database created     X X
sqlserver database_detached Database detached X X X X
sqlserver database_file_size_change 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 files.     X X
sqlserver database_mirroring_state_change Occurs when the state of a database mirror has changed. Use this event to monitor the condition of a database mirror.     X X
sqlserver database_started Database started X X X X
sqlserver database_stopped Database stopped X X X X
sqlserver database_suspect_data_page 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.     X X
sqlserver database_transaction_begin Occurs when a database transaction begins. X X X X
sqlserver database_transaction_end Occurs when a database transaction ends. X X X X
sqlserver database_uncontained_usage Occurs when an uncontained usage is detected during the compilation of a statement.     X X
sqlserver database_xml_deadlock_report Produces a deadlock report for a victim, with information scoped to the victim's database.       X
sqlserver databases_backup_restore_throughput Databases backup/restore throughput X X X X
sqlserver databases_bulk_copy_rows Databases bulk copy rows (due to bcp activity) X X X X
sqlserver databases_bulk_copy_throughput Databases bulk copy throughput in KB (due to bcp activity) X X X X
sqlserver databases_bulk_insert_rows Databases bulk insert rows (due to BULK INSERT)     X X
sqlserver databases_bulk_insert_throughput Databases bulk insert throughput in KB (due to BULK INSERT)     X X
sqlserver databases_data_file_size_changed Databases data file size change X X X X
sqlserver databases_dbcc_logical_scan Databases DBCC logical scan X X X X
sqlserver databases_log_cache_hit Databases log cache hit X X X X
sqlserver databases_log_cache_read Databases log cache read X X X X
sqlserver databases_log_file_size_changed Databases log file size changed X X X X
sqlserver databases_log_file_used_size_changed Databases log file used size changed X X X X
sqlserver databases_log_flush Databases log flush X X X X
sqlserver databases_log_flush_wait Databases log flush wait in milliseconds X X X X
sqlserver databases_log_growth Databases log growth X X X X
sqlserver databases_log_shrink Databases log shrink X X X X
sqlserver databases_log_truncation Databases log truncation X X X X
sqlserver databases_shrink_data_movement Databases shrink data movement X X X X
sqlserver db_lock_acquired_from_cache Occurs when a DB lock is acquired from the XactWorkspace DB lock cache.       X
sqlserver db_lock_released_from_cache Occurs when a DB lock is released from the XactWorkspace DB lock cache.       X
sqlserver ddl_with_wait_at_low_priority A DDL statement was executed using the WAIT_AT_LOW_PRIORITY options       X
sqlserver deadlock_monitor_mem_stats Deadlock monitor memory utilization statistics X X X X
sqlserver deadlock_monitor_perf_stats Deadlock monitor performance statistics X X X X
sqlserver deadlock_monitor_pmo_status Deadlock monitor PMO status at various checkpoints in the LDM cycle X X X X
sqlserver deadlock_monitor_serialized_local_wait_for_graph Deadlock monitor local wait-for graph dump in binary form X X X X
sqlserver deadlock_monitor_state_transition Deadlock Monitor state transition X X X X
sqlserver degree_of_parallelism Occurs every time that SQL Server executes a SELECT, INSERT, UPDATE, or DELETE statement. Use this event to monitor if a query is running in parallel.     X X
sqlserver deprecation_announcement Occurs when you use a feature that will be removed from a future version of SQL Server, but will not be removed from the next major release of SQL Server. X X X X
sqlserver deprecation_final_support Occurs when you use a feature that will be removed from the next major release of SQL Server. X X X X
sqlserver diag_quantum_end Occurs when the diag is notified of quantum end.       X
sqlserver disk_log_read Occurs when a disk log read is issued.     X X
sqlserver disk_log_read_ignore Occurs when a disk log read is ignored.     X X
sqlserver dtc_transaction Occurs when a SQL Server transaction is coordinated through Microsoft Distributed Transaction Coordinator.     X X
sqlserver dyn_throttle_checkpoint Occurs when checkpointing has been dynamically throttled with a new Checkpoint rate.       X
sqlserver error_reported Occurs when an error is reported. X X X X
sqlserver error_ring_buffer_recorded Error ring buffer recorded X X    
sqlserver errorlog_written Errorlog written X X X X
sqlserver exchange_spill 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     X X
sqlserver exec_prepared_sql Occurs when a prepared Transact-SQL statement was executed by SQLClient, ODBC, OLE DB or DB-Library.     X X
sqlserver execution_warning Occurs when a T-SQL statement or stored procedure waits more than one second for a memory grant or when the initial attempt to get memory fails. Use this event in combination with events that identify waits to troubleshoot contention issues that impact performance     X X
sqlserver existing_connection Occurs when an Extended Events session is started. To avoid duplicate (or secondary) existing_connection events when other Extended Events sessions are started, we recommend that you always use this event with the following predicate: WHERE started_event_session_name = 'your_event_session_name'.     X X
sqlserver expression_compile_stop_batch_processing Occurs when an expression is not natively supported in batch processing mode and a wrapper of row-by-row evaluation is used.     X X
sqlserver extent_activation_cache_overflow Occurs when the extent activation cache has reached its max size and we have to go into overflow mechanism.     X X
sqlserver failed_hresult Failed HRESULT X X X X
sqlserver failed_hresult_msg Failed HRESULT X X X X
sqlserver fastloadcontext_enabled Occurs when fastloadcontext is activated / deactivated X X X X
sqlserver feature_extension Occurs when received and parses data for a feature in feature extension.       X
sqlserver file_handle_in_use Fired when a file handle we're trying to delete is in use and we don't expect it to be. The typical response is dumping all the handles in the system via SysInternals HANDLE.EXE       X
sqlserver file_read File read X X X X
sqlserver file_read_completed File read completed X X X X
sqlserver file_read_enqueued File read enqueued       X
sqlserver file_read_throttled File read throttled       X
sqlserver file_write_completed File write completed X X X X
sqlserver file_write_enqueued File write enqueued       X
sqlserver file_write_throttled File write throttled       X
sqlserver file_written File written X X X X
sqlserver file_written_to_replica File writes issued to sparse file for replica DB   X X X
sqlserver filestream_file_io_dump FILESTREAM file I/O streaming access dump X X X X
sqlserver filestream_file_io_failure FILESTREAM file I/O streaming access failure X X X X
sqlserver filestream_file_io_request FILESTREAM file I/O streaming access request X X X X
sqlserver filestream_file_io_response Response to a FILESTREAM file I/O streaming access request X X X X
sqlserver filestream_file_io_trace FILESTREAM file I/O streaming access tracing information X X X X
sqlserver filestream_file_write_completion Occurs when a write completion for a FILESTREAM file is received.     X X
sqlserver flush_file_buffers FlushFileBuffers called X X X X
sqlserver full_text_crawl_started Occurs when a full-text crawl (population) is started. Use this event to monitor full-text crawl operations.     X X
sqlserver full_text_crawl_stopped Occurs when a full-text crawl (population) is stopped. Use this event to monitor full-text crawl operations.     X X
sqlserver full_update_instead_of_partial_update Occurs when a DML operation that is intended to overwrite only part of a large column value is forced to rewrite the entire value.  This happens if the table's heap or clustered index is being built online.  Use this event to identify DML workloads that are running more slowly as a result of building an index online.     X X
sqlserver fulltext_query_exec_stats Produces a fulltext query execution statistics report in XML format.     X X
sqlserver fulltext_query_recompile Reports the reason for issuing recompile of a fulltext query.     X X
sqlserver fulltext_reorganize_phase1_destination_fragment Reports a destination fragment that has been created by one of the Phase1 background merge work items.     X X
sqlserver fulltext_reorganize_phase1_source_fragment Reports a fragment that has been selected as a source fragment by one of the Phase1 background merge work items.     X X
sqlserver fulltext_reorganize_progress Reports the reorganize progress for a given table.     X X
sqlserver fulltext_reorganize_source_fragment Reports a source fragment before running Phase1 of the reorganize operation. The process raises as many events of this type as there are source fragments.     X X
sqlserver fulltext_reorganize_start Indicates the start of a fulltext reorganize operation for the table identified by table_id.     X X
sqlserver fulltext_semantic_document_language Reports the language used for each document by semantic indexing during a full-text crawl with statistical_semantics enabled     X X
sqlserver ghost_cleanup Ghost cleanup X X X X
sqlserver ghost_cleanup_task_packet_enqueue A task packet is enqueued       X
sqlserver ghost_cleanup_task_process_packet A task packet is dequeued and processed       X
sqlserver ghost_cleanup_task_process_pages_for_db_packet Purge the pages that contain ghost records found in a database       X
sqlserver ghost_cleanup_task_start Ghost cleanup task start       X
sqlserver ghost_cleanup_task_suspend Ghost cleanup task suspend       X
sqlserver group_commit_value_changed Number of group commit waiters has changed   X X X
sqlserver hadr_ag_config_data_mutex_acquisition_state HADR availability group mutex acquisition state (point of interest for tracing/testing) for accessing local availability group config data.     X X
sqlserver hadr_ag_database_api_call HADR Availability Group database replica API call.     X X
sqlserver hadr_ag_lease_renewal HADR Availability Group Lease Renewal.     X X
sqlserver hadr_ag_wsfc_resource_state HADR Availability Group state in Wsfc.     X X
sqlserver hadr_apply_log_block Occurs when secondary is going to append a log block to logmgr.     X X
sqlserver hadr_apply_vlfheader Occurs when secondary is going to apply a VLF header.     X X
sqlserver hadr_ar_api_call HADR Availability replica API call.     X X
sqlserver hadr_ar_critical_section_entry_state HADR availability replica critical section entry state (point of interest for tracing/testing).     X X
sqlserver hadr_ar_manager_mutex_acquisition_state HADR availability replica mutex acquisition state for synchronization of ar manager startup and shutdown operations.     X X
sqlserver hadr_ar_manager_starting HADR Availability Group replica manager is starting.     X X
sqlserver hadr_capture_compressed_log_cache Hit/miss ratio for the compressed log block cache.     X X
sqlserver hadr_capture_log_block Occurs when primary has captured a log block.     X X
sqlserver hadr_capture_vlfheader Occurs when primary has captured a log block which starts new virtual file.     X X
sqlserver hadr_database_flow_control_action Indicates that a flow control action has occured for a particular dbr/replica.     X X
sqlserver hadr_database_replica_disjoin_completion HADR Database Replica has been fully unjoined from the Availability Group.     X x
sqlserver hadr_db_commit_mgr_harden Transaction Commit harden result from Hadron Commit management.     X X
sqlserver hadr_db_commit_mgr_harden_still_waiting Transaction Commit harden still waiting for Hadron Commit management.     X X
sqlserver hadr_db_commit_mgr_set_policy Transaction Commit manager policy update.     X X
sqlserver hadr_db_commit_mgr_update_harden Update the hardened LSN for a HADR database.     X X
sqlserver hadr_db_manager_backup_info_msg Backup Info message.     X X
sqlserver hadr_db_manager_backup_sync_msg Backup Sync message.     X X
sqlserver hadr_db_manager_db_queue_restart Queue restart hadron datadabase.     X X
sqlserver hadr_db_manager_db_restart Restart hadron database.     X X
sqlserver hadr_db_manager_db_shutdown Shutdown hadron datadabase.     X X
sqlserver hadr_db_manager_db_startdb Start hadron database.     X X
sqlserver hadr_db_manager_establish_db_msg Establish DB message.     X X
sqlserver hadr_db_manager_filemetadata_request File Metadata Request/Response between servers.     X X
sqlserver hadr_db_manager_lsn_sync_msg LSN Sync message.     X X
sqlserver hadr_db_manager_page_request Page Request/Response between servers.     X X
sqlserver hadr_db_manager_redo Redo processing on secondary.     X X
sqlserver hadr_db_manager_redo_control Change log scan status for a hadron controlled database.     X X
sqlserver hadr_db_manager_scan_control Change log scan status for a hadron controlled database.     X X
sqlserver hadr_db_manager_state Indicates db_manager state changes.     X X
sqlserver hadr_db_manager_status_change DBReplicaStatusChange message.     X X
sqlserver hadr_db_manager_suspend_resume Change suspend/resume status for a hadron controlled database.     X X
sqlserver hadr_db_manager_undo Undo processing on secondary.     X X
sqlserver hadr_db_manager_user_control Change user status for a hadron controlled database.     X X
sqlserver hadr_db_partner_set_policy HADR partner commit policy update.     X X
sqlserver hadr_db_partner_set_sync_state HADR partner sync state change.     X X
sqlserver hadr_ddl_failover_execution_state HADRON DDL Alter AG failover state     X X
sqlserver hadr_dump_log_block Occurs when primary send or secondary receives logblock message.     X X
sqlserver hadr_dump_log_progress Occurs when secondary sends progress message.     X X
sqlserver hadr_dump_primary_progress Occurs when primary sends progress message.     X X
sqlserver hadr_dump_sync_primary_progress Occurs when sync secondary sends a progress message     X X
sqlserver hadr_dump_vlf_header Occurs when primary send or secondary receives vlfheader message.     X X
sqlserver hadr_evaluate_readonly_routing_info Occurs when evaluating read-only routing information on a local primary DB replica.     X X
sqlserver hadr_filestream_corrupt_message Occurs when HADR FileStream transport detects message corruption.     X X
sqlserver hadr_filestream_directory_create Occurs when HADR FileStream transport creates a directory.     X X
sqlserver hadr_filestream_file_close Occurs when HADR FileStream transport closes a file.     X X
sqlserver hadr_filestream_file_flush Occurs when HADR FileStream transport flushes a file.     X X
sqlserver hadr_filestream_file_open Occurs when HADR FileStream transport opens a file.     X X
sqlserver hadr_filestream_file_set_eof Occurs when HADR FileStream transport sets end of a file.     X X
sqlserver hadr_filestream_log_interpreter Occurs when HADR FileStream transport finds relevant log records when interpreting log.     X X
sqlserver hadr_filestream_message_block_end Occurs when HADR FileStream transport traces a block end message.     X X
sqlserver hadr_filestream_message_dir_create Occurs when HADR FileStream transport traces a directory create message.     X X
sqlserver hadr_filestream_message_file_request Occurs when HADR FileStream transport traces a file write message.     X X
sqlserver hadr_filestream_message_file_write Occurs when HADR FileStream transport traces a file write message.     X X
sqlserver hadr_filestream_processed_block Occurs when HADR FileStream transport has completed processing a log block.     X X
sqlserver hadr_filestream_undo_inplace_update Occurs when HADR FileStream transport detects inplace update to undo.     X X
sqlserver hadr_online_availability_group_first_attempt_failure First attempt to bring a HADR Availability Group resource online failed.  SQL Server will retry the operation at regular intervals.     X X
sqlserver hadr_online_availability_group_retry_end SQL Server has either exhausted all retry attempts, or Windows Server Failover Cluster has accepted the command to bring a HADR Availability Group resource online.     X X
sqlserver hadr_scan_state Occurs when primary or secondary DBR is changing state     X X
sqlserver hadr_sql_instance_to_node_map_entry_deleted End of API that deletes a SQL Server instance to cluster node map entry.     X X
sqlserver hadr_tds_synchronizer_payload_skip Hadron Tds Listener Synchronizer skipped a listener payload because there were no changes since the previous payload.       X
sqlserver hadr_thread_pool_worker_start HADRON thread pool worker thread start actions.     X X
sqlserver hadr_transport_dump_config_message Use this event to help trace HADR configuration messages.     X X
sqlserver hadr_transport_dump_message Use this event to trace HADR transport messages throughout the system.     X X
sqlserver hadr_transport_dump_message Use this event to trace HADR transport messages throughout the system.       X
sqlserver hadr_transport_flow_control_action Indicates that a flow control action has occured for a particular replica.     X X
sqlserver hadr_transport_session_state This event occurs when a HADR transport session changes states.     X X
sqlserver hadr_transport_ucs_connection_info Occurs when the ucs connection id associated with the hadron transport replica is registered or changes.     X X
sqlserver hadr_undo_of_redo_log_scan Amount of log scanned in Undo of Redo and Total log need to be scanned.     X X
sqlserver hadr_worker_pool_task HADRON worker pool task actions.     X X
sqlserver hadr_worker_pool_thread HADRON worker pool thread actions.     X X
sqlserver hadr_wsfc_change_notifier_node_not_online HADR Windows Server Failover Clustering change notifier detected that the local cluster node is not online.  Change notifier will terminate.     X X
sqlserver hadr_wsfc_change_notifier_severe_error HADR Windows Server Failover Clustering change notifier encountered a severe error and will terminate.     X X
sqlserver hadr_wsfc_change_notifier_start_ag_specific_notifications HADR Windows Server Failover Clustering change notifier starts receiving Availability Group specific notifications.     X X
sqlserver hadr_wsfc_change_notifier_status HADR Windows Server Failover Clustering change notifier status.     X X
sqlserver hadr_xrf_copyXrf_partialCopy Occurs after deleting secondary's stack entries but before copying primary's entries.     X X
sqlserver hadr_xrf_deleteAllXrf_beforeEntry Occurs just before deleting all the extended recovery forks.     X X
sqlserver hadr_xrf_deleteRecLsn_beforeEntry Occurs just before deleting the recovery LSN in the metadata.     X X
sqlserver hadr_xrf_updateXrf_before_recoveryLsn_update Occurs during updating secondary's recovery forks stack. After updating the stack but before saving the recovery LSN in the metadata.     X X
sqlserver hadr_xrf_updateXrf_partialUpdate Occurs during updating secondary's recovery forks stack. After deleting extra entries in the secondary stack but before copying new entries from primary.     X X
sqlserver hash_warning Occurs when there is insufficient memory to process the build input of a hash join. This results in either a hash recursion when the build input is partitioned, or a hash bailout when the partitioning of the build input exceeds the maximum recursion level. Use this event together with any of the query_pre_execution_showplan or query_post_execution_showplan events to determine which operation in the generated plan is causing the hash warning.     X X
sqlserver hekaton_slow_param_passing Occurs when a Hekaton procedure call dispatch goes to slow parameter passing code path     X  
sqlserver hobt_schema_mgr_allocation_unit HoBt Schema Manager allocation unit operations     X X
sqlserver hobt_schema_mgr_column HoBt Schema Manager column operations     X X
sqlserver hobt_schema_mgr_factory HoBt Schema Manager Startup/Shutdown operations     X X
sqlserver hobt_schema_mgr_hobt HoBt Schema Manager HoBt operations     X X
sqlserver hobt_schema_mgr_hobt_attributes HoBt Schema Manager HoBt attributes operations     X X
sqlserver hobt_schema_mgr_hobt_page HoBt Schema Manager HoBt page operations     X X
sqlserver host_task_ring_buffer_recorded AppDomain ring buffer recorded X X X X
sqlserver inaccurate_cardinality_estimate Occurs when an operator outputs significantly more rows than estimated by the Query Optimizer. Use this event to identify queries that may be using sub-optimal plans due to cardinality estimate inaccuracy. Using this event can have a significant performance overhead so it should only be used when troubleshooting or monitoring specific problems for brief periods of time.     X X
sqlserver index_build_extents_allocation Occurs when new extents are allocated during index building. Use this event to indentify how extents are used by an index.     X X
sqlserver ioaff_node_summary Parallel scan with IO affinity started     X X
sqlserver ioaff_scan_end Parallel scan with IO affinity ended     X X
sqlserver ioaff_scan_start Parallel scan with IO affinity started     X X
sqlserver ioaff_scan_worker_end Parallel scan worker finished processing     X X
sqlserver ioaff_scan_worker_start Parallel scan worker started processing     X X
sqlserver latch_acquire_time Time taken to acquire a latch   X X X
sqlserver latch_demoted Occurs when a super latch is demoted to an ordinary latch. X X X X
sqlserver latch_promoted Occurs when a latch is promoted to a super latch. X X X X
sqlserver latch_suspend_begin Occurs when a the executing task must suspend while waiting for a latch to become available in the requested mode. X X X X
sqlserver latch_suspend_end Occurs when the executing task is resumed after waiting for a latch. X X X X
sqlserver latch_suspend_warning Occurs when there is a timeout waiting for a latch possibly causing performance problems.     X X
sqlserver leaf_page_disfavored Index leaf page disfavored during scan X X X X
sqlserver lock_acquired Occurs when a lock is acquired on an object. Use this event to troubleshoot data contention issues that are caused by locks that are being held for long periods of time. X X X X
sqlserver lock_cancel Occurs when the request for a lock was canceled, such as when the query requesting the lock was canceled. Use this event to monitor locks.     X X
sqlserver lock_deadlock Occurs when an attempt to acquire a lock is canceled for the victim of a deadlock. X X X X
sqlserver lock_deadlock_chain Occurs when an attempt to acquire a lock generates a deadlock. This event is raised for each participant in the deadlock.     X X
sqlserver lock_escalation Occurs when a fine-grain lock is converted into a coarser-grain lock, such as when a row lock is converted into an object lock. Use this event to monitor how locks are being used on the server.     X X
sqlserver lock_redo_blocked Occurs when the redo thread blocks when trying to acquire a lock.     X X
sqlserver lock_redo_unblocked Occurs when the redo thread blocks when trying to acquire a lock.     X X
sqlserver lock_released Lock released X X X X
sqlserver lock_request_priority_state The priority state of a lock request       X
sqlserver lock_timeout Occurs when a request for a lock times out because another transaction holds a blocking lock on the required resource. The time-out duration is determined by the @@LOCK_TIMEOUT system function. Use this event to help troubleshoot blocking issues.     X X
sqlserver lock_timeout_greater_than_0 Occurs when a request for a lock times out because of a blocking lock that is being held by a different resource. This event is identical to lock_timeout, but excludes cases in which the time-out value is 0, such as when lock probes are used. Time-outs with a duration of 0 do not necessarily indicate a blocking problem.     X X
sqlserver locks_lock_timeouts Occurs when a request for a lock times out because another transaction holds a blocking lock on the required resource. The time-out duration is determined by the @@LOCK_TIMEOUT system function. Use this event to help troubleshoot blocking issues. X X    
sqlserver locks_lock_timeouts_greater_than_0 Occurs when a request for a lock times out because of a blocking lock that is being held by a different resource. This event is identical to lock_timeout, but excludes cases in which the time-out value is 0, such as when lock probes are used. Time-outs with a duration of 0 do not necessarily indicate a blocking problem. X X    
sqlserver locks_lock_waits Locks lock waits X X X X
sqlserver log_block_cache Occurs when a log block is cached into Log Pool.     X X
sqlserver log_block_consume Occurs when a log block is consumed by a LogConsumer.     X X
sqlserver log_block_move Occurs along with a log block in a shared cache buffer being moved within the replacement set     X X
sqlserver log_block_persistence_reset Occurs along with the persistence status of a log block in a shared cache buffer being reset to persistent     X X
sqlserver log_blocks_uncache Occurs when a log cache buffer is replaced or removed.     X X
sqlserver log_buffer_allocated Log write buffer was allocated   X X X
sqlserver log_buffer_freed Log block was freed   X X X
sqlserver log_cache_buffer_refcounter_change Occurs along with a cache buffer's reference counter being incremented or decremented.     X X
sqlserver log_cache_write_block Writing a log block to the log cache       X
sqlserver log_consumer_act Occurs along with a log consumer's log consumption activity during its life time.     X X
sqlserver log_consumer_life Occurs when a log consumer is initialized or closed.     X X
sqlserver log_consumer_read_ahead Occurs along with a log consumer's reading a log block ahead.     X X
sqlserver log_flush_complete Log write complete     X X
sqlserver log_flush_requested Log flush was requested   X X X
sqlserver log_flush_retry Log write had to retry     X X
sqlserver log_flush_start Asynchronous log write start     X X
sqlserver log_generate_stall Log record generation stall for outstanding writes to complete     X X
sqlserver log_pool_memory_status Occurs when log pool receives a memory status notification.     X X
sqlserver log_single_record Generate a log record     X X
sqlserver login Occurs when a successful connection is made to the Server. This event is fired for new connection or when connections are reused from a connection pool     X X
sqlserver logout Occurs when a user has logged out of (logged off) the Server. This event is required in traces that will be used for Replay     X X
sqlserver logreader_add_compensation_range Occurs when the replication logreader encounters a partial rollback for a particular transaction. X X X X
sqlserver logreader_add_eor Occurs when the replication logreader agent reads and EOR record. X X X X
sqlserver logreader_add_tran_info Outputs transactions which are added to the repl hash table as well as some hash table statistics.  X X X X
sqlserver logreader_apply_filter_proc Occurs when the replication logreader agent executes a horizontal filtering proc. X X X X
sqlserver logreader_process_filestream_info Occurs when a filestream info record is read by the replication logreader. X X X X
sqlserver logreader_process_text_info Occurs when a text info record is read by the replication logreader. X X X X
sqlserver logreader_process_text_ptr Occurs when a text pointer is being read by the replication logreader. X X X X
sqlserver logreader_start_scan Outputs the replnextlsn value from the database table that the first replcmds scan uses as a starting point.       X
sqlserver long_io_detected Long IO detected X X X X
sqlserver memory_manager_database_cache_memory Amount of memory the server is currently using for database cache.     X X
sqlserver memory_manager_free_memory Amount of memory the server is currently not using.     X X
sqlserver memory_manager_reserved_server_memory Amount of memory the server has reserved for future usage. This value shows current unused amount of the initial grant shown in Granted Workspace Memory (KB).     X X
sqlserver memory_manager_stolen_server_memory Amount of memory the server is currently using for the purposes other than the database pages.     X X
sqlserver memory_manager_target_server_memory Ideal amount of memory for the server.     X X
sqlserver memory_manager_total_server_memory Total amount of memory the server has committed.     X X
sqlserver memory_node_database_node_memory Amount of memory the server is using on this node for database pages.     X X
sqlserver memory_node_foreign_node_memory Non NUMA-local amount of memory on this node     X X
sqlserver memory_node_free_node_memory  Amount of memory the server is not using on this node     X X
sqlserver memory_node_stolen_node_memory Amount of memory the server is using on this node for the purposes other than database pages.     X X
sqlserver memory_node_target_node_memory Ideal amount of memory for this node     X X
sqlserver memory_node_total_node_memory Total amount of memory the server has committed on this node.     X X
sqlserver metadata_ddl_add_column Occurs when an ALTER TABLE ADD column operation is updating base index.       X
sqlserver metadata_ddl_alter_column Occurs when an ALTER TABLE ALTER column operation is updating base index.       X
sqlserver metadata_ddl_drop_column Occurs when an ALTER TABLE DROP column operation is updating base index.       X
sqlserver metadata_persist_last_value_for_sequence Pre-allocating new cache range for a Sequence object.See system view sys.sequences for more details.     X X
sqlserver missing_column_statistics Occurs when a query accesses a column that does not have statistics available that could have been useful for query optimization. Use this event to identify queries that may be using sub-optimal plans. This event is only generated when the Auto Create Statistics option is turned off.     X X
sqlserver missing_join_predicate Occurs when an executed query is missing a join predicate. Use this event to identify a query that may perform slowly because of the missing predicate. This event only occurs if both sides of the join return more than one row.     X X
sqlserver mixed_extent_activation Track mixed extent activation and deactivation operations.       X
sqlserver mixed_extent_allocation Track mixed extent allocation operations       X
sqlserver mixed_extent_deallocation Track mixed extent deallocation operations.       X
sqlserver mixed_page_allocation Track mixed page allocation operations       X
sqlserver mixed_page_deallocation Track mixed page allocation operations       X
sqlserver mixed_page_scan_file Track the activity of SGAM scans for mixed page allocation       X
sqlserver mixed_page_scan_page Track the activity of SGAM scans for mixed page allocation       X
sqlserver mixed_page_skipextent Track the activity of SGAM scans for mixed page allocation       X
sqlserver module_end End of module execution X X X X
sqlserver module_start Start of module execution X X X X
sqlserver natively_compiled_proc_execution_started Fired before a natively compiled procedure is executed.       X
sqlserver natively_compiled_proc_slow_parameter_passing Occurs when a Hekaton procedure call dispatch goes to slow parameter passing code path       X
sqlserver new_log_interest_flip Occurs when the indicator on whether any LogConsumer is interested in new log to be generated changes.     X X
sqlserver object_altered Occurs when an object was altered by the ALTER statement. This event is raised two times for every ALTER operation. The event is raised when the operation begins and when the operation is either rolled back or committed. Add the nt_username or server_principal_name actions to this event to determine who altered the object.     X X
sqlserver object_created Occurs when an object was created by the CREATE statement. This event is raised two times for every CREATE operation. The event is raised when the operation begins and when the operation is either rolled back or committed. Add the nt_username or server_principal_name actions to this event to determine who altered the object.     X X
sqlserver object_deleted Occurs when an object was deleted by the DROP statement. This event is raised two times for every DROP operation. The event is raised when the operation begins and when the operation is either rolled back or committed. Add the nt_username or server_principal_name actions to this event to determine who altered the object.     X X
sqlserver oiblob_cleanup_begin Occurs when cleanup has started for online index build with LOBs.     X X
sqlserver oiblob_cleanup_end Occurs when cleanup has finished for online index build with LOBs.     X X
sqlserver oledb_call Occurs when SQL Server calls on OLEDB provider for a distributed query or remote stored procedure. Use this event to monitor OLEDB calls that do not return data or that do not use the QueryInterface method. This event will be trigged twice for each OLEDB call, once when it starts and once when it completes     X X
sqlserver oledb_data_read Occurs when SQL Server calls on OLEDB provider for a distributed query or remote stored procedure. Use this event to monitor OLEDB calls that make data requests to the OLEDB provider. This event will be trigged twice for each OLEDB call, once when it starts and once when it completes     X X
sqlserver oledb_error Occurs when an OLEDB Call to a remote provider returns an error. Use this event to view the Hresult returned from failed OLEDB Calls     X X
sqlserver oledb_provider_information Occurs when a connection is made to an OLE DB provider. This event collects properties from the remote provider from several property sets, including the following: DBPROPSET_DATASOURCEINFO, SQLPROPSET_OPTHINTS, DBPROPSET_SQLSERVERDATASOURCEINFO (SQL Server only), DBPROPSET_SQLSERVERDBINIT (SQL Server only), DBPROPSET_ROWSET, and the IDBInfo interface. Use this event to analyze and troubleshoot OLE DB provider calls in remote queries.     X X
sqlserver oledb_query_interface Occurs when SQL Server calls on OLEDB provider for a distributed query or remote stored procedure. Use this event to monitor OLEDB calls that use the QueryInterface method. This event will be trigged twice for each OLEDB call, once when it starts and once when it completes     X X
sqlserver optimizer_timeout Occurs when the optimizer times out either due to spending too much time or hitting a memory limit.  Use this event to look at all the queries that are impacted by the optimizer timeout in a particular workload. This can be very useful when tuning a particular workload.       X
sqlserver packet_enqueued Occurs when a network packet is enqueued.     X X
sqlserver page_compression_attempt_failed An attempt to compress a database page failed X X X X
sqlserver page_compression_tracing Entry and exit tracking for page compression operations X X X X
sqlserver page_reference_tracker Page is being looked up     X X
sqlserver page_split Page split X X X X
sqlserver perfobject_logicaldisk Returns a set of counters associated with the Logical Disk performance object. The event occurs once every 15 seconds for each hard or fixed disk drive.   X X X
sqlserver perfobject_process Returns a set of counters associated with the Process performance object. The event occurs once every 15 seconds for both the SQL Server and SQL Agent processes.   X X X
sqlserver perfobject_processor Returns a set of counters associated with the Processor performance object. The event occurs once every 15 seconds for each processor in the system.   X X X
sqlserver perfobject_system Returns a set of counters associated with the System performance object. The event occurs once every 15 seconds.   X X X
sqlserver physical_page_read Physical page read X X X X
sqlserver physical_page_write Physical page write X X X X
sqlserver plan_affecting_convert Occurs when a type convert issue affects the plan.  The expression value indicates the conversion that can cause inaccurate Cardinality Estimation or prevent from using a seek based plan in the query plan choice.  If performance is affected, rewriting the query could help.       X
sqlserver plan_cache_cache_attempt Plan cache cache attempt X X X X
sqlserver plan_cache_cache_hit Plan cache cache hit X X X X
sqlserver plan_guide_successful Occurs when a plan is created for a query or batch that includes a plan guide. Use this event to determine when plan guides are successfully applied.     X X
sqlserver plan_guide_unsuccessful Occurs when an execution plan is created for a query or batch without using the provided plan guide. Use this event to identify queries and batches with invalid plan guides. Use the sys.fn_validate_plan_guide function to detect errors in the plan guide.     X X
sqlserver preconnect_completed Occurs when a LOGON trigger or a Resource Governor classifier function finishes execution.     X X
sqlserver preconnect_starting Occurs when a LOGON trigger or a Resource Governor classifier function begins execution.     X X
sqlserver prefetch_extent Prefetch issued for a whole extent instead of a single page X X X X
sqlserver prelogin_traceid Occurs when a prelogin containing a traceid arrives on a connection.     X X
sqlserver prepare_sql Occurs when a Transact-SQL statement was prepared by SQLClient, ODBC, OLE DB or DB-Library.     X X
sqlserver process_invalidate_cache_logrec Process an invalidate cache log record     X X
sqlserver process_killed_by_abort_blockers A process is killed by an ABORT = BLOCKERS DDL statement       X
sqlserver progress_report_online_index_operation Occurs during an online index build process to indicate the progress of the build operation. Each stage of an online index build operation generates an event. Use this event to monitor online index builds.     X X
sqlserver promote_tran_completed Occurs when a PROMOTE TRANSACTION request that was sent from a client application through the transaction management interface has completed.     X X
sqlserver promote_tran_starting Occurs when a PROMOTE TRANSACTION request that was sent from a client application through the transaction management interface has started.     X X
sqlserver qn_dynamics Occurs when background activity to support query notifications is performed. Use this event to track subscription time-outs, pending subscription notification messages, and parameter table destruction.     X X
sqlserver qn_parameter_table Occurs when an operation is performed that is related to the parameter tables that are used in query notifications. Use this event to monitor operations that are related to creating and maintaining reference counts, and dropping the internal tables that store parameter information. This event also tracks when the usage count is reset on a parameter table.     X X
sqlserver qn_subscription Occurs when an operation is performed that is related to query notification subscriptions. Use this event to monitor when subscriptions are created or removed, when a subscription produces a notification message, and when errors occur while producing a notification message or deleting a subscription.     X X
sqlserver qn_template Occurs when operations are performed related to the query templates used by the Database Engine to share information about a query used for notification. Use this event to monitor when a query template is created, used or destroyed     X X
sqlserver query_cache_removal_statistics Occurs when a query plan is removed from the plan cache and the historical statistics for the object are about to be destroyed.     X X
sqlserver query_execution_batch_hash_aggregation_finished Occurs at the end of batch hash aggregation.       X
sqlserver query_execution_batch_hash_children_reversed Occurs each time when hash join reverses build and probe side while processing data spilled to disk.       X
sqlserver query_execution_batch_hash_join_spilled Occurs each time when hash join spills some data to disk in batch processing.       X
sqlserver query_no_cqscan_cache_due_to_memory_limitation No CQSCAN cache due to memory limitation.     X X
sqlserver query_optimizer_estimate_cardinality Occurs when the query optimizer estimates cardinality on a relational expression.       X
sqlserver query_optimizer_force_both_cardinality_estimation_behaviors Both traceflags 2312 and 9481 were enabled, attempting to force both old and new cardinality estimation behaviors at the same time. The traceflags were ignored. Disable one or both of the traceflags.       X
sqlserver query_post_compilation_showplan Occurs after a SQL statement is compiled. This event returns an XML representation of the estimated query plan that is generated when the query is compiled. Using this event can have a significant performance overhead so it should only be used when troubleshooting or monitoring specific problems for brief periods of time.     X X
sqlserver query_post_execution_showplan Occurs after a SQL statement is executed. This event returns an XML representation of the actual query plan. Using this event can have a significant performance overhead so it should only be used when troubleshooting or monitoring specific problems for brief periods of time.     X X
sqlserver query_pre_execution_showplan Occurs after a SQL statement is compiled. This event returns an XML representation of the estimated query plan that is generated when the query is optimized. Using this event can have a significant performance overhead so it should only be used when troubleshooting or monitoring specific problems for brief periods of time.     X X
sqlserver query_rpc_close Closing RPC rowset.     X X
sqlserver query_rpc_create_accessor Creating RPC column accessor.     X X
sqlserver query_rpc_create_col_accessor Creating RPC column accessor.     X X
sqlserver query_rpc_delete_rows Deleting rows from RPC rowset.     X X
sqlserver query_rpc_end_update Ending update in RPC rowset.     X X
sqlserver query_rpc_fetch_next_row Fetching next row from RPC rowset.     X X
sqlserver query_rpc_fetch_row_by_key_value Fetching row by key value from RPC rowset.     X X
sqlserver query_rpc_get_data Getting data from RPC rowset.     X X
sqlserver query_rpc_go_dormant Setting RPC rowset to dormant state.     X X
sqlserver query_rpc_insert_index_row Inserting index row in RPC rowset.     X X
sqlserver query_rpc_insert_row Inserting row in RPC rowset.     X X
sqlserver query_rpc_locate_and_delete_row Locating and deleting row in RPC rowset.     X X
sqlserver query_rpc_locate_and_update_row Locating and updating row in RPC rowset.     X X
sqlserver query_rpc_locate_or_insert_row Locating or inserting row in RPC rowset.     X X
sqlserver query_rpc_prepare_cmd_delete_row Preparing DeleteRow RPC command.     X X
sqlserver query_rpc_prepare_cmd_fetch_data Preparing FetchData RPC command.     X X
sqlserver query_rpc_prepare_cmd_get_data Preparing GetData RPC command.     X X
sqlserver query_rpc_prepare_cmd_goto_marker Preparing GotoMarker RPC command.     X X
sqlserver query_rpc_prepare_cmd_insert_row Preparing InsertRow RPC command.     X X
sqlserver query_rpc_prepare_cmd_prepare_to_delete Preparing PrepareToDelete RPC command.     X X
sqlserver query_rpc_prepare_cmd_set_data Preparing SetData RPC command.     X X
sqlserver query_rpc_prepare_cmd_set_marker Preparing SetMarker RPC command.     X X
sqlserver query_rpc_prepare_cmd_set_range Preparing SetRange RPC command.     X X
sqlserver query_rpc_prepare_cmd_set_range_with_cached_keys Preparing SetRange RPC command with cached keys.     X X
sqlserver query_rpc_prepare_cmd_wake_up Preparing WakeUp RPC command.     X X
sqlserver query_rpc_prepare_to_delete Preparing to delete in RPC rowset.     X X
sqlserver query_rpc_process_cmd_delete_row Processing DeleteRow RPC command.     X X
sqlserver query_rpc_process_cmd_fetch_data Processing FetchData RPC command.     X X
sqlserver query_rpc_process_cmd_get_data Processing GetData RPC command.     X X
sqlserver query_rpc_process_cmd_goto_marker Processing GotoMarker RPC command.     X X
sqlserver query_rpc_process_cmd_insert_row Processing InsertRow RPC command.     X X
sqlserver query_rpc_process_cmd_lob_action Processing LobAction RPC command.     X X
sqlserver query_rpc_process_cmd_prepare_to_delete Processing PrepareToDelete RPC command.     X X
sqlserver query_rpc_process_cmd_set_data Processing SetData RPC command.     X X
sqlserver query_rpc_process_cmd_set_marker Processing SetMarker RPC command.     X X
sqlserver query_rpc_process_cmd_set_range Processing SetRange RPC command.     X X
sqlserver query_rpc_release_accessor Releasing RPC column accessor.     X X
sqlserver query_rpc_server_cache_flush Flushing RPC runtime collection cache.     X X
sqlserver query_rpc_server_collection_cache_hit RPC runtime collection cache hit, with cache key in request.     X X
sqlserver query_rpc_server_collection_cache_hit_no_key RPC runtime collection cache hit, using request type instead of cache key.     X X
sqlserver query_rpc_server_collection_cache_insert Inserting RPC runtime collection into cache.     X X
sqlserver query_rpc_server_collection_cache_miss RPC runtime collection cache miss.     X X
sqlserver query_rpc_server_collection_cache_remove Removing RPC runtime collection from cache.     X X
sqlserver query_rpc_server_collection_create Creating RPC runtime collection.     X X
sqlserver query_rpc_server_runtime_cache_hit RPC runtime cache hit.     X X
sqlserver query_rpc_server_runtime_cache_insert Inserting RPC runtime into cache.     X X
sqlserver query_rpc_server_runtime_cache_miss RPC runtime cache miss.     X X
sqlserver query_rpc_server_runtime_cache_remove Removing RPC runtime from cache.     X X
sqlserver query_rpc_server_runtime_create Creating RPC runtime.     X X
sqlserver query_rpc_server_runtime_init Initializing RPC runtime.     X X
sqlserver query_rpc_server_runtime_wake_up Waking up RPC runtime.     X X
sqlserver query_rpc_set_cardinality Setting cardinality in RPC rowset.     X X
sqlserver query_rpc_set_data Setting data in RPC rowset.     X X
sqlserver query_rpc_set_range Setting range for RPC rowset.     X X
sqlserver query_rpc_switch_partition Switching partition in RPC rowset.     X X
sqlserver query_rpc_wake_up Waking up RPC rowset.     X X
sqlserver query_store_failed_to_capture_query Fired if the Query Store failed to capture query. The Query Store will not track statistics for this query       X
sqlserver query_store_failed_to_load_forced_plan Fired if the query failed to load forced plan from QDS. Forcing policy will not be applied       X
sqlserver query_store_persist_on_shutdown_failed Occurs when SQL Server fails to store dirty entries in Query Store on database shutdown.       X
sqlserver read_only_route_complete A read-only routing operation successfully completed.     X X
sqlserver read_only_route_fail The read-only routing operation failed.  This is sent when the primary replica has a READ_ONLY_ROUTING_LIST configured and none of the replicas in the list are available for read-only routing.     X X
sqlserver recovery_catch_checkpoint Background writes queued to allow truncation dirty page point to get to last checkpoint     X X
sqlserver recovery_force_oldest_page Background writes forced to allow oldest dirty page to get to last checkpoint     X X
sqlserver recovery_incremental_checkpoint Chose to enqueue an incremental checkpoint as we are near our recovery target     X  
sqlserver recovery_indirect_checkpoint Chose to enqueue an indirect checkpoint as we are near our recovery target       X
sqlserver recovery_simple_log_truncate Background writes queued to allow truncation of simple recovery database     X X
sqlserver recovery_skip_checkpoint Chose not to enqueue a checkpoint as we are within the target     X X
sqlserver recovery_target_miss Found we were over target and queued background writes     X X
sqlserver recovery_target_reset Target for outstanding data pages has been changed     X X
sqlserver redo_caught_up Redo thread done with work     X X
sqlserver redo_single_record Redo on a log record     X X
sqlserver redo_stop_clear Redo stop point clear     X X
sqlserver redo_stop_set Redo stop point set     X X
sqlserver redo_target_set Target block to redo through set     X X
sqlserver redo_worker_entry Redo thread has entered to poll for redo work     X X
sqlserver redo_worker_exit Redo thread is leaving     X X
sqlserver remove_database_cache Remove database cache       X
sqlserver repl_event Occurs when sp_repl_generateevent is called. this event is an internal repl event for tracing repl stored procedures. The data that is returned from user_event includes the event_id that was specified in the call to sp_repl_generateevent. This can be a value between x and y.     X X
sqlserver rollback_tran_completed Occurs when a ROLLBACK TRANSACTION request that was sent from a client application through the transaction management interface has completed.     X X
sqlserver rollback_tran_starting Occurs when a ROLLBACK TRANSACTION request that was sent from a client application through the transaction management interface has started.     X X
sqlserver rpc_completed RPC completed X X    
sqlserver rpc_completed Occurs when a remote procedure call has completed.     X  
sqlserver rpc_completed Occurs when a remote procedure call has completed.       X
sqlserver rpc_starting RPC starting X X    
sqlserver rpc_starting Occurs when a remote procedure call has started.     X X
sqlserver save_tran_completed Occurs when a SAVE TRANSACTION request that was sent from a client application through the transaction management interface has completed.     X X
sqlserver save_tran_starting Occurs when a SAVE TRANSACTION request that was sent from a client application through the transaction management interface has started.     X X
sqlserver scan_started Occurs when a table or index scan starts.     X X
sqlserver scan_stopped Occurs when a table or index scan stops.     X X
sqlserver sec_ekm_provider_called External Key Management external API called X X X X
sqlserver security_authentication_perf_create_logintoken authentication performance statistics: create login token     X X
sqlserver security_authentication_perf_find_login authentication performance statistics: find login function     X X
sqlserver security_authentication_perf_login authentication performance statistics: login function     X X
sqlserver security_cache_database_cleanup All entries in Security Cache are removed.     X X
sqlserver security_cache_database_object_insert Security Cache Object Permissions Cache has inserted an object.     X X
sqlserver security_cache_database_object_removal Security Cache Object Permissions Cache has removed an object.     X X
sqlserver security_cache_database_timestamp_increment Security Token Permission Caches have been invalidated by incrementing timestamp for the database.     X X
sqlserver security_error_ring_buffer_recorded Security error ring buffer recorded     X X
sqlserver selective_xml_index_no_compatible_sql_type Occurs when a value() method is used in a query, specifying a sql type that differs from the type specified during selective XML index creation for that path.       X
sqlserver selective_xml_index_no_compatible_xsd_types Occurs when the user specifies a different resulting XSD type in a query, than the one that was used to promote the path during selective XML index creation.       X
sqlserver selective_xml_index_path_not_indexed Occurs when the path given in the user query is not promoted in the selective XML index, and thus the index is not used.       X
sqlserver selective_xml_index_path_not_supported Occurs when selective XML index is not used for a XML query due to the user using an unsupported path type.       X
sqlserver server_max_workers Occurs when a request enqueue fails because a worker was not guaranteed.       X
sqlserver server_memory_change Occurs when the server memory usage increases or decreases by more than either 1 megabyte (MB) or 5% of the maximum server memory, whichever is larger. Use this event to identify periods of increased memory usage on the server.     X X
sqlserver server_start_stop Occurs when the Server has been started or stopped     X X
sqlserver session_mgr_work_item_dequeued Session Manager: A work item has been dequeued from the thread pool for execution.     X X
sqlserver session_mgr_work_item_end_execution Session Manager: Finished the execution of work item.     X X
sqlserver session_mgr_work_item_enqueued Session Manager: A work item has been enqueued in the thread pool for execution.     X X
sqlserver session_mgr_work_item_start_execution Session Manager: Starting the execution of work item.     X X
sqlserver session_recoverable_state_change Occurs when the server determines a state change in term of session recovery on a connectionresilency-enabled connection.       X
sqlserver sort_add_run_tracing Sort adding merge runs to the merge run directory X X X X
sqlserver sort_memory_grant_adjustment Sort adjusting the memory grant of an in-progress sort X X X X
sqlserver sort_state_change_tracing Sort internal events and state changes X X X X
sqlserver sort_statistics_tracing Various statistics about the sort X X X X
sqlserver sort_warning Occurs when the sort operation on an executing query does not fit into memory. This event is not generated for sort operations caused by index creation, only for sort operations in a query. (For example, an Order By in a Select statement.) Use this event to identify queries that perform slowly because of the sort operation, particularly when the warning_type = 2, indicating multiple passes over the data were required to sort     X X
sqlserver sp_cache_hit Occurs when a stored procedure is retrieve from the procedure cache. Use this event along with other sp_cache_* events to troubleshoot issues caused by the procedure cache.     X X
sqlserver sp_cache_insert Occurs when a stored procedure is inserted into the procedure cache. Use this event together with other sp_cache_* events to troubleshoot issues that are caused by the procedure cache.     X X
sqlserver sp_cache_miss Occurs when a stored procedure is not found in the procedure cache. Frequent occurrences of this event could indicate that SQL Server needs more memory.  Use this event along with other sp_cache_* events to troubleshoot issues caused by the procedure cache.     X X
sqlserver sp_cache_remove Occurs when a stored procedure is removed from the procedure cache. Use this event together with other sp_cache_* events to troubleshoot issues that are caused by the procedure cache.     X X
sqlserver sp_server_diagnostics_component_result Occurs when a component state is determined.     X X
sqlserver sp_server_diagnostics_result_set Occurs when a new result set is being processed.     X X
sqlserver sp_statement_completed Occurs when a statement inside a stored procedure has completed. X X X X
sqlserver sp_statement_starting Occurs when a statement inside a stored procedure has started. X X X X
sqlserver spatial_guess Occurs when the optimizer cannot get enough join selectivity information.  Use this event to look at the queries where spatial index could be used and the optimizer guesses the spatial selectivity.       X
sqlserver sql_batch_completed Occurs when a Transact-SQL batch has finished executing.     X X
sqlserver sql_batch_starting Occurs when a Transact-SQL batch has started executing.     X X
sqlserver sql_exit_invoked Occurs when SQLExit() routine is invoked     X X
sqlserver sql_statement_completed Occurs when a Transact-SQL statement has completed. X X X X
sqlserver sql_statement_recompile Occurs when a statement-level recompilation is required by any kind of batch. This includes stored procedures, triggers, ad hoc batches and queries. Batches may be submitted through several interfaces, including sp_executesql, dynamic SQL, Prepare methods or Execute methods.     X X
sqlserver sql_statement_starting Occurs when a Transact-SQL statement has started. X X X X
sqlserver sql_transaction Occurs when a SQL Server transaction begins, completes, rolls back or executes a savepoint. Use this event to monitor transaction behavior when troubleshooting applications, triggers or stored procedures.     X X
sqlserver sql_transaction_commit_single_phase Occurs when a sql transaction is committed with single phase commit.       X
sqlserver stack_trace Occurs when a memory dump of the process is requested.     X X
sqlserver syscommittab_cleanup Tracks SYS.SYSCOMMITTAB Table Cleanup     X X
sqlserver trace_flag_changed Trace flag changed X X X X
sqlserver trace_print Trace message published X X X X
sqlserver transaction_log Occurs when a record is added to the SQL Server transaction log. This is a very high volume event that will affect the performance of the server. Therefore, you should use appropriate filtering to reduce the number of events, and only use this event for targeted troubleshooting during a short time period.     X X
sqlserver ual_instrument_called Occurs when a successful connection to the Server is reported to Windows using the User Access Logging API. This event is only fired for new connections. Connection resets are not tracked.     X X
sqlserver uncached_sql_batch_statistics Occurs when a Transact-SQL batch is executed that was created for a specific situation and was not in the query cache.     X X
sqlserver unmatched_filtered_indexes Occurs when the optimizer cannot use a filtered index due to parameterization.  For each such index an event is fired.  The unmatched_database_name, unmatched_schema_name, unmatched_table_name, unmatched_index_name fields give details of the filtered index that could not be used.       X
sqlserver unprepare_sql Occurs when a prepared Transact-SQL statement was unprepared (deleted) by SQLClient, ODBC, OLE DB or DB-Library.     X X
sqlserver user_event Occurs when sp_trace_generateevent is called. Use this event to monitor user-defined events in your application code during testing or execution. The data that is returned from user_event includes the event_id that was specified in the call to sp_trace_generateevent. This can be a value between 82 and 91.     X X
sqlserver user_settable User settable X X X X
sqlserver window_spool_ondisk_warning Occurs when a Window Spool operator uses on-disk work table.     X X
sqlserver xfcb_blob_properties_obtained Windows Azure Storage blob property is obtained from response header.       X
sqlserver xfcb_failed_request Failed to complete a request to Windows Azure Storage.       X
sqlserver xfcb_header_obtained Response header is obtained from request to Windows Azure Storage.       X
sqlserver xfcb_read_complete Read complete from Windows Azure Storage response.       X
sqlserver xfcb_request_opened A request is opened to Windows Azure Storage.       X
sqlserver xfcb_send_complete Request send to Windows Azure Storage is complete.       X
sqlserver xfcb_write_complete Request send to Windows Azure Storage is complete.       X
sqlserver xml_deadlock_report Produces a deadlock report in XML format. X X X X
sqlserver xquery_static_type Occurs when an XQuery expression is compiled.     X X
sqlserver xtp_create_procedure Occurs at start of XTP procedure creation.       X
sqlserver xtp_create_table Occurs at start of XTP table creation.       X
sqlserver xtp_db_page_allocation_allowed Indicates that page allocations for the database are allowed.       X
sqlserver xtp_db_page_allocation_disallowed Indicates that page allocations for the database are disallowed due to memory pressure.       X
sqlserver xtp_deploy_done Occurs at completion of XTP object deployment.       X
sqlserver xtp_matgen Occurs at start of MAT generation.       X
sqlserver xtp_offline_checkpoint_scan_start Fired by XTP offline checkpoint when the checkpoint thread begins.       X
sqlserver xtp_offline_checkpoint_scan_stop Fired by XTP offline checkpoint when the checkpoint thread stops.       X
sqlserver xtp_recover_done Occurs at completion of log recovery of XTP table.       X
sqlserver xtp_recover_table Occurs at start of log recovery of XTP table.       X
sqlserver xtp_storage_table_create Occurs at just before the XTP storage table is created.       X
ucs ucs_change_notification UCS receives endpoint or other metadata change notifications     X X
ucs ucs_connection_corrupt_message UCS transport connection received corrupt message     X X
ucs ucs_connection_flow_control UCS transport connection send or receive flow controlled     X X
ucs ucs_connection_recv_io UCS transport connection receive input/output operation     X X
ucs ucs_connection_recv_msg UCS transport connection received message handled     X X
ucs ucs_connection_rejected_by_proxy_whitelist After a connection attempt to the UCS proxy endpoint is rejected by whitelist check       X
ucs ucs_connection_send_io UCS transport connection send input/output operation     X X
ucs ucs_connection_send_msg UCS transport connection sent message handled     X X
ucs ucs_connection_setup UCS transport connection setup     X X
ucs ucs_connection_state_machine UCS transport connection state machine event     X X
ucs ucs_proxy_connect_next_hop UCS proxy next hop connection       X
ucs ucs_proxy_receive_proxy_connect_message UCS proxy receive proxy connect message       X
ucs ucs_proxy_route_add UCS proxy route added       X
ucs ucs_proxy_route_disable UCS proxy route disabled       X
ucs ucs_proxy_route_refresh UCS proxy route refreshed       X
ucs ucs_proxy_send_proxy_connect_message UCS proxy send proxy connect message       X
ucs ucs_task_idempotent UCS idempotent task submitted, began or ended execution     X X
ucs ucs_task_periodic_work UCS task manager periodic work     X X
ucs ucs_transmitter_destination_connect UCS transmitter destination submitted a connection request to the transport     X X
ucs ucs_transmitter_destination_event UCS transmitter destination state machine event handler     X X
ucs ucs_transmitter_destination_process UCS transmitter processes destination to send messages     X X
ucs ucs_transmitter_destination_service UCS transmitter destination subscribed, unsubscribed or processed a service     X X
ucs ucs_transmitter_periodic_work UCS transmitter periodic work     X X
ucs ucs_transmitter_reclassify UCS transmitter reclassification process     X X
ucs ucs_transmitter_service_reclassify UCS transmitter reclassifies a service     X X
ucs ucs_transmitter_service_session UCS transmitter service registered, unregistered or processed a session     X X
ucs ucs_transmitter_stream_update UCS transmitter stream update from the transport     X X
ucs ucs_transport_periodic_work UCS transport periodic work     X X
XtpCompile cgen Occurs at start of C code generation.       X
XtpCompile invoke_cl Occurs prior to the invocation of the C compiler.       X
XtpCompile mat_export Occurs at start of MAT export.       X
XtpCompile pitgen_procs Occurs at start of PIT generation for procedures.       X
XtpCompile pitgen_tables Occurs at start of PIT generation for tables.       X
XtpEngine after_changestatetx_event Fires after transaction changes state.       X
XtpEngine alloctx_event         X
XtpEngine attempt_committx_event Is raised when a transaction is asked to commit.       X
XtpEngine before_changestatetx_event Fires before transaction changes state.       X
XtpEngine dependency_acquiredtx_event Raised after transaction takes a dependency on another transaction.       X
XtpEngine endts_acquiredtx_event Fires after transaction acquires an end timestamp.       X
XtpEngine gc_base_generation_evaluation Indicates that an evaluation of updating the GC base generation has been made.       X
XtpEngine gc_base_generation_updated Indicates that the oldest active transaction hint used for calculating the GC base generation has been updated.       X
XtpEngine gc_cycle_completed Indicates that a GC notification has been enqueued.       X
XtpEngine gc_notification Indicates that GC is processing a notification.       X
XtpEngine redo_single_hk_record Redo on a HK log record       X
XtpEngine trace_add_delta_filter_begin Adding delta filter.       X
XtpEngine trace_add_duplicate_delta_filter Adding duplicate delta filte.       X
XtpEngine trace_adding_tx_filter Adding tx filter.       X
XtpEngine trace_begin_close_ckpt_processing Beginning close checkpoint processing: checkpoint flush fence = $2 ($3 state).       X
XtpEngine trace_cfd_entry_deleted Cleaned up data CFD entry for file $2 $3.       X
XtpEngine trace_cfd_rows_created Successfully created CFD rows.       X
XtpEngine trace_cfdtable_dump CfdTable dump       X
XtpEngine trace_cfp_handles_opened Opened CFP handles for {data: $2 delta: $3} in section $4.       X
XtpEngine trace_cfp_removed_from_freelist Removed CFP from freelist for destination file.       X
XtpEngine trace_checkpoint_file_flush Indicating that a file has started a flush operation.       X
XtpEngine trace_checkpoint_load_begin Starting Checkpoint load with checkpoint timestamp=$2.       X
XtpEngine trace_checkpoint_write_io Logs an event indicating that an IO has started (when event_type == IoStarted) or that an IO has completed (when event_type == IoComplete).       X
XtpEngine trace_checksum_validation_succeeded Checksum validation for Hekaton checkpoint file during backup succeeded.       X
XtpEngine trace_ckpt_close_begin Closing checkpoint in active/passive state.       X
XtpEngine trace_ckpt_close_signaled Signaling checkpoint close. The checkpoint policy object is flagged to close the current checkpoint       X
XtpEngine trace_ckpt_closed Checkpoint closed       X
XtpEngine trace_ckpt_load_thread_stats Statistics of the checkpoint load thread.       X
XtpEngine trace_ckpt_mrt_dump Mrt dump       X
XtpEngine trace_ckpt_serialization_state_dump Checkpoint serialization state dump.       X
XtpEngine trace_ckpt_stream_io_stats Io statistics for this particular stream.       X
XtpEngine trace_close_file_log_rec_created Successfully created close file log record.       X
XtpEngine trace_data_file_pages_txs This event gives the number of pages and the transaction range for a data file.       X
XtpEngine trace_data_from_page_deserialized Deserialized data from page $2 in file $4.       X
XtpEngine trace_data_row_modified Data row modified/deleted.       X
XtpEngine trace_delete_cfd_rows_begin Matching MRT not found for the Data CFD. Deleting corresponding CFD Rows.       X
XtpEngine trace_delete_DeletedObjectTable_row_begin Deleting row from DeletedObjectTable in the context of transaction: $5.       X
XtpEngine trace_delete_merged_source_file Deleting merged source $7 file $5:$6. DeleteLSN = $2:$3:$4.       X
XtpEngine trace_delete_mrtrow_for_target_begin Deleting mrt row for target.       X
XtpEngine trace_delta_entry_skipped Skipping delta {$3, $4, $5} because it is beyond the snapshot checkpoint: $6.       X
XtpEngine trace_delta_file_future_count_rows_pages_update Updating future count pages and count rows for delta file.       X
XtpEngine trace_delta_file_lastgood_count_rows_pages_update Updating lastgood count pages and count rows for delta file.       X
XtpEngine trace_delta_file_pages_txs This event gives the number of pages and the transaction range while reading a delta file for a particular operations.       X
XtpEngine trace_delta_file_processed Completed processing of Delta file.       X
XtpEngine trace_delta_file_set_clean_or_dirty Delta file set clean or dirty.       X
XtpEngine trace_delta_filter_removed Removing delta filter from DeltaFilterMap due to transaction filter.       X
XtpEngine trace_delta_watermark_removed Removed delta watermark.       X
XtpEngine trace_delta_watermark_updated Updated delta watermark row for FileId: $4.       X
XtpEngine trace_deserialize_chained_records Info pertaining to the deserialized content of the mrtRecords chain.       X
XtpEngine trace_deserialize_data_from_page_begin Deserializing data from page $2 in file $4.       X
XtpEngine trace_deserialize_source_delta_file_begin Deserializing source delta file $4: page range [$2, $3).       X
XtpEngine trace_dump_cfd_row Dump cfd row       X
XtpEngine trace_dump_mrt_row Merge Request       X
XtpEngine trace_file_close_skipped Skipping file close for $2 as the cfp had been merged, It could not be found in the Storage array.       X
XtpEngine trace_file_skipped Skipping file $4 due to reason $5.       X
XtpEngine trace_file_skipped_with_tx_range Skipping file $5 with TX range { $3 -> $4 } due to MaxTxId == InvalidTxId.       X
XtpEngine trace_first_page_header_flushed Flushed first page header for file.       X
XtpEngine trace_flush_io_operation_for_delta_file This trace is trying to catch pages issued for flush that didn't make it to the file, or were lacking the correct DeltaWatermark Timestamp.       X
XtpEngine trace_flush_skipped_for_closed_data_file Skipping flush for data file ('$2') as it is closed.       X
XtpEngine trace_future_count_pages_update Updating future count pages.       X
XtpEngine trace_initial_merge Doing initial merge for destination $3 at CheckpointTs: $2.       X
XtpEngine trace_insert_DeletedObjectTable_row_begin Inserting row to DeletedObjectTable in the context of transaction: $5.       X
XtpEngine trace_intialize_worker_file_begin Processing file close.       X
XtpEngine trace_mark_data_file_closed Marking the active data file as closed to prevent the offline worker fom flushing them.       X
XtpEngine trace_merge_cancelled Merge was cancelled for destination $2.       X
XtpEngine trace_merge_complete_log_rec_ignored MergeCompleteLogRecord ignored for destination file $3.       X
XtpEngine trace_merge_complete_log_rec_processed Successfully processed MergeCompleteLogRecord.       X
XtpEngine trace_mrt_dump Mrt dump.       X
XtpEngine trace_mrt_row_inplace_update Mrt row updated in place.       X
XtpEngine trace_mrtrow_not_found Could not find row with Destination ID: $2 in MRT table.       X
XtpEngine trace_new_delta_watermark_inserted Inserted new delta watermark row for FileId $3.       X
XtpEngine trace_offline_process_stale_merge_item Offline processing of stale merge item {$2, $3} Destination $4.       X
XtpEngine trace_pending_tx Pending Transaction       X
XtpEngine trace_populate_storage_array Populating the storage array.       X
XtpEngine trace_post_writefile This event is fired after issuing IO on the proxy.       X
XtpEngine trace_process_file_close_begin Processing file close.       X
XtpEngine trace_process_merge_complete_log_record Process merge complete log record.       X
XtpEngine trace_process_merge_request Process Merge Request       X
XtpEngine trace_process_source_file Processing source $4 file $2.       X
XtpEngine trace_process_target_file Processing target $4 file $2.       X
XtpEngine trace_queue_merge_work_item Queue work item: {$2, $3} $5 - $6 with CheckpointTs as $4.       X
XtpEngine trace_recovered_existing_file Recovered exising files files allocated during forward processing that are not already part of the CCB.       X
XtpEngine trace_resyncing_state_of_file Resyncing state of file $4 ('$5') post recovery:  $2 pages, $3 rows.       X
XtpEngine trace_serialization_object_cleaned Cleaned serialization object.       X
XtpEngine trace_serialize_abort_transaction_begin Serializing the abort transaction filter to the delta cache corresponding to its own transaction range.       X
XtpEngine trace_serialize_tx_begin Serialize TS begin for completing the checkpoint in active state.       X
XtpEngine trace_serialize_tx_end Serialize TS end for completing the checkpoint.       X
XtpEngine trace_serialized_delta_rows_to_file Serialized delta rows to file.       X
XtpEngine trace_source_file_load_stats Load stats for source files in merge.       X
XtpEngine trace_storage_refreshed_for_file Storage refreshed for file.       X
XtpEngine trace_uninitialize_file uninitializing_file       X
XtpEngine trace_wrote_delta_watermark Wrote delta watermark for file: $3, checkpointTs: $2.       X
XtpEngine waiting_for_dependenciestx_event Raised when we have explicitly waited for dependencies to clear.       X
XtpEngine xtp_before_create_log_record Fired before submitting a request to the host to serialize a non-transactional log record.       X
XtpEngine xtp_checkpoint_file_flush Indicates the point at which a given file has been flushed to disk.       X
XtpEngine xtp_checkpoint_file_flush_complete Indicates the point at which all in-flight buffers have been flushed to disk.       X
XtpEngine xtp_checkpoint_file_read Indicates reading of a file in XTP checkpoint recovery.       X
XtpEngine xtp_checkpoint_worker_active_log Indicates that the checkpoint worker has started processing the log records in the active portion of the log.       X
XtpEngine xtp_checkpoint_worker_started Indicates that the checkpoint worker has started processing the log records.       X
XtpEngine xtp_checkpoint_worker_stopped Indicates that the checkpoint worker has started processing the log records.       X
XtpEngine xtp_checkpoint_write_io Indicates that the checkpointing subsystem has issued or completed a write IO.       X
XtpEngine xtp_complete_checkpoint Indicates the begin and end of complete checkpoint processing.       X
XtpEngine xtp_create_log_record Fires when the XTP engine creates a log record.       X
XtpEngine xtp_delta_marked_dirty Indicates that a delete/update was serialized and marked a delta file dirty       X
XtpEngine xtp_merge_complete_log_record Indicates merge complete log record is posted to the log.       X
XtpEngine xtp_merge_log_complete_log_record Indicates merge log record was interpreted by the offline worker.       X
XtpEngine xtp_merge_process_log_record Indicates merge log record was interpreted by the offline worker.       X
XtpEngine xtp_merge_request_log_record Indicates merge request log record is posted to the log.       X
XtpEngine xtp_merge_request_started Indicates merge request has been picked up by the merge worker thread.       X
XtpEngine xtp_root_deserialized Indicates that the load of a checkpoint root is complete.       X
XtpEngine xtp_root_serialized Indicates that the write of the checkpoint root is complete.       X
XtpRuntime bind_md Occurs prior to binding metadata for a memory optimized table.       X
XtpRuntime bind_tables Occurs prior to binding tables for a natively compiled procedure.       X
XtpRuntime create_table Occurs prior to creating memory optimized table.       X
XtpRuntime deserialize_md Occurs prior to deserializing metadata.       X
XtpRuntime load_dll Occurs prior to loading the generated DLL.       X
XtpRuntime recover_done Occurs at completion of checkpoint recovery of a memory optimized table.       X
XtpRuntime recover_table Occurs at start of checkpoint recovery of a memory optimized table.       X
XtpRuntime serialize_md Occurs prior to serializing metadata.       X
XtpRuntime unload_dll Occurs prior to unloading the generated DLL.       X