{"id":1824,"date":"2015-06-02T10:59:26","date_gmt":"2015-06-02T17:59:26","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/bobb\/?p=1824"},"modified":"2015-06-02T11:13:40","modified_gmt":"2015-06-02T18:13:40","slug":"over-1000-xevents-in-sql-server-2016-ctp2-here-are-the-new-ones","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/bobb\/over-1000-xevents-in-sql-server-2016-ctp2-here-are-the-new-ones\/","title":{"rendered":"Over 1000 XEvents in SQL Server 2016 CTP2. Here are the new ones."},"content":{"rendered":"<p>Extended events has firmly established itself as the premier diagnostic feature in SQL Server and SQL Server 2016 brings along more events to correspond to new features and fill in some diagnostic gaps. I always like to investigate a new release by seeing what&#8217;s new to trace. So here&#8217;s a &#8220;diff&#8221; of SQL Server 2016 CTP2 vs SQL Server 2014 (RTM) with respect to extended events. In SQL Server 2016 CTP2, the team has provided OVER 1000 different events, 1034 to be precise. 165 of them are new.<\/p>\n<p>First, a couple of caveats:<\/p>\n<p>The SQL Server team occasionally introduces events before the feature is available. An example of this is the query store, where a number of events were included in the metadata for SQL Server 2014, before the feature was available.<\/p>\n<p>Because SQL Server and Azure SQL Database (ASD) share a common codebase, some events may be more useful (or only useful) in an ASD environment. An example of this may be the sqlserver.fulltextlog_written event. Full-text search was just introduced in ASD V1.2 and in ASD, you can&#8217;t read the full-text logs, a common diagnostic. Maybe this event will fill the gap.<\/p>\n<p>Some of the events may have actually been introduced in SQL Server 2014 SP1. I remember a blog post that mentioned columnstore events in 2014 SP1, or for ASD V1.2. Figured that the 2016CTP2 vs 2014 comparison was more useful.<\/p>\n<p>If you&#8217;re looking for these events in the XEvent GUI, don&#8217;t forget to turn on the debug channel events, which are off by default in the GUI. There appears to be some refactoring going on the the GUI categories, too, so use the GUI&#8217;s &#8220;event name completion&#8221; instead.<\/p>\n<p>And of course, my observations:<\/p>\n<p>The columnstore feature, including batch mode in queries, which had little to no coverage in 2014 extended events, now has rich coverage.<\/p>\n<p>The new stretch tables and query store features are covered. Even JSON production has some diagnostics.<\/p>\n<p>There are new series of events for availability groups (HADR) and in-memory tables (XTP), as well as Azure IO.<\/p>\n<p>I&#8217;m especially happy with the new SQLCLR events. These will be helpful for folks who use built-in SQLCLR features (like spatial data) and those who work on the edges of user SQLCLR (i.e. unsafe assemblies).<\/p>\n<p>Only 3 events were &#8220;discontinued&#8221; in SQL Server 2016 CTP2 vs. 2014, two refactored query store events, and one likely internal one, for columnstore code coverage.<\/p>\n<p>Here&#8217;s the list&#8230;enjoy.<\/p>\n<p>@bobbeauch<\/p>\n<p>Full Name\u00a0\u00a0 \u00a0description<br \/>\nqds.query_store_background_task_persist_finished\u00a0\u00a0 \u00a0Fired if the background task for Query Store data persistence is completed successfully<br \/>\nqds.query_store_background_task_persist_started\u00a0\u00a0 \u00a0Fired if the background task for Query Store data persistence started execution<br \/>\nqds.query_store_capture_policy_abort_capture\u00a0\u00a0 \u00a0Fired when an UNDECIDED query failed to transition to CAPTURED.<br \/>\nqds.query_store_capture_policy_evaluate\u00a0\u00a0 \u00a0Fired when the capture policy is evaluated for a query.<br \/>\nqds.query_store_capture_policy_start_capture\u00a0\u00a0 \u00a0Fired when an UNDECIDED query is transitioning to CAPTURED.<br \/>\nqds.query_store_db_data_structs_not_released\u00a0\u00a0 \u00a0Fired if Query Store data structures are not released when feature is turned OFF.<br \/>\nqds.query_store_db_diagnostics\u00a0\u00a0 \u00a0Periodically fired with Query Store diagnostics on database level.<br \/>\nqds.query_store_db_settings_changed\u00a0\u00a0 \u00a0Fired when Query Store settings are changed.<br \/>\nqds.query_store_db_whitelisting_changed\u00a0\u00a0 \u00a0Fired when Query Store database whitelisting state is changed.<br \/>\nqds.query_store_generate_showplan_failure\u00a0\u00a0 \u00a0Fired when Query Store failed to store a query plan because the showplan generation failed.<br \/>\nqds.query_store_global_mem_obj_size_kb\u00a0\u00a0 \u00a0Periodically fired with Query Store global memory object size.<br \/>\nqds.query_store_load_started\u00a0\u00a0 \u00a0Fired when query store load is started<br \/>\nqds.query_store_schema_consistency_check_failure\u00a0\u00a0 \u00a0Fired when the QDS schema consistency check failed.<br \/>\nqds.query_store_size_retention_cleanup_finished\u00a0\u00a0 \u00a0Fired when size retention policy clean-up task is finished.<br \/>\nqds.query_store_size_retention_cleanup_skipped\u00a0\u00a0 \u00a0Fired when starting of size retention policy clean-up task is skipped because its minimum repeating period did not pass yet.<br \/>\nqds.query_store_size_retention_cleanup_started\u00a0\u00a0 \u00a0Fired when size retention policy clean-up task is started.<br \/>\nqds.query_store_size_retention_plan_cost\u00a0\u00a0 \u00a0Fired when eviction cost is calculated for the plan.<br \/>\nqds.query_store_size_retention_query_cost\u00a0\u00a0 \u00a0Fired when query eviction cost is calculated for the query.<br \/>\nqds.query_store_size_retention_query_deleted\u00a0\u00a0 \u00a0Fired when size based retention policy deletes a query from Query Store.<br \/>\nsqlclr.clr_context_dump\u00a0\u00a0 \u00a0ClrContextDump triggered.<br \/>\nsqlclr.notify_on_clr_disabled\u00a0\u00a0 \u00a0Event_ClrDisabled has been triggered in ClrHost.<br \/>\nsqlclr.on_app_domain_failure\u00a0\u00a0 \u00a0AppDomain hit a failure.<br \/>\nsqlclr.on_app_domain_unloading\u00a0\u00a0 \u00a0AppDomain is unloading.<br \/>\nsqlclr.on_host_policy_callback\u00a0\u00a0 \u00a0IHostPolicyManager received an event.<br \/>\nsqlclr.on_host_policy_failure\u00a0\u00a0 \u00a0IHostPolicyManager received an event.<br \/>\nsqlos.ex_raise2\u00a0\u00a0 \u00a0Raised exception<br \/>\nsqlos.premature_systemthread_wakeup\u00a0\u00a0 \u00a0system thread is woken up prematurely<br \/>\nsqlos.recalculate_mem_target\u00a0\u00a0 \u00a0New Memory Targets which are set after RecalculateTarget is executed<br \/>\nsqlserver.availability_replica_database_fault_reporting\u00a0\u00a0 \u00a0Occurs when a database reports a fault to the availability replica manager which will trigger a replica restart if the database is critical<br \/>\nsqlserver.backup_restore_progress_trace\u00a0\u00a0 \u00a0Prints backup\/restore progress trace messages with details<br \/>\nsqlserver.batchmode_sort_spill_file\u00a0\u00a0 \u00a0Record the spill file read\/write information for batch mode sort<br \/>\nsqlserver.batchmode_sort_status\u00a0\u00a0 \u00a0Record batch mode sort status<br \/>\nsqlserver.column_store_expression_filter_apply\u00a0\u00a0 \u00a0An expression bitmap filter was applied on a rowgroup column batch.<br \/>\nsqlserver.column_store_expression_filter_bitmap_set\u00a0\u00a0 \u00a0An expression bitmap filter was set on a rowgroup column at rowgroup compile time.<br \/>\nsqlserver.columnstore_delete_buffer_closed_rowgroup_with_generationid_found\u00a0\u00a0 \u00a0Delete buffer can not be flushed due to existence of one or more closed rowgroups with generation ID.<br \/>\nsqlserver.columnstore_delete_buffer_flush_failed\u00a0\u00a0 \u00a0Columnstore delete buffer flush failed.<br \/>\nsqlserver.columnstore_delete_buffer_state_transition\u00a0\u00a0 \u00a0Occurs when closed delete buffer state changes.<br \/>\nsqlserver.columnstore_delta_rowgroup_closed\u00a0\u00a0 \u00a0A delta rowgroup was closed.<br \/>\nsqlserver.columnstore_no_rowgroup_qualified_for_merge\u00a0\u00a0 \u00a0A user invoked a REORG command but based on the policy, no rowgroup qualified.<br \/>\nsqlserver.columnstore_rowgroup_compressed\u00a0\u00a0 \u00a0A compressed rowgroup was created.<br \/>\nsqlserver.columnstore_rowgroup_merge_complete\u00a0\u00a0 \u00a0A MERGE operation completed merging columnstore rowgroups together.<br \/>\nsqlserver.columnstore_rowgroup_merge_start\u00a0\u00a0 \u00a0A MERGE operation started merging columnstore rowgroups together.<br \/>\nsqlserver.columnstore_tuple_mover_begin_delete_buffer_flush\u00a0\u00a0 \u00a0Columnstore tuple mover started flushing a delete buffer.<br \/>\nsqlserver.columnstore_tuple_mover_compression_stats\u00a0\u00a0 \u00a0Statistics about the movement of a deltastore to a compressed rowgroup, including duration, size, etc.<br \/>\nsqlserver.columnstore_tuple_mover_delete_buffer_flush_requirements_not_met\u00a0\u00a0 \u00a0Occurs when column store tuple mover was not able to acquire required locks for flushing a delete buffer.<br \/>\nsqlserver.columnstore_tuple_mover_delete_buffer_truncate_requirements_not_met\u00a0\u00a0 \u00a0Occurs when column store tuple mover was not able to acquire required locks for truncating a delete buffer.<br \/>\nsqlserver.columnstore_tuple_mover_delete_buffer_truncated\u00a0\u00a0 \u00a0Columnstore tuple mover truncated delete buffer.<br \/>\nsqlserver.columnstore_tuple_mover_delete_buffers_swapped\u00a0\u00a0 \u00a0Columnstore tuple mover swapped delete buffers.<br \/>\nsqlserver.columnstore_tuple_mover_end_delete_buffer_flush\u00a0\u00a0 \u00a0Columnstore tuple mover completed flushing a delete buffer.<br \/>\nsqlserver.columnstore_tuple_mover_met_requirements_for_delete_buffer_flush\u00a0\u00a0 \u00a0Occurs when column store tuple mover has acquired required locks and is ready to start flushing a delete buffer.<br \/>\nsqlserver.columnstore_tuple_mover_met_requirements_for_delete_buffer_truncate\u00a0\u00a0 \u00a0Occurs when column store tuple mover has acquired required locks and is ready to start truncating a delete buffer.<br \/>\nsqlserver.columnstore_x_dbfl_acquired\u00a0\u00a0 \u00a0Occurs when X Delete Buffer Flush Lock is acquired.<br \/>\nsqlserver.compressed_alter_column_is_md_only\u00a0\u00a0 \u00a0Occurs during an alter column operation. Indicates whether the alter column is metadata only or not.<br \/>\nsqlserver.connection_accept\u00a0\u00a0 \u00a0Occurs when a new connection is accepted by (or duplicated into) the server. This event serves to log all connection attempts.<br \/>\nsqlserver.connection_duplication_failure\u00a0\u00a0 \u00a0Occurs when connection duplication fails<br \/>\nsqlserver.data_purity_checks_for_dbcompat_130\u00a0\u00a0 \u00a0Occurs when an operation that may require a data purity check for dbcompat level 130 occurs.<br \/>\nsqlserver.database_recovery_times\u00a0\u00a0 \u00a0Database recovery times<br \/>\nsqlserver.database_tde_encryption_scan_duration\u00a0\u00a0 \u00a0Database TDE Encryption Scan<br \/>\nsqlserver.database_transaction_yield\u00a0\u00a0 \u00a0Occurs when a database transaction yields execution due to TDS buffer being full.<br \/>\nsqlserver.fulltextlog_written\u00a0\u00a0 \u00a0Errorlog written<br \/>\nsqlserver.global_transaction\u00a0\u00a0 \u00a0Occurs when global transaction is started.<br \/>\nsqlserver.hadr_db_log_throttle\u00a0\u00a0 \u00a0Occurs when DB log generation throttle changes.<br \/>\nsqlserver.hadr_db_log_throttle_configuration_parameters\u00a0\u00a0 \u00a0Occurs when DB log generation throttle configuration parameters are read.<br \/>\nsqlserver.hadr_db_log_throttle_input\u00a0\u00a0 \u00a0Occurs when HADR Fabric log management component updates log throttle.<br \/>\nsqlserver.hadr_db_marked_for_reseed\u00a0\u00a0 \u00a0Occurs when a HADR secondary DB falls too far behind primary and is marked for reseed.<br \/>\nsqlserver.hadr_db_remote_harden_failure\u00a0\u00a0 \u00a0A harden request as part of a commit or prepare failed due to remote failure.<br \/>\nsqlserver.hadr_log_block_send_complete\u00a0\u00a0 \u00a0Occurs after a log block message has been sent. This event is only used for failpoints.<br \/>\nsqlserver.hadr_partner_log_send_transition\u00a0\u00a0 \u00a0Log send transition between log writer and log capture.<br \/>\nsqlserver.hadr_partner_restart_scan\u00a0\u00a0 \u00a0Restart partner scans for this partner.<br \/>\nsqlserver.hadr_physical_seeding_backup_state_change\u00a0\u00a0 \u00a0Physical Seeding Backup Side State Change.<br \/>\nsqlserver.hadr_physical_seeding_failure\u00a0\u00a0 \u00a0Physical Seeding Failure Event.<br \/>\nsqlserver.hadr_physical_seeding_forwarder_state_change\u00a0\u00a0 \u00a0Physical Seeding Forwarder Side State Change.<br \/>\nsqlserver.hadr_physical_seeding_forwarder_target_state_change\u00a0\u00a0 \u00a0Physical Seeding Forwarder Target Side State Change.<br \/>\nsqlserver.hadr_physical_seeding_progress\u00a0\u00a0 \u00a0Physical Seeding Progress Event.<br \/>\nsqlserver.hadr_physical_seeding_restore_state_change\u00a0\u00a0 \u00a0Physical Seeding Restore Side State Change.<br \/>\nsqlserver.hadr_physical_seeding_submit_callback\u00a0\u00a0 \u00a0Physical Seeding Submit Callback Event.<br \/>\nsqlserver.hadr_send_harden_lsn_message\u00a0\u00a0 \u00a0Occurs when we&#8217;re crafting a message to send containing a new hardened LSN on a secondary. Test only.<br \/>\nsqlserver.hadr_transport_configuration_state\u00a0\u00a0 \u00a0Indicates session state changes<br \/>\nsqlserver.hadr_transport_dump_dropped_message\u00a0\u00a0 \u00a0Use this event to trace dropped HADR transport messages throughout the system.<br \/>\nsqlserver.hadr_transport_dump_failure_message\u00a0\u00a0 \u00a0Use this event to help trace HADR failure messages.<br \/>\nsqlserver.hadr_transport_dump_preconfig_message\u00a0\u00a0 \u00a0Use this event to help trace HADR preconfig messages.<br \/>\nsqlserver.hadr_transport_sync_send_failure\u00a0\u00a0 \u00a0Synchronous send failure in hadr transport.<br \/>\nsqlserver.hadr_transport_ucs_registration\u00a0\u00a0 \u00a0Reports UCS registration state changes<br \/>\nsqlserver.json_depth_error\u00a0\u00a0 \u00a0Occurs when depth of json text being parsed is bigger than 128.<br \/>\nsqlserver.json_parsing_error\u00a0\u00a0 \u00a0Indicates json parser error. Occurs when json format is not valid.<br \/>\nsqlserver.json_stackoverflow_error\u00a0\u00a0 \u00a0Json parser stack overflow.<br \/>\nsqlserver.json_unescaped_character\u00a0\u00a0 \u00a0Jsonparser hitted unescaped character in json string.<br \/>\nsqlserver.log_pool_cache_miss\u00a0\u00a0 \u00a0Occurs when a log consumer attempts to lookup a block from the log pool but fails to find it.<br \/>\nsqlserver.log_pool_push_no_free_buffer\u00a0\u00a0 \u00a0Occurs when log pool push fails to get a free buffer and bails out.<br \/>\nsqlserver.login_event\u00a0\u00a0 \u00a0This is an abbreviated version of process_login_finish, containing only the columns required by external monitoring telemetry pipeline.<br \/>\nsqlserver.page_cache_trace\u00a0\u00a0 \u00a0Modification of the page cache.<br \/>\nsqlserver.private_login_accept\u00a0\u00a0 \u00a0TDS connection accept event that is logged to private MDS table.<br \/>\nsqlserver.private_login_finish\u00a0\u00a0 \u00a0TDS login finish event that is logged to private MDS table.<br \/>\nsqlserver.process_login_finish\u00a0\u00a0 \u00a0This event is generated when server is done processing a login (success or failure).<br \/>\nsqlserver.query_execution_batch_filter\u00a0\u00a0 \u00a0Occurs when batch processing filters one batch using expression services.<br \/>\nsqlserver.query_execution_batch_spill_started\u00a0\u00a0 \u00a0Occurs when batch operator runs out of granted memory and initiates spilling to disk of another partition of in-memory data.<br \/>\nsqlserver.query_execution_column_store_rowgroup_scan_finished\u00a0\u00a0 \u00a0Occurs when row bucket processor finishes column store row group scan.<br \/>\nsqlserver.query_execution_column_store_segment_scan_finished\u00a0\u00a0 \u00a0Occurs when row bucket processor finishes column store segment scan.<br \/>\nsqlserver.query_execution_column_store_segment_scan_started\u00a0\u00a0 \u00a0Occurs when column segment scan starts.<br \/>\nsqlserver.query_memory_grant_blocking\u00a0\u00a0 \u00a0Occurs when a query is blocking other queries while waiting for memory grant<br \/>\nsqlserver.query_memory_grant_usage\u00a0\u00a0 \u00a0Occurs at the end of query processing for queries with memory grant over 5MB to let users know about memory grant inaccuracies<br \/>\nsqlserver.query_trace_column_values\u00a0\u00a0 \u00a0Trace output column values of each row on each query plan operator<br \/>\nsqlserver.remote_data_archive_db_ddl\u00a0\u00a0 \u00a0Occurs when the database T-SQL ddl for stretching data is processed.<br \/>\nsqlserver.remote_data_archive_provision_operation\u00a0\u00a0 \u00a0Occurs when a provisioning operation starts or ends.<br \/>\nsqlserver.remote_data_archive_query_rewrite\u00a0\u00a0 \u00a0Occurs when RelOp_Get is replaced during query rewrite for Stretch.<br \/>\nsqlserver.remote_data_archive_table_ddl\u00a0\u00a0 \u00a0Occurs when the table T-SQL ddl for stretching data is processed.<br \/>\nsqlserver.remote_data_archive_telemetry\u00a0\u00a0 \u00a0Occurs whenever an on premise system transmits a telemetry event to Azure DB.<br \/>\nsqlserver.remote_data_archive_telemetry_rejected\u00a0\u00a0 \u00a0Occurs whenever an AzureDB Stretch telemetry event is rejected<br \/>\nsqlserver.report_login_failure\u00a0\u00a0 \u00a0This event is generated for a TDS login failure.<br \/>\nsqlserver.rpc_starting_aggregate\u00a0\u00a0 \u00a0Occurs periodically, aggregating all occasions an rpc call is started.<br \/>\nsqlserver.rpc_starting_aggregate_xdb\u00a0\u00a0 \u00a0Occurs periodically, aggregating all occasions an rpc call is started.<br \/>\nsqlserver.sql_batch_starting_aggregate\u00a0\u00a0 \u00a0Occurs periodically, aggregating all occasions a sql batch is started.<br \/>\nsqlserver.sql_batch_starting_aggregate_xdb\u00a0\u00a0 \u00a0Occurs periodically, aggregating all occasions a sql batch is started.<br \/>\nsqlserver.startup_dependency_completed\u00a0\u00a0 \u00a0Occurs on the completion of a startup dependency in the SQL Server startup sequence<br \/>\nsqlserver.stretch_codegen_errorlog\u00a0\u00a0 \u00a0Reports the output from the code generator<br \/>\nsqlserver.stretch_codegen_start\u00a0\u00a0 \u00a0Reports the start of stretch code generation<br \/>\nsqlserver.stretch_create_migration_proc_start\u00a0\u00a0 \u00a0Reports the start of migration procedure creation<br \/>\nsqlserver.stretch_create_remote_table_start\u00a0\u00a0 \u00a0Reports the start of remote table creation<br \/>\nsqlserver.stretch_create_update_trigger_start\u00a0\u00a0 \u00a0Reports the start of create update trigger for remote data archive table<br \/>\nsqlserver.stretch_database_disable_completed\u00a0\u00a0 \u00a0Reports the completion of a ALTER DATABASE SET REMOTE_DATA_ARCHIVE OFF command<br \/>\nsqlserver.stretch_database_enable_completed\u00a0\u00a0 \u00a0Reports the completion of a ALTER DATABASE SET REMOTE_DATA_ARCHIVE ON command<br \/>\nsqlserver.stretch_database_events_submitted\u00a0\u00a0 \u00a0Reports the completion telemetry transfer<br \/>\nsqlserver.stretch_migration_debug_trace\u00a0\u00a0 \u00a0Debug trace of stretch migration actions.<br \/>\nsqlserver.stretch_migration_queue_migration\u00a0\u00a0 \u00a0Queue a packet for starting migration of the database and object.<br \/>\nsqlserver.stretch_migration_sp_stretch_get_batch_id\u00a0\u00a0 \u00a0Call sp_stretch_get_batch_id<br \/>\nsqlserver.stretch_migration_start_migration\u00a0\u00a0 \u00a0Start migration of the database and object.<br \/>\nsqlserver.stretch_sync_metadata_start\u00a0\u00a0 \u00a0Reports the start of metadata checks during the migration task.<br \/>\nsqlserver.stretch_table_codegen_completed\u00a0\u00a0 \u00a0Reports the completion of code generation for a stretched table<br \/>\nsqlserver.stretch_table_provisioning_step_duration\u00a0\u00a0 \u00a0Reports the duration of a stretched table provisioning operation<br \/>\nsqlserver.stretch_table_remote_creation_completed\u00a0\u00a0 \u00a0Reports the completion of remote execution for the generated code for a stretched table<br \/>\nsqlserver.stretch_table_row_migration_event\u00a0\u00a0 \u00a0Reports the completion of the migration of a batch of rows<br \/>\nsqlserver.stretch_table_row_migration_results_event\u00a0\u00a0 \u00a0Reports an error or completion of a successful migration of a number of batches of rows<br \/>\nsqlserver.stretch_table_unprovision_completed\u00a0\u00a0 \u00a0Reports the completion removal of local resources for a table that was unstretched<br \/>\nsqlserver.stretch_table_validation_error\u00a0\u00a0 \u00a0Reports the completion of validation for a table when the user enables stretch<br \/>\nsqlserver.stretch_unprovision_table_start\u00a0\u00a0 \u00a0Reports the start of stretch table un-provisioning<br \/>\nsqlserver.trust_verification_failed\u00a0\u00a0 \u00a0Occurs when a SQL Server binary fails Authenticode signature verification.<br \/>\nsqlserver.unable_to_verify_trust\u00a0\u00a0 \u00a0Occurs when SQL Server is unable to perform Authenticode signature verification on binaries.<br \/>\nsqlserver.xio_blob_properties_obtained\u00a0\u00a0 \u00a0Windows Azure Storage blob property is obtained from response header.<br \/>\nsqlserver.xio_failed_request\u00a0\u00a0 \u00a0Failed to complete a request to Windows Azure Storage.<br \/>\nsqlserver.xio_header_obtained\u00a0\u00a0 \u00a0Response header is obtained from request to Windows Azure Storage.<br \/>\nsqlserver.xio_read_complete\u00a0\u00a0 \u00a0Read complete from Windows Azure Storage response.<br \/>\nsqlserver.xio_request_opened\u00a0\u00a0 \u00a0A request is opened to Windows Azure Storage.<br \/>\nsqlserver.xio_send_complete\u00a0\u00a0 \u00a0Request send to Windows Azure Storage is complete.<br \/>\nsqlserver.xio_write_complete\u00a0\u00a0 \u00a0Request send to Windows Azure Storage is complete.<br \/>\nsqlserver.xstore_acquire_lease\u00a0\u00a0 \u00a0The properties of the lease acquire reques.<br \/>\nsqlserver.xstore_create_file\u00a0\u00a0 \u00a0Creating an XStore file has been attempted with the options below.<br \/>\nsqlserver.xstore_debug_trace\u00a0\u00a0 \u00a0Telemetry tracing event has occurred.<br \/>\nsqlserver.xstore_lease_renewal_request\u00a0\u00a0 \u00a0Attempt to renew blob lease<br \/>\nsqlserver.xtp_alter_table\u00a0\u00a0 \u00a0Occurs at start of XTP table altering.<br \/>\nsqlserver.xtp_drop_table\u00a0\u00a0 \u00a0Occurs after an XTP table has been dropped.<br \/>\nucs.ucs_negotiation_completion\u00a0\u00a0 \u00a0UCS transport connection negotiation completed<br \/>\nXtpCompile.cl_duration\u00a0\u00a0 \u00a0Reports the duration of the C compilation.<br \/>\nXtpEngine.trace_dump_deleted_object_table_row\u00a0\u00a0 \u00a0Dump deleted object table row<br \/>\nXtpEngine.xtp_ckptctrl_abort_checkpoint\u00a0\u00a0 \u00a0Indicates that the checkpoint close thread aborted a checkpoint.<br \/>\nXtpEngine.xtp_ckptctrl_close_checkpoint\u00a0\u00a0 \u00a0Indicates that the checkpoint close thread hardened a checkpoint.<br \/>\nXtpEngine.xtp_ckptctrl_close_install_merge\u00a0\u00a0 \u00a0Indicates that the checkpoint close thread installed a merge.<br \/>\nXtpEngine.xtp_ckptctrl_new_segment_definition\u00a0\u00a0 \u00a0Indicates that the checkpoint controller processed a new segment definition.<br \/>\nXtpEngine.xtp_ckptctrl_storage_array_grow\u00a0\u00a0 \u00a0Indicates the XTP storage array has grown in size.<br \/>\nXtpEngine.xtp_merge_request_start\u00a0\u00a0 \u00a0Indicates that an XTP storage merge was requested.<br \/>\nXtpEngine.xtp_merge_request_stop\u00a0\u00a0 \u00a0Indicates that an XTP storage merge request ended.<br \/>\nXtpEngine.xtp_merge_start\u00a0\u00a0 \u00a0Indicates that an XTP storage merge range is starting.<br \/>\nXtpEngine.xtp_merge_stop\u00a0\u00a0 \u00a0Indicates that an XTP storage merge range completed.<br \/>\nXtpEngine.xtp_redo_log_corruption\u00a0\u00a0 \u00a0Indicates that the redo process failed due to log corruption.<br \/>\nXtpEngine.xtp_root_file_deserialized\u00a0\u00a0 \u00a0Indicates that the load of a checkpoint root file is complete.<br \/>\nXtpEngine.xtp_root_file_serialized\u00a0\u00a0 \u00a0Indicates that the write of the checkpoint root file is complete.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Extended events has firmly established itself as the premier diagnostic feature in SQL Server and SQL Server 2016 brings along more events to correspond to new features and fill in some diagnostic gaps. I always like to investigate a new release by seeing what&#8217;s new to trace. So here&#8217;s a &#8220;diff&#8221; of SQL Server 2016 [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15,46],"tags":[],"class_list":["post-1824","post","type-post","status-publish","format-standard","hentry","category-extended-events","category-sql-server-2016"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.9.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Over 1000 XEvents in SQL Server 2016 CTP2. Here are the new ones. - Bob Beauchemin<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/bobb\/over-1000-xevents-in-sql-server-2016-ctp2-here-are-the-new-ones\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Over 1000 XEvents in SQL Server 2016 CTP2. Here are the new ones. - Bob Beauchemin\" \/>\n<meta property=\"og:description\" content=\"Extended events has firmly established itself as the premier diagnostic feature in SQL Server and SQL Server 2016 brings along more events to correspond to new features and fill in some diagnostic gaps. I always like to investigate a new release by seeing what&#8217;s new to trace. So here&#8217;s a &#8220;diff&#8221; of SQL Server 2016 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/bobb\/over-1000-xevents-in-sql-server-2016-ctp2-here-are-the-new-ones\/\" \/>\n<meta property=\"og:site_name\" content=\"Bob Beauchemin\" \/>\n<meta property=\"article:published_time\" content=\"2015-06-02T17:59:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-06-02T18:13:40+00:00\" \/>\n<meta name=\"author\" content=\"Bob Beauchemin\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bob Beauchemin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"15 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/over-1000-xevents-in-sql-server-2016-ctp2-here-are-the-new-ones\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/over-1000-xevents-in-sql-server-2016-ctp2-here-are-the-new-ones\/\",\"name\":\"Over 1000 XEvents in SQL Server 2016 CTP2. Here are the new ones. - Bob Beauchemin\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website\"},\"datePublished\":\"2015-06-02T17:59:26+00:00\",\"dateModified\":\"2015-06-02T18:13:40+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/over-1000-xevents-in-sql-server-2016-ctp2-here-are-the-new-ones\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/bobb\/over-1000-xevents-in-sql-server-2016-ctp2-here-are-the-new-ones\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/over-1000-xevents-in-sql-server-2016-ctp2-here-are-the-new-ones\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Extended Events\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/category\/extended-events\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Over 1000 XEvents in SQL Server 2016 CTP2. Here are the new ones.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/\",\"name\":\"Bob Beauchemin\",\"description\":\"SQL Server Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e\",\"name\":\"Bob Beauchemin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g\",\"caption\":\"Bob Beauchemin\"},\"sameAs\":[\"http:\/www.sqlskills.com\/blogs\/bobb\/\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/author\/bobb\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Over 1000 XEvents in SQL Server 2016 CTP2. Here are the new ones. - Bob Beauchemin","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlskills.com\/blogs\/bobb\/over-1000-xevents-in-sql-server-2016-ctp2-here-are-the-new-ones\/","og_locale":"en_US","og_type":"article","og_title":"Over 1000 XEvents in SQL Server 2016 CTP2. Here are the new ones. - Bob Beauchemin","og_description":"Extended events has firmly established itself as the premier diagnostic feature in SQL Server and SQL Server 2016 brings along more events to correspond to new features and fill in some diagnostic gaps. I always like to investigate a new release by seeing what&#8217;s new to trace. So here&#8217;s a &#8220;diff&#8221; of SQL Server 2016 [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/over-1000-xevents-in-sql-server-2016-ctp2-here-are-the-new-ones\/","og_site_name":"Bob Beauchemin","article_published_time":"2015-06-02T17:59:26+00:00","article_modified_time":"2015-06-02T18:13:40+00:00","author":"Bob Beauchemin","twitter_misc":{"Written by":"Bob Beauchemin","Est. reading time":"15 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/over-1000-xevents-in-sql-server-2016-ctp2-here-are-the-new-ones\/","url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/over-1000-xevents-in-sql-server-2016-ctp2-here-are-the-new-ones\/","name":"Over 1000 XEvents in SQL Server 2016 CTP2. Here are the new ones. - Bob Beauchemin","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website"},"datePublished":"2015-06-02T17:59:26+00:00","dateModified":"2015-06-02T18:13:40+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/over-1000-xevents-in-sql-server-2016-ctp2-here-are-the-new-ones\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/bobb\/over-1000-xevents-in-sql-server-2016-ctp2-here-are-the-new-ones\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/over-1000-xevents-in-sql-server-2016-ctp2-here-are-the-new-ones\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/bobb\/"},{"@type":"ListItem","position":2,"name":"Extended Events","item":"https:\/\/www.sqlskills.com\/blogs\/bobb\/category\/extended-events\/"},{"@type":"ListItem","position":3,"name":"Over 1000 XEvents in SQL Server 2016 CTP2. Here are the new ones."}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/","name":"Bob Beauchemin","description":"SQL Server Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/bobb\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e","name":"Bob Beauchemin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g","caption":"Bob Beauchemin"},"sameAs":["http:\/www.sqlskills.com\/blogs\/bobb\/"],"url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/author\/bobb\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/posts\/1824","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/comments?post=1824"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/posts\/1824\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/media?parent=1824"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/categories?post=1824"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/tags?post=1824"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}