As we begin to get a grasp of all that is available with SQL Server 2016 and all of the new features, it is a great idea to see what else has been made available to us in order to help support and troubleshoot these new features. With that, it is well worth a look at the new changes to Extended Events to support all the shiny new stuff.
Here is a list of what I could find as of CTP 2 (I have yet to look at CTP 2.1). This list alone has some really cool stuff in it. Browse through it and you will be able to find new stuff to help support and administer things like Stretch Database as well as JSON. You won’t find these events within Trace or profiler – only XE.
The presence of these new events (even some new ones for Query Store) is quite enough to get me excited for that next release of SQL Server. There is some great stuff coming down the pipe.
I have randomly highlighted some of the new events to support some of these new features. (And since this is only CTP 2.0, one can be sure there will be changes made to this list with the actual release of SQL Server 2016.)
| SQLVersion | EventName | PackageName | EventDescription |
| Microsoft SQL Server 2016 (CTP2.0) | availability_replica_database_fault_reporting | sqlserver | Occurs when a database reports a fault to the availability replica manager which will trigger a replica restart if the database is critical |
| Microsoft SQL Server 2016 (CTP2.0) | backup_restore_progress_trace | sqlserver | Prints backup/restore progress trace messages with details |
| Microsoft SQL Server 2016 (CTP2.0) | batchmode_sort_spill_file | sqlserver | Record the spill file read/write information for batch mode sort |
| Microsoft SQL Server 2016 (CTP2.0) | batchmode_sort_status | sqlserver | Record batch mode sort status |
| Microsoft SQL Server 2016 (CTP2.0) | cl_duration | XtpCompile | Reports the duration of the C compilation. |
| Microsoft SQL Server 2016 (CTP2.0) | clr_context_dump | sqlclr | ClrContextDump triggered. |
| Microsoft SQL Server 2016 (CTP2.0) | column_store_expression_filter_apply | sqlserver | An expression bitmap filter was applied on a rowgroup column batch. |
| Microsoft SQL Server 2016 (CTP2.0) | column_store_expression_filter_bitmap_set | sqlserver | An expression bitmap filter was set on a rowgroup column at rowgroup compile time. |
| Microsoft SQL Server 2016 (CTP2.0) | columnstore_delete_buffer_closed_rowgroup_with_generationid_found | sqlserver | Delete buffer can not be flushed due to existence of one or more closed rowgroups with generation ID. |
| Microsoft SQL Server 2016 (CTP2.0) | columnstore_delete_buffer_flush_failed | sqlserver | Columnstore delete buffer flush failed. |
| Microsoft SQL Server 2016 (CTP2.0) | columnstore_delete_buffer_state_transition | sqlserver | Occurs when closed delete buffer state changes. |
| Microsoft SQL Server 2016 (CTP2.0) | columnstore_delta_rowgroup_closed | sqlserver | A delta rowgroup was closed. |
| Microsoft SQL Server 2016 (CTP2.0) | columnstore_no_rowgroup_qualified_for_merge | sqlserver | A user invoked a REORG command but based on the policy, no rowgroup qualified. |
| Microsoft SQL Server 2016 (CTP2.0) | columnstore_rowgroup_compressed | sqlserver | A compressed rowgroup was created. |
| Microsoft SQL Server 2016 (CTP2.0) | columnstore_rowgroup_merge_complete | sqlserver | A MERGE operation completed merging columnstore rowgroups together. |
| Microsoft SQL Server 2016 (CTP2.0) | columnstore_rowgroup_merge_start | sqlserver | A MERGE operation started merging columnstore rowgroups together. |
| Microsoft SQL Server 2016 (CTP2.0) | columnstore_tuple_mover_begin_delete_buffer_flush | sqlserver | Columnstore tuple mover started flushing a delete buffer. |
| Microsoft SQL Server 2016 (CTP2.0) | columnstore_tuple_mover_compression_stats | sqlserver | Statistics about the movement of a deltastore to a compressed rowgroup, including duration, size, etc. |
| Microsoft SQL Server 2016 (CTP2.0) | columnstore_tuple_mover_delete_buffer_flush_requirements_not_met | sqlserver | Occurs when column store tuple mover was not able to acquire required locks for flushing a delete buffer. |
| Microsoft SQL Server 2016 (CTP2.0) | columnstore_tuple_mover_delete_buffer_truncate_requirements_not_met | sqlserver | Occurs when column store tuple mover was not able to acquire required locks for truncating a delete buffer. |
| Microsoft SQL Server 2016 (CTP2.0) | columnstore_tuple_mover_delete_buffer_truncated | sqlserver | Columnstore tuple mover truncated delete buffer. |
| Microsoft SQL Server 2016 (CTP2.0) | columnstore_tuple_mover_delete_buffers_swapped | sqlserver | Columnstore tuple mover swapped delete buffers. |
| Microsoft SQL Server 2016 (CTP2.0) | columnstore_tuple_mover_end_delete_buffer_flush | sqlserver | Columnstore tuple mover completed flushing a delete buffer. |
| Microsoft SQL Server 2016 (CTP2.0) | columnstore_tuple_mover_met_requirements_for_delete_buffer_flush | sqlserver | Occurs when column store tuple mover has acquired required locks and is ready to start flushing a delete buffer. |
| Microsoft SQL Server 2016 (CTP2.0) | columnstore_tuple_mover_met_requirements_for_delete_buffer_truncate | sqlserver | Occurs when column store tuple mover has acquired required locks and is ready to start truncating a delete buffer. |
| Microsoft SQL Server 2016 (CTP2.0) | columnstore_x_dbfl_acquired | sqlserver | Occurs when X Delete Buffer Flush Lock is acquired. |
| Microsoft SQL Server 2016 (CTP2.0) | compressed_alter_column_is_md_only | sqlserver | Occurs during an alter column operation. Indicates whether the alter column is metadata only or not. |
| Microsoft SQL Server 2016 (CTP2.0) | connection_accept | sqlserver | Occurs when a new connection is accepted by (or duplicated into) the server. This event serves to log all connection attempts. |
| Microsoft SQL Server 2016 (CTP2.0) | connection_duplication_failure | sqlserver | Occurs when connection duplication fails |
| Microsoft SQL Server 2016 (CTP2.0) | data_purity_checks_for_dbcompat_130 | sqlserver | Occurs when an operation that may require a data purity check for dbcompat level 130 occurs. |
| Microsoft SQL Server 2016 (CTP2.0) | database_recovery_times | sqlserver | Database recovery times |
| Microsoft SQL Server 2016 (CTP2.0) | database_tde_encryption_scan_duration | sqlserver | Database TDE Encryption Scan |
| Microsoft SQL Server 2016 (CTP2.0) | database_transaction_yield | sqlserver | Occurs when a database transaction yields execution due to TDS buffer being full. |
| Microsoft SQL Server 2016 (CTP2.0) | ex_raise2 | sqlos | Raised exception |
| Microsoft SQL Server 2016 (CTP2.0) | fulltextlog_written | sqlserver | Errorlog written |
| Microsoft SQL Server 2016 (CTP2.0) | global_transaction | sqlserver | Occurs when global transaction is started. |
| Microsoft SQL Server 2016 (CTP2.0) | hadr_db_log_throttle | sqlserver | Occurs when DB log generation throttle changes. |
| Microsoft SQL Server 2016 (CTP2.0) | hadr_db_log_throttle_configuration_parameters | sqlserver | Occurs when DB log generation throttle configuration parameters are read. |
| Microsoft SQL Server 2016 (CTP2.0) | hadr_db_log_throttle_input | sqlserver | Occurs when HADR Fabric log management component updates log throttle. |
| Microsoft SQL Server 2016 (CTP2.0) | hadr_db_marked_for_reseed | sqlserver | Occurs when a HADR secondary DB falls too far behind primary and is marked for reseed. |
| Microsoft SQL Server 2016 (CTP2.0) | hadr_db_remote_harden_failure | sqlserver | A harden request as part of a commit or prepare failed due to remote failure. |
| Microsoft SQL Server 2016 (CTP2.0) | hadr_log_block_send_complete | sqlserver | Occurs after a log block message has been sent. This event is only used for failpoints. |
| Microsoft SQL Server 2016 (CTP2.0) | hadr_partner_log_send_transition | sqlserver | Log send transition between log writer and log capture. |
| Microsoft SQL Server 2016 (CTP2.0) | hadr_partner_restart_scan | sqlserver | Restart partner scans for this partner. |
| Microsoft SQL Server 2016 (CTP2.0) | hadr_physical_seeding_backup_state_change | sqlserver | Physical Seeding Backup Side State Change. |
| Microsoft SQL Server 2016 (CTP2.0) | hadr_physical_seeding_failure | sqlserver | Physical Seeding Failure Event. |
| Microsoft SQL Server 2016 (CTP2.0) | hadr_physical_seeding_forwarder_state_change | sqlserver | Physical Seeding Forwarder Side State Change. |
| Microsoft SQL Server 2016 (CTP2.0) | hadr_physical_seeding_forwarder_target_state_change | sqlserver | Physical Seeding Forwarder Target Side State Change. |
| Microsoft SQL Server 2016 (CTP2.0) | hadr_physical_seeding_progress | sqlserver | Physical Seeding Progress Event. |
| Microsoft SQL Server 2016 (CTP2.0) | hadr_physical_seeding_restore_state_change | sqlserver | Physical Seeding Restore Side State Change. |
| Microsoft SQL Server 2016 (CTP2.0) | hadr_physical_seeding_submit_callback | sqlserver | Physical Seeding Submit Callback Event. |
| Microsoft SQL Server 2016 (CTP2.0) | hadr_send_harden_lsn_message | sqlserver | Occurs when we’re crafting a message to send containing a new hardened LSN on a secondary. Test only. |
| Microsoft SQL Server 2016 (CTP2.0) | hadr_transport_configuration_state | sqlserver | Indicates session state changes |
| Microsoft SQL Server 2016 (CTP2.0) | hadr_transport_dump_dropped_message | sqlserver | Use this event to trace dropped HADR transport messages throughout the system. |
| Microsoft SQL Server 2016 (CTP2.0) | hadr_transport_dump_failure_message | sqlserver | Use this event to help trace HADR failure messages. |
| Microsoft SQL Server 2016 (CTP2.0) | hadr_transport_dump_preconfig_message | sqlserver | Use this event to help trace HADR preconfig messages. |
| Microsoft SQL Server 2016 (CTP2.0) | hadr_transport_sync_send_failure | sqlserver | Synchronous send failure in hadr transport. |
| Microsoft SQL Server 2016 (CTP2.0) | hadr_transport_ucs_registration | sqlserver | Reports UCS registration state changes |
| Microsoft SQL Server 2016 (CTP2.0) | json_depth_error | sqlserver | Occurs when depth of json text being parsed is bigger than 128. |
| Microsoft SQL Server 2016 (CTP2.0) | json_parsing_error | sqlserver | Indicates json parser error. Occurs when json format is not valid. |
| Microsoft SQL Server 2016 (CTP2.0) | json_stackoverflow_error | sqlserver | Json parser stack overflow. |
| Microsoft SQL Server 2016 (CTP2.0) | json_unescaped_character | sqlserver | Jsonparser hitted unescaped character in json string. |
| Microsoft SQL Server 2016 (CTP2.0) | log_pool_cache_miss | sqlserver | Occurs when a log consumer attempts to lookup a block from the log pool but fails to find it. |
| Microsoft SQL Server 2016 (CTP2.0) | log_pool_push_no_free_buffer | sqlserver | Occurs when log pool push fails to get a free buffer and bails out. |
| Microsoft SQL Server 2016 (CTP2.0) | login_event | sqlserver | This is an abbreviated version of process_login_finish, containing only the columns required by external monitoring telemetry pipeline. |
| Microsoft SQL Server 2016 (CTP2.0) | notify_on_clr_disabled | sqlclr | Event_ClrDisabled has been triggered in ClrHost. |
| Microsoft SQL Server 2016 (CTP2.0) | on_app_domain_failure | sqlclr | AppDomain hit a failure. |
| Microsoft SQL Server 2016 (CTP2.0) | on_app_domain_unloading | sqlclr | AppDomain is unloading. |
| Microsoft SQL Server 2016 (CTP2.0) | on_host_policy_callback | sqlclr | IHostPolicyManager received an event. |
| Microsoft SQL Server 2016 (CTP2.0) | on_host_policy_failure | sqlclr | IHostPolicyManager received an event. |
| Microsoft SQL Server 2016 (CTP2.0) | page_cache_trace | sqlserver | Modification of the page cache. |
| Microsoft SQL Server 2016 (CTP2.0) | premature_systemthread_wakeup | sqlos | system thread is woken up prematurely |
| Microsoft SQL Server 2016 (CTP2.0) | private_login_accept | sqlserver | TDS connection accept event that is logged to private MDS table. |
| Microsoft SQL Server 2016 (CTP2.0) | private_login_finish | sqlserver | TDS login finish event that is logged to private MDS table. |
| Microsoft SQL Server 2016 (CTP2.0) | process_login_finish | sqlserver | This event is generated when server is done processing a login (success or failure). |
| Microsoft SQL Server 2016 (CTP2.0) | query_execution_batch_filter | sqlserver | Occurs when batch processing filters one batch using expression services. |
| Microsoft SQL Server 2016 (CTP2.0) | query_execution_batch_spill_started | sqlserver | Occurs when batch operator runs out of granted memory and initiates spilling to disk of another partition of in-memory data. |
| Microsoft SQL Server 2016 (CTP2.0) | query_execution_column_store_rowgroup_scan_finished | sqlserver | Occurs when row bucket processor finishes column store row group scan. |
| Microsoft SQL Server 2016 (CTP2.0) | query_execution_column_store_segment_scan_finished | sqlserver | Occurs when row bucket processor finishes column store segment scan. |
| Microsoft SQL Server 2016 (CTP2.0) | query_execution_column_store_segment_scan_started | sqlserver | Occurs when column segment scan starts. |
| Microsoft SQL Server 2016 (CTP2.0) | query_memory_grant_blocking | sqlserver | Occurs when a query is blocking other queries while waiting for memory grant |
| Microsoft SQL Server 2016 (CTP2.0) | query_memory_grant_usage | sqlserver | Occurs at the end of query processing for queries with memory grant over 5MB to let users know about memory grant inaccuracies |
| Microsoft SQL Server 2016 (CTP2.0) | query_store_background_task_persist_finished | qds | Fired if the background task for Query Store data persistence is completed successfully |
| Microsoft SQL Server 2016 (CTP2.0) | query_store_background_task_persist_started | qds | Fired if the background task for Query Store data persistence started execution |
| Microsoft SQL Server 2016 (CTP2.0) | query_store_capture_policy_abort_capture | qds | Fired when an UNDECIDED query failed to transition to CAPTURED. |
| Microsoft SQL Server 2016 (CTP2.0) | query_store_capture_policy_evaluate | qds | Fired when the capture policy is evaluated for a query. |
| Microsoft SQL Server 2016 (CTP2.0) | query_store_capture_policy_start_capture | qds | Fired when an UNDECIDED query is transitioning to CAPTURED. |
| Microsoft SQL Server 2016 (CTP2.0) | query_store_db_data_structs_not_released | qds | Fired if Query Store data structures are not released when feature is turned OFF. |
| Microsoft SQL Server 2016 (CTP2.0) | query_store_db_diagnostics | qds | Periodically fired with Query Store diagnostics on database level. |
| Microsoft SQL Server 2016 (CTP2.0) | query_store_db_settings_changed | qds | Fired when Query Store settings are changed. |
| Microsoft SQL Server 2016 (CTP2.0) | query_store_db_whitelisting_changed | qds | Fired when Query Store database whitelisting state is changed. |
| Microsoft SQL Server 2016 (CTP2.0) | query_store_generate_showplan_failure | qds | Fired when Query Store failed to store a query plan because the showplan generation failed. |
| Microsoft SQL Server 2016 (CTP2.0) | query_store_global_mem_obj_size_kb | qds | Periodically fired with Query Store global memory object size. |
| Microsoft SQL Server 2016 (CTP2.0) | query_store_load_started | qds | Fired when query store load is started |
| Microsoft SQL Server 2016 (CTP2.0) | query_store_schema_consistency_check_failure | qds | Fired when the QDS schema consistency check failed. |
| Microsoft SQL Server 2016 (CTP2.0) | query_store_size_retention_cleanup_finished | qds | Fired when size retention policy clean-up task is finished. |
| Microsoft SQL Server 2016 (CTP2.0) | query_store_size_retention_cleanup_skipped | qds | Fired when starting of size retention policy clean-up task is skipped because its minimum repeating period did not pass yet. |
| Microsoft SQL Server 2016 (CTP2.0) | query_store_size_retention_cleanup_started | qds | Fired when size retention policy clean-up task is started. |
| Microsoft SQL Server 2016 (CTP2.0) | query_store_size_retention_plan_cost | qds | Fired when eviction cost is calculated for the plan. |
| Microsoft SQL Server 2016 (CTP2.0) | query_store_size_retention_query_cost | qds | Fired when query eviction cost is calculated for the query. |
| Microsoft SQL Server 2016 (CTP2.0) | query_store_size_retention_query_deleted | qds | Fired when size based retention policy deletes a query from Query Store. |
| Microsoft SQL Server 2016 (CTP2.0) | query_trace_column_values | sqlserver | Trace output column values of each row on each query plan operator |
| Microsoft SQL Server 2016 (CTP2.0) | recalculate_mem_target | sqlos | New Memory Targets which are set after RecalculateTarget is executed |
| Microsoft SQL Server 2016 (CTP2.0) | remote_data_archive_db_ddl | sqlserver | Occurs when the database T-SQL ddl for stretching data is processed. |
| Microsoft SQL Server 2016 (CTP2.0) | remote_data_archive_provision_operation | sqlserver | Occurs when a provisioning operation starts or ends. |
| Microsoft SQL Server 2016 (CTP2.0) | remote_data_archive_query_rewrite | sqlserver | Occurs when RelOp_Get is replaced during query rewrite for Stretch. |
| Microsoft SQL Server 2016 (CTP2.0) | remote_data_archive_table_ddl | sqlserver | Occurs when the table T-SQL ddl for stretching data is processed. |
| Microsoft SQL Server 2016 (CTP2.0) | remote_data_archive_telemetry | sqlserver | Occurs whenever an on premise system transmits a telemetry event to Azure DB. |
| Microsoft SQL Server 2016 (CTP2.0) | remote_data_archive_telemetry_rejected | sqlserver | Occurs whenever an AzureDB Stretch telemetry event is rejected |
| Microsoft SQL Server 2016 (CTP2.0) | report_login_failure | sqlserver | This event is generated for a TDS login failure. |
| Microsoft SQL Server 2016 (CTP2.0) | rpc_starting_aggregate | sqlserver | Occurs periodically, aggregating all occasions an rpc call is started. |
| Microsoft SQL Server 2016 (CTP2.0) | rpc_starting_aggregate_xdb | sqlserver | Occurs periodically, aggregating all occasions an rpc call is started. |
| Microsoft SQL Server 2016 (CTP2.0) | sql_batch_starting_aggregate | sqlserver | Occurs periodically, aggregating all occasions a sql batch is started. |
| Microsoft SQL Server 2016 (CTP2.0) | sql_batch_starting_aggregate_xdb | sqlserver | Occurs periodically, aggregating all occasions a sql batch is started. |
| Microsoft SQL Server 2016 (CTP2.0) | startup_dependency_completed | sqlserver | Occurs on the completion of a startup dependency in the SQL Server startup sequence |
| Microsoft SQL Server 2016 (CTP2.0) | stretch_codegen_errorlog | sqlserver | Reports the output from the code generator |
| Microsoft SQL Server 2016 (CTP2.0) | stretch_codegen_start | sqlserver | Reports the start of stretch code generation |
| Microsoft SQL Server 2016 (CTP2.0) | stretch_create_migration_proc_start | sqlserver | Reports the start of migration procedure creation |
| Microsoft SQL Server 2016 (CTP2.0) | stretch_create_remote_table_start | sqlserver | Reports the start of remote table creation |
| Microsoft SQL Server 2016 (CTP2.0) | stretch_create_update_trigger_start | sqlserver | Reports the start of create update trigger for remote data archive table |
| Microsoft SQL Server 2016 (CTP2.0) | stretch_database_disable_completed | sqlserver | Reports the completion of a ALTER DATABASE SET REMOTE_DATA_ARCHIVE OFF command |
| Microsoft SQL Server 2016 (CTP2.0) | stretch_database_enable_completed | sqlserver | Reports the completion of a ALTER DATABASE SET REMOTE_DATA_ARCHIVE ON command |
| Microsoft SQL Server 2016 (CTP2.0) | stretch_database_events_submitted | sqlserver | Reports the completion telemetry transfer |
| Microsoft SQL Server 2016 (CTP2.0) | stretch_migration_debug_trace | sqlserver | Debug trace of stretch migration actions. |
| Microsoft SQL Server 2016 (CTP2.0) | stretch_migration_queue_migration | sqlserver | Queue a packet for starting migration of the database and object. |
| Microsoft SQL Server 2016 (CTP2.0) | stretch_migration_sp_stretch_get_batch_id | sqlserver | Call sp_stretch_get_batch_id |
| Microsoft SQL Server 2016 (CTP2.0) | stretch_migration_start_migration | sqlserver | Start migration of the database and object. |
| Microsoft SQL Server 2016 (CTP2.0) | stretch_sync_metadata_start | sqlserver | Reports the start of metadata checks during the migration task. |
| Microsoft SQL Server 2016 (CTP2.0) | stretch_table_codegen_completed | sqlserver | Reports the completion of code generation for a stretched table |
| Microsoft SQL Server 2016 (CTP2.0) | stretch_table_provisioning_step_duration | sqlserver | Reports the duration of a stretched table provisioning operation |
| Microsoft SQL Server 2016 (CTP2.0) | stretch_table_remote_creation_completed | sqlserver | Reports the completion of remote execution for the generated code for a stretched table |
| Microsoft SQL Server 2016 (CTP2.0) | stretch_table_row_migration_event | sqlserver | Reports the completion of the migration of a batch of rows |
| Microsoft SQL Server 2016 (CTP2.0) | stretch_table_row_migration_results_event | sqlserver | Reports an error or completion of a successful migration of a number of batches of rows |
| Microsoft SQL Server 2016 (CTP2.0) | stretch_table_unprovision_completed | sqlserver | Reports the completion removal of local resources for a table that was unstretched |
| Microsoft SQL Server 2016 (CTP2.0) | stretch_table_validation_error | sqlserver | Reports the completion of validation for a table when the user enables stretch |
| Microsoft SQL Server 2016 (CTP2.0) | stretch_unprovision_table_start | sqlserver | Reports the start of stretch table un-provisioning |
| Microsoft SQL Server 2016 (CTP2.0) | trace_dump_deleted_object_table_row | XtpEngine | Dump deleted object table row |
| Microsoft SQL Server 2016 (CTP2.0) | trust_verification_failed | sqlserver | Occurs when a SQL Server binary fails Authenticode signature verification. |
| Microsoft SQL Server 2016 (CTP2.0) | ucs_negotiation_completion | ucs | UCS transport connection negotiation completed |
| Microsoft SQL Server 2016 (CTP2.0) | unable_to_verify_trust | sqlserver | Occurs when SQL Server is unable to perform Authenticode signature verification on binaries. |
| Microsoft SQL Server 2016 (CTP2.0) | xio_blob_properties_obtained | sqlserver | Windows Azure Storage blob property is obtained from response header. |
| Microsoft SQL Server 2016 (CTP2.0) | xio_failed_request | sqlserver | Failed to complete a request to Windows Azure Storage. |
| Microsoft SQL Server 2016 (CTP2.0) | xio_header_obtained | sqlserver | Response header is obtained from request to Windows Azure Storage. |
| Microsoft SQL Server 2016 (CTP2.0) | xio_read_complete | sqlserver | Read complete from Windows Azure Storage response. |
| Microsoft SQL Server 2016 (CTP2.0) | xio_request_opened | sqlserver | A request is opened to Windows Azure Storage. |
| Microsoft SQL Server 2016 (CTP2.0) | xio_send_complete | sqlserver | Request send to Windows Azure Storage is complete. |
| Microsoft SQL Server 2016 (CTP2.0) | xio_write_complete | sqlserver | Request send to Windows Azure Storage is complete. |
| Microsoft SQL Server 2016 (CTP2.0) | xstore_acquire_lease | sqlserver | The properties of the lease acquire reques. |
| Microsoft SQL Server 2016 (CTP2.0) | xstore_create_file | sqlserver | Creating an XStore file has been attempted with the options below. |
| Microsoft SQL Server 2016 (CTP2.0) | xstore_debug_trace | sqlserver | Telemetry tracing event has occurred. |
| Microsoft SQL Server 2016 (CTP2.0) | xstore_lease_renewal_request | sqlserver | Attempt to renew blob lease |
| Microsoft SQL Server 2016 (CTP2.0) | xtp_alter_table | sqlserver | Occurs at start of XTP table altering. |
| Microsoft SQL Server 2016 (CTP2.0) | xtp_ckptctrl_abort_checkpoint | XtpEngine | Indicates that the checkpoint close thread aborted a checkpoint. |
| Microsoft SQL Server 2016 (CTP2.0) | xtp_ckptctrl_close_checkpoint | XtpEngine | Indicates that the checkpoint close thread hardened a checkpoint. |
| Microsoft SQL Server 2016 (CTP2.0) | xtp_ckptctrl_close_install_merge | XtpEngine | Indicates that the checkpoint close thread installed a merge. |
| Microsoft SQL Server 2016 (CTP2.0) | xtp_ckptctrl_new_segment_definition | XtpEngine | Indicates that the checkpoint controller processed a new segment definition. |
| Microsoft SQL Server 2016 (CTP2.0) | xtp_ckptctrl_storage_array_grow | XtpEngine | Indicates the XTP storage array has grown in size. |
| Microsoft SQL Server 2016 (CTP2.0) | xtp_drop_table | sqlserver | Occurs after an XTP table has been dropped. |
| Microsoft SQL Server 2016 (CTP2.0) | xtp_merge_request_start | XtpEngine | Indicates that an XTP storage merge was requested. |
| Microsoft SQL Server 2016 (CTP2.0) | xtp_merge_request_stop | XtpEngine | Indicates that an XTP storage merge request ended. |
| Microsoft SQL Server 2016 (CTP2.0) | xtp_merge_start | XtpEngine | Indicates that an XTP storage merge range is starting. |
| Microsoft SQL Server 2016 (CTP2.0) | xtp_merge_stop | XtpEngine | Indicates that an XTP storage merge range completed. |
| Microsoft SQL Server 2016 (CTP2.0) | xtp_redo_log_corruption | XtpEngine | Indicates that the redo process failed due to log corruption. |
| Microsoft SQL Server 2016 (CTP2.0) | xtp_root_file_deserialized | XtpEngine | Indicates that the load of a checkpoint root file is complete. |
| Microsoft SQL Server 2016 (CTP2.0) | xtp_root_file_serialized | XtpEngine | Indicates that the write of the checkpoint root file is complete. |
There you have it, currently 165 new events available to help monitor and troubleshoot SQL Server.
