Neue “Erweiterte Ereignisse” (XEvents) für Tracing in SQL Server 2014
(de) Zunächst gibt es 3 neue Pakete („Packages“), die alle zu der neuen Arbeitsspeicher(„In-Memory“) -OLTP Engine: XTP, aufgeteilt auf 3 DLLs: | (en) To begin with there are 3 new packages, all belonging to the new In-Memory OLTP Engine: XTP, split up into 3 dlls: |
Package | description | Module name |
XtpRuntime | Extended events for the XTP Runtime | {InstanceDir}\MSSQL\Binn\ |
XtpEngine | Extended events for the XTP Engine | {InstanceDir}\MSSQL\Binn\ |
XtpCompile | Extended events for the XTP Compile | {InstanceDir}\MSSQL\Binn\ |
Die Anzahl der Extended Events ist von 625 in SQL Server 2012 (SP1) auf 870 in SQL Server 2014 (RTM) angestiegen. Das sind 245 neue Events! – Reichlich Möglichkeiten, in Internas einzutauchen 🙂 recovery_incremental_checkpoint in recovery_indirect_checkpoint und hekaton_slow_param_passing in natively_compiled_proc_slow_parameter_passing Ja, richtig gelesen. Es gab bereits im SQL Server 2012 eine Anzahl an Events für die XTP Engine. Es kommt recht häufig vor, dass man Bits von zukünftigen Entwicklungen in der aktuellen Release findet. Nebenbei: SQL Trace wurde nicht im geringsten angefasst. Die Anzahl von SQL Trace Events bleibt mit 180 seit SQL Server 2008 stabil. – Here ist ein Überblick von Extended Events gegen SQL Trace Events in den verschiedenen SQL Server Versionen: Extended Events vs SQL Trace im Vergleich – oder warum SQL Trace & Profiler einfach von gestern sind 🙂 Weiter zu XEvents: es gibt keine neuen Prädikate, aber eine Anzahl neuer Maps, was natürlich nicht überrascht bei der Menge neuer Events. Und hier ist die Liste der neuen Extended Events: | The number of Extended Events increased from 625 in SQL Server 2012 (SP1) to 870 in SQL Server 2014 (RTM). That makes 245 new events! – Plenty of opportunities to look into internals 🙂 recovery_incremental_checkpoint into recovery_indirect_checkpoint and hekaton_slow_param_passing into natively_compiled_proc_slow_parameter_passing Yes, you read correctly. There have already been a couple of events for the new XTP engine within SQL Server 2012. It’s quite common that you can find bits of future developments within the current release. By the way: SQL Trace has not been touched by the slightest bit. The number of SQL Trace events stays at 180 since SQL Server 2008. – here you find an overview of the number of Extended Events vs SQL Trace events in the various SQL Server versions: Comparing Extended Events vs SQL Trace – or why SQL Trace & Profiler are just a thing of the past 🙂 Continuing with XEvents: There are no new predicates, but a couple more maps, which is of course not surprisingly considering the amount of new events. And here is the list of all new extended events: |
| Package name | Event name | Description |
| qds | query_store_async_shutdown_failed | Fired when query store encounters an error during async query store shutdown |
| qds | query_store_background_cleanup_task_failed | Fired if the background task for cleanup of QDS stale data is not completed successfully |
| qds | query_store_background_task_creation_failed | Fired if the background task for QDS data persistence could not be created |
| qds | query_store_background_task_initialization_failed | Fired if the background task for QDS data persistence could not be initialized |
| qds | query_store_background_task_persist_failed | Fired if the background task for QDS data persistence is not completed successfully |
| qds | query_store_begin_persist_runtime_stat | Fired immediately before current runtime statistics for a query plan is persisted to the database. |
| qds | query_store_bloom_filter_false_positive | Fired if the Bloom filter for QDS statement texts gives a false positive result |
| qds | query_store_check_consistency_init_failed | Fired when check consistency task fails during initialization |
| 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 |
| qds | query_store_db_cleanup__finished | Fired if cleanup of QDS stale data finished for particular database. |
| qds | query_store_db_cleanup__started | Fired if cleanup of QDS stale data started for particular database. |
| qds | query_store_disk_size_check_failed | Fired when a check against Query Store on-disk size limit fails |
| qds | query_store_disk_size_info | Fired when a check against QDS on-disk size is performed |
| qds | query_store_execution_runtime_info | Fired when runtime information is sent to the query store. |
| qds | query_store_execution_runtime_info_discarded | Fired when runtime information sent to the query store is discarded. |
| qds | query_store_execution_runtime_info_evicted | Fired when runtime information sent to the query store is evicted. |
| qds | query_store_flush_failed | Fired when query store failed to flush dirty data |
| qds | query_store_loaded | Fired when query store is loaded |
| 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 |
| qds | query_store_notify_force_failure_failed | Fired when query store failed to notify force failure |
| qds | query_store_persist_task_init_failed | Fired when persist task fails during initialization |
| qds | query_store_plan_forcing_failed | Occurs when forcing of plan from qds fail |
| qds | query_store_plan_persistence_failure | Fired if there's a failure to persist plan |
| qds | query_store_plan_removal | Fired when plan is removed |
| qds | query_store_query_persistence_failure | Fired if there's a failure to persist query |
| qds | query_store_read_write_failed | Fired if the read/write to Query Store internal tables failed |
| qds | query_store_statement_not_found | Fired in case when statement couldn't be found due to race condition or ambiguous user request. |
| qds | query_store_unloaded | Fired when query store is unloaded from memory |
| sqlos | nonpreemptive_long_syncio | record long sync io operation in nonpreemptive worker |
| sqlos | stuck_dispatcher_callback_executed | Stuck dispatcher callback executed |
| sqlos | wait_completed | Occurs when there is a wait completed on a SQLOS controlled resource. Use this event to track wait completion. |
| sqlserver | after_natively_compiled_proc_entry_removal_on_drop | Fired after the procedure cache entry is flushed when dropping a natively compiled procedure. |
| sqlserver | availability_replica_state | Occurs when the Availability Replica is starting or shutting down. |
| sqlserver | before_natively_compiled_proc_entry_removal_on_drop | Fired before the procedure cache entry is flushed when dropping a natively compiled procedure. |
| sqlserver | before_redo_lsn_update | Occurs just prior to the update of the EOL LSN |
| sqlserver | buffer_pool_eviction_thresholds_recalculated | Lazywriter and/or worker clock has wrapped the BUF array and thresholds are re-calculated. |
| sqlserver | buffer_pool_extension_pages_evicted | Page is evicted from the buffer pool extension cache. |
| sqlserver | buffer_pool_extension_pages_read | Page is read from the buffer pool extension cache. |
| sqlserver | buffer_pool_extension_pages_written | Page or contiguous set of pages evicted into the buffer pool extension cache. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| sqlserver | column_store_code_coverage | Code coverage Xevent for columnstore code. |
| sqlserver | column_store_index_build_low_memory | Occurs when Storage Engine detects low memory condition and the rowgroup size is reduced. |
| sqlserver | column_store_index_build_process_segment | Occurs when a segment is processed |
| sqlserver | column_store_index_build_throttle | Shows the statistics of columnstore index build parallelism throttling |
| sqlserver | columnstore_tuple_mover_begin_compress | Occurs when column store tuple mover starts compressing a deltastore. |
| sqlserver | columnstore_tuple_mover_end_compress | Occurs when column store tuple mover is done compressing a deltastore. |
| sqlserver | database_xml_deadlock_report | Produces a deadlock report for a victim, with information scoped to the victim's database. |
| sqlserver | db_lock_acquired_from_cache | Occurs when a DB lock is acquired from the XactWorkspace DB lock cache. |
| sqlserver | db_lock_released_from_cache | Occurs when a DB lock is released from the XactWorkspace DB lock cache. |
| sqlserver | ddl_with_wait_at_low_priority | A DDL statement was executed using the WAIT_AT_LOW_PRIORITY options |
| sqlserver | diag_quantum_end | Occurs when the diag is notified of quantum end. |
| sqlserver | dyn_throttle_checkpoint | Occurs when checkpointing has been dynamically throttled with a new Checkpoint rate. |
| sqlserver | feature_extension | Occurs when received and parses data for a feature in feature extension. |
| 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 |
| sqlserver | file_read_enqueued | File read enqueued |
| sqlserver | file_read_throttled | File read throttled |
| sqlserver | file_write_enqueued | File write enqueued |
| sqlserver | file_write_throttled | File write throttled |
| sqlserver | ghost_cleanup_task_packet_enqueue | A task packet is enqueued |
| sqlserver | ghost_cleanup_task_process_packet | A task packet is dequeued and processed |
| sqlserver | ghost_cleanup_task_process_pages_for_db_packet | Purge the pages that contain ghost records found in a database |
| sqlserver | ghost_cleanup_task_start | Ghost cleanup task start |
| sqlserver | ghost_cleanup_task_suspend | Ghost cleanup task suspend |
| sqlserver | hadr_tds_synchronizer_payload_skip | Hadron Tds Listener Synchronizer skipped a listener payload because there were no changes since the previous payload. |
| sqlserver | lock_request_priority_state | The priority state of a lock request |
| sqlserver | log_cache_write_block | Writing a log block to the log cache |
| sqlserver | metadata_ddl_add_column | Occurs when an ALTER TABLE ADD column operation is updating base index. |
| sqlserver | metadata_ddl_alter_column | Occurs when an ALTER TABLE ALTER column operation is updating base index. |
| sqlserver | metadata_ddl_drop_column | Occurs when an ALTER TABLE DROP column operation is updating base index. |
| sqlserver | mixed_extent_activation | Track mixed extent activation and deactivation operations. |
| sqlserver | mixed_extent_allocation | Track mixed extent allocation operations |
| sqlserver | mixed_extent_deallocation | Track mixed extent deallocation operations. |
| sqlserver | mixed_page_allocation | Track mixed page allocation operations |
| sqlserver | mixed_page_deallocation | Track mixed page allocation operations |
| sqlserver | mixed_page_scan_file | Track the activity of SGAM scans for mixed page allocation |
| sqlserver | mixed_page_scan_page | Track the activity of SGAM scans for mixed page allocation |
| sqlserver | mixed_page_skipextent | Track the activity of SGAM scans for mixed page allocation |
| sqlserver | natively_compiled_proc_execution_started | Fired before a natively compiled procedure is executed. |
| sqlserver | natively_compiled_proc_slow_parameter_passing | Occurs when a Hekaton procedure call dispatch goes to slow parameter passing code path |
| sqlserver | process_killed_by_abort_blockers | A process is killed by an ABORT = BLOCKERS DDL statement |
| sqlserver | query_execution_batch_hash_aggregation_finished | Occurs at the end of batch hash aggregation. |
| sqlserver | query_execution_batch_hash_children_reversed | Occurs each time when hash join reverses build and probe side while processing data spilled to disk. |
| sqlserver | query_execution_batch_hash_join_spilled | Occurs each time when hash join spills some data to disk in batch processing. |
| sqlserver | query_optimizer_estimate_cardinality | Occurs when the query optimizer estimates cardinality on a relational expression. |
| 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. |
| 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 |
| 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 |
| sqlserver | query_store_persist_on_shutdown_failed | Occurs when SQL Server fails to store dirty entries in Query Store on database shutdown. |
| sqlserver | recovery_indirect_checkpoint | Chose to enqueue an indirect checkpoint as we are near our recovery target |
| sqlserver | remove_database_cache | Remove database cache |
| sqlserver | server_max_workers | Occurs when a request enqueue fails because a worker was not guaranteed. |
| sqlserver | session_recoverable_state_change | Occurs when the server determines a state change in term of session recovery on a connectionresilency-enabled connection. |
| sqlserver | sql_transaction_commit_single_phase | Occurs when a sql transaction is committed with single phase commit. |
| sqlserver | xfcb_blob_properties_obtained | Windows Azure Storage blob property is obtained from response header. |
| sqlserver | xfcb_failed_request | Failed to complete a request to Windows Azure Storage. |
| sqlserver | xfcb_header_obtained | Response header is obtained from request to Windows Azure Storage. |
| sqlserver | xfcb_read_complete | Read complete from Windows Azure Storage response. |
| sqlserver | xfcb_request_opened | A request is opened to Windows Azure Storage. |
| sqlserver | xfcb_send_complete | Request send to Windows Azure Storage is complete. |
| sqlserver | xfcb_write_complete | Request send to Windows Azure Storage is complete. |
| sqlserver | xtp_create_procedure | Occurs at start of XTP procedure creation. |
| sqlserver | xtp_create_table | Occurs at start of XTP table creation. |
| sqlserver | xtp_db_page_allocation_allowed | Indicates that page allocations for the database are allowed. |
| sqlserver | xtp_db_page_allocation_disallowed | Indicates that page allocations for the database are disallowed due to memory pressure. |
| sqlserver | xtp_deploy_done | Occurs at completion of XTP object deployment. |
| sqlserver | xtp_matgen | Occurs at start of MAT generation. |
| sqlserver | xtp_offline_checkpoint_scan_start | Fired by XTP offline checkpoint when the checkpoint thread begins. |
| sqlserver | xtp_offline_checkpoint_scan_stop | Fired by XTP offline checkpoint when the checkpoint thread stops. |
| sqlserver | xtp_recover_done | Occurs at completion of log recovery of XTP table. |
| sqlserver | xtp_recover_table | Occurs at start of log recovery of XTP table. |
| sqlserver | xtp_storage_table_create | Occurs at just before the XTP storage table is created. |
| ucs | ucs_connection_rejected_by_proxy_whitelist | After a connection attempt to the UCS proxy endpoint is rejected by whitelist check |
| ucs | ucs_proxy_connect_next_hop | UCS proxy next hop connection |
| ucs | ucs_proxy_receive_proxy_connect_message | UCS proxy receive proxy connect message |
| ucs | ucs_proxy_route_add | UCS proxy route added |
| ucs | ucs_proxy_route_disable | UCS proxy route disabled |
| ucs | ucs_proxy_route_refresh | UCS proxy route refreshed |
| ucs | ucs_proxy_send_proxy_connect_message | UCS proxy send proxy connect message |
| XtpCompile | cgen | Occurs at start of C code generation. |
| XtpCompile | invoke_cl | Occurs prior to the invocation of the C compiler. |
| XtpCompile | mat_export | Occurs at start of MAT export. |
| XtpCompile | pitgen_procs | Occurs at start of PIT generation for procedures. |
| XtpCompile | pitgen_tables | Occurs at start of PIT generation for tables. |
| XtpEngine | after_changestatetx_event | Fires after transaction changes state. |
| XtpEngine | alloctx_event | |
| XtpEngine | attempt_committx_event | Is raised when a transaction is asked to commit. |
| XtpEngine | before_changestatetx_event | Fires before transaction changes state. |
| XtpEngine | dependency_acquiredtx_event | Raised after transaction takes a dependency on another transaction. |
| XtpEngine | endts_acquiredtx_event | Fires after transaction acquires an end timestamp. |
| XtpEngine | gc_base_generation_evaluation | Indicates that an evaluation of updating the GC base generation has been made. |
| XtpEngine | gc_base_generation_updated | Indicates that the oldest active transaction hint used for calculating the GC base generation has been updated. |
| XtpEngine | gc_cycle_completed | Indicates that a GC notification has been enqueued. |
| XtpEngine | gc_notification | Indicates that GC is processing a notification. |
| XtpEngine | redo_single_hk_record | Redo on a HK log record |
| XtpEngine | trace_add_delta_filter_begin | Adding delta filter. |
| XtpEngine | trace_add_duplicate_delta_filter | Adding duplicate delta filte. |
| XtpEngine | trace_adding_tx_filter | Adding tx filter. |
| XtpEngine | trace_begin_close_ckpt_processing | Beginning close checkpoint processing: checkpoint flush fence = $2 ($3 state). |
| XtpEngine | trace_cfd_entry_deleted | Cleaned up data CFD entry for file $2 $3. |
| XtpEngine | trace_cfd_rows_created | Successfully created CFD rows. |
| XtpEngine | trace_cfdtable_dump | CfdTable dump |
| XtpEngine | trace_cfp_handles_opened | Opened CFP handles for {data: $2 delta: $3} in section $4. |
| XtpEngine | trace_cfp_removed_from_freelist | Removed CFP from freelist for destination file. |
| XtpEngine | trace_checkpoint_file_flush | Indicating that a file has started a flush operation. |
| XtpEngine | trace_checkpoint_load_begin | Starting Checkpoint load with checkpoint timestamp=$2. |
| 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). |
| XtpEngine | trace_checksum_validation_succeeded | Checksum validation for Hekaton checkpoint file during backup succeeded. |
| XtpEngine | trace_ckpt_close_begin | Closing checkpoint in active/passive state. |
| XtpEngine | trace_ckpt_close_signaled | Signaling checkpoint close. The checkpoint policy object is flagged to close the current checkpoint |
| XtpEngine | trace_ckpt_closed | Checkpoint closed |
| XtpEngine | trace_ckpt_load_thread_stats | Statistics of the checkpoint load thread. |
| XtpEngine | trace_ckpt_mrt_dump | Mrt dump |
| XtpEngine | trace_ckpt_serialization_state_dump | Checkpoint serialization state dump. |
| XtpEngine | trace_ckpt_stream_io_stats | Io statistics for this particular stream. |
| XtpEngine | trace_close_file_log_rec_created | Successfully created close file log record. |
| XtpEngine | trace_data_file_pages_txs | This event gives the number of pages and the transaction range for a data file. |
| XtpEngine | trace_data_from_page_deserialized | Deserialized data from page $2 in file $4. |
| XtpEngine | trace_data_row_modified | Data row modified/deleted. |
| XtpEngine | trace_delete_cfd_rows_begin | Matching MRT not found for the Data CFD. Deleting corresponding CFD Rows. |
| XtpEngine | trace_delete_DeletedObjectTable_row_begin | Deleting row from DeletedObjectTable in the context of transaction: $5. |
| XtpEngine | trace_delete_merged_source_file | Deleting merged source $7 file $5:$6. DeleteLSN = $2:$3:$4. |
| XtpEngine | trace_delete_mrtrow_for_target_begin | Deleting mrt row for target. |
| XtpEngine | trace_delta_entry_skipped | Skipping delta {$3, $4, $5} because it is beyond the snapshot checkpoint: $6. |
| XtpEngine | trace_delta_file_future_count_rows_pages_update | Updating future count pages and count rows for delta file. |
| XtpEngine | trace_delta_file_lastgood_count_rows_pages_update | Updating lastgood count pages and count rows for delta file. |
| 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. |
| XtpEngine | trace_delta_file_processed | Completed processing of Delta file. |
| XtpEngine | trace_delta_file_set_clean_or_dirty | Delta file set clean or dirty. |
| XtpEngine | trace_delta_filter_removed | Removing delta filter from DeltaFilterMap due to transaction filter. |
| XtpEngine | trace_delta_watermark_removed | Removed delta watermark. |
| XtpEngine | trace_delta_watermark_updated | Updated delta watermark row for FileId: $4. |
| XtpEngine | trace_deserialize_chained_records | Info pertaining to the deserialized content of the mrtRecords chain. |
| XtpEngine | trace_deserialize_data_from_page_begin | Deserializing data from page $2 in file $4. |
| XtpEngine | trace_deserialize_source_delta_file_begin | Deserializing source delta file $4: page range [$2, $3). |
| XtpEngine | trace_dump_cfd_row | Dump cfd row |
| XtpEngine | trace_dump_mrt_row | Merge Request |
| 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. |
| XtpEngine | trace_file_skipped | Skipping file $4 due to reason $5. |
| XtpEngine | trace_file_skipped_with_tx_range | Skipping file $5 with TX range { $3 -> $4 } due to MaxTxId == InvalidTxId. |
| XtpEngine | trace_first_page_header_flushed | Flushed first page header for file. |
| 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. |
| XtpEngine | trace_flush_skipped_for_closed_data_file | Skipping flush for data file ('$2') as it is closed. |
| XtpEngine | trace_future_count_pages_update | Updating future count pages. |
| XtpEngine | trace_initial_merge | Doing initial merge for destination $3 at CheckpointTs: $2. |
| XtpEngine | trace_insert_DeletedObjectTable_row_begin | Inserting row to DeletedObjectTable in the context of transaction: $5. |
| XtpEngine | trace_intialize_worker_file_begin | Processing file close. |
| XtpEngine | trace_mark_data_file_closed | Marking the active data file as closed to prevent the offline worker fom flushing them. |
| XtpEngine | trace_merge_cancelled | Merge was cancelled for destination $2. |
| XtpEngine | trace_merge_complete_log_rec_ignored | MergeCompleteLogRecord ignored for destination file $3. |
| XtpEngine | trace_merge_complete_log_rec_processed | Successfully processed MergeCompleteLogRecord. |
| XtpEngine | trace_mrt_dump | Mrt dump. |
| XtpEngine | trace_mrt_row_inplace_update | Mrt row updated in place. |
| XtpEngine | trace_mrtrow_not_found | Could not find row with Destination ID: $2 in MRT table. |
| XtpEngine | trace_new_delta_watermark_inserted | Inserted new delta watermark row for FileId $3. |
| XtpEngine | trace_offline_process_stale_merge_item | Offline processing of stale merge item {$2, $3} Destination $4. |
| XtpEngine | trace_pending_tx | Pending Transaction |
| XtpEngine | trace_populate_storage_array | Populating the storage array. |
| XtpEngine | trace_post_writefile | This event is fired after issuing IO on the proxy. |
| XtpEngine | trace_process_file_close_begin | Processing file close. |
| XtpEngine | trace_process_merge_complete_log_record | Process merge complete log record. |
| XtpEngine | trace_process_merge_request | Process Merge Request |
| XtpEngine | trace_process_source_file | Processing source $4 file $2. |
| XtpEngine | trace_process_target_file | Processing target $4 file $2. |
| XtpEngine | trace_queue_merge_work_item | Queue work item: {$2, $3} $5 - $6 with CheckpointTs as $4. |
| XtpEngine | trace_recovered_existing_file | Recovered exising files files allocated during forward processing that are not already part of the CCB. |
| XtpEngine | trace_resyncing_state_of_file | Resyncing state of file $4 ('$5') post recovery: $2 pages, $3 rows. |
| XtpEngine | trace_serialization_object_cleaned | Cleaned serialization object. |
| XtpEngine | trace_serialize_abort_transaction_begin | Serializing the abort transaction filter to the delta cache corresponding to its own transaction range. |
| XtpEngine | trace_serialize_tx_begin | Serialize TS begin for completing the checkpoint in active state. |
| XtpEngine | trace_serialize_tx_end | Serialize TS end for completing the checkpoint. |
| XtpEngine | trace_serialized_delta_rows_to_file | Serialized delta rows to file. |
| XtpEngine | trace_source_file_load_stats | Load stats for source files in merge. |
| XtpEngine | trace_storage_refreshed_for_file | Storage refreshed for file. |
| XtpEngine | trace_uninitialize_file | uninitializing_file |
| XtpEngine | trace_wrote_delta_watermark | Wrote delta watermark for file: $3, checkpointTs: $2. |
| XtpEngine | waiting_for_dependenciestx_event | Raised when we have explicitly waited for dependencies to clear. |
| XtpEngine | xtp_before_create_log_record | Fired before submitting a request to the host to serialize a non-transactional log record. |
| XtpEngine | xtp_checkpoint_file_flush | Indicates the point at which a given file has been flushed to disk. |
| XtpEngine | xtp_checkpoint_file_flush_complete | Indicates the point at which all in-flight buffers have been flushed to disk. |
| XtpEngine | xtp_checkpoint_file_read | Indicates reading of a file in XTP checkpoint recovery. |
| XtpEngine | xtp_checkpoint_worker_active_log | Indicates that the checkpoint worker has started processing the log records in the active portion of the log. |
| XtpEngine | xtp_checkpoint_worker_started | Indicates that the checkpoint worker has started processing the log records. |
| XtpEngine | xtp_checkpoint_worker_stopped | Indicates that the checkpoint worker has started processing the log records. |
| XtpEngine | xtp_checkpoint_write_io | Indicates that the checkpointing subsystem has issued or completed a write IO. |
| XtpEngine | xtp_complete_checkpoint | Indicates the begin and end of complete checkpoint processing. |
| XtpEngine | xtp_create_log_record | Fires when the XTP engine creates a log record. |
| XtpEngine | xtp_delta_marked_dirty | Indicates that a delete/update was serialized and marked a delta file dirty |
| XtpEngine | xtp_merge_complete_log_record | Indicates merge complete log record is posted to the log. |
| XtpEngine | xtp_merge_log_complete_log_record | Indicates merge log record was interpreted by the offline worker. |
| XtpEngine | xtp_merge_process_log_record | Indicates merge log record was interpreted by the offline worker. |
| XtpEngine | xtp_merge_request_log_record | Indicates merge request log record is posted to the log. |
| XtpEngine | xtp_merge_request_started | Indicates merge request has been picked up by the merge worker thread. |
| XtpEngine | xtp_root_deserialized | Indicates that the load of a checkpoint root is complete. |
| XtpEngine | xtp_root_serialized | Indicates that the write of the checkpoint root is complete. |
| XtpRuntime | bind_md | Occurs prior to binding metadata for a memory optimized table. |
| XtpRuntime | bind_tables | Occurs prior to binding tables for a natively compiled procedure. |
| XtpRuntime | create_table | Occurs prior to creating memory optimized table. |
| XtpRuntime | deserialize_md | Occurs prior to deserializing metadata. |
| XtpRuntime | load_dll | Occurs prior to loading the generated DLL. |
| XtpRuntime | recover_done | Occurs at completion of checkpoint recovery of a memory optimized table. |
| XtpRuntime | recover_table | Occurs at start of checkpoint recovery of a memory optimized table. |
| XtpRuntime | serialize_md | Occurs prior to serializing metadata. |
| XtpRuntime | unload_dll | Occurs prior to unloading the generated DLL. |
Happy tracing,
Andreas
