Skip to content

Instantly share code, notes, and snippets.

@zikato
Last active May 24, 2022 16:55
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save zikato/47068829fc0bb164199447b271860335 to your computer and use it in GitHub Desktop.
Save zikato/47068829fc0bb164199447b271860335 to your computer and use it in GitHub Desktop.
New Extended Events in SQL Server 2022
CREATE TABLE #xe2022 ( [name] nvarchar(256), [description] nvarchar(3072) )
INSERT INTO #xe2022 ([name], [description])
VALUES
( N'certificate_report', N'Certificate info.' ),
( N'azure_active_directory_service_failure', N'Occurs when we encounter a failure in AzureActiveDirectoryService layer, when performing MSODS lookup during Login and Create Login/User workflow.' ),
( N'aad_build_federated_context', N'Occurs when we attempt to build federated context.' ),
( N'aad_signing_key_refresh', N'Occurs when we attempt to refresh signing keys from Azure Active Directory, to update the in-memory cache.' ),
( N'auth_fw_cache_lookup_failure', N'This event is generated when the xodbc cache firewall lookup fails.' ),
( N'auth_fw_cache_lookup_success', N'This event is generated when the xodbc cache firewall lookup succeeds.' ),
( N'connection_attempt_failure_system_error', N'Connection attempt metrics' ),
( N'connection_attempt_failure_user_error', N'Connection attempt user error metrics' ),
( N'connection_attempt_success', N'Connection attempt success metrics' ),
( N'create_acr_cache_store', N'When an Access Check Result cache store is created.' ),
( N'data_retention_cleanup_completed', N'Occurs when cleanup process of table with data retention policy ends.' ),
( N'data_retention_cleanup_exception', N'Occurs cleanup process of table with retention policy fails.' ),
( N'data_retention_cleanup_started', N'Occurs when cleanup process of table with data retention policy starts.' ),
( N'data_retention_cleanup_task_exception', N'Occurs when then background (parent) task for data retention based cleanup fails due to an exception.' ),
( N'data_retention_task_completed', N'Occurs when background task for cleanup of tables with retention policy ends.' ),
( N'data_retention_task_exception', N'Occurs when background task for cleanup of tables with retention policy fails outside of retention cleanup process specific to table.' ),
( N'data_retention_task_started', N'Occurs when background task for cleanup of tables with retention policy starts.' ),
( N'data_virtualization_failed_query', N'Fired when OPENROWSET or query against external table or external file format fails during parsing.' ),
( N'data_virtualization_query', N'Fired on compile for every query targeting external data sources.' ),
( N'db_fw_cache_expire_begin', N'This event is generated when the task that cleans the DB firewall cache begins.' ),
( N'db_fw_cache_expire_end', N'This event is generated when the task that cleans the DB firewall cache ends.' ),
( N'db_fw_cache_lookup_failure', N'This event is generated when the DB firewall lookup fails.' ),
( N'db_fw_cache_lookup_success', N'This event is generated when the DB firewall lookup success.' ),
( N'db_fw_cache_update_begin', N'This event is generated when the task that updates the DB firewall cache begins.' ),
( N'db_fw_cache_update_end', N'This event is generated when the task that updates the DB firewall cache ends.' ),
( N'customer_connection_failure', N'Connection failure metrics' ),
( N'customer_connection_failure_firewall_error', N'Connection blocked by firewall' ),
( N'customer_connection_failure_user_error', N'Connections failed due to user error' ),
( N'customer_connection_success', N'Connection successful metrics' ),
( N'ests_request_attempt', N'Occurs when an ESTS or ESTS-R request is submitted in order to acquire a token for AKV or Storage operations.' ),
( N'exec_plpgsql', N'Shows PLPGSQL statements sent to PostgreSQL server during Exec External Language statement' ),
( N'ext_table_extr_operation', N'External Table Extractor event. Should encapsulate resolving file and schema (and possible initialization).' ),
( N'ascending_leading_column_flipped', N'The sort type of the leading column flipped from/to ascending?' ),
( N'external_rest_endpoint_error_winhttp_calls', N'Fired when a winhttp API call fails without stopping the execution' ),
( N'external_rest_endpoint_summary', N'Fired for each execution of sp_invoke_external_rest_endpoint.' ),
( N'external_table_stats_creation', N'Fires after computing external table stats.' ),
( N'failed_compilation', N'Collect the compilation information for errored out or failed compilations.' ),
( N'fedauth_ddl', N'Occurs when someone executes CREATE USER/LOGIN FROM Windows; ALTER USER/LOGIN WindowsPrincipal WITH NAME; in SAWAv2 and its not a Backslash login/user.' ),
( N'fedauth_execute_as', N'Execute as DDL events for AD Auth user.' ),
( N'fedauth_ticket_service_cache_timer_activity', N'Logged during the routine cleanup of cache containing federated contexts.' ),
( N'fedauth_ticket_service_failure', N'Occurs when we encounter a failure in FedAuthTicketService layer, when authenticating the fedauth ticket/token or when doing group expansion.' ),
( N'fedauth_ticket_service_success', N'Logged during the success of federated authentication, including group expansion if applicable.' ),
( N'fedauth_webtoken', N'Logs some important claim information found in the token.' ),
( N'fedauth_webtoken_failure', N'Occurs when we encounter a failure in FedAuthTicketService layer, when authenticating the fedauth ticket/token or when doing group expansion.' ),
( N'fido_multi_step_ddl_operation', N'FIDO DDL step for multi-step DDL operation.' ),
( N'fulltext_crawl_log', N'Reports fulltext crawl log.' ),
( N'fido_temp_db_events', N'FIDO Temp DB Trace.' ),
( N'fido_temp_table_mapping', N'FIDO temp table name mapping' ),
( N'hyperscale_no_pushdown', N'QP pushdown not available.' ),
( N'kerberos_to_jwt_service_failure', N'Occurs when we encounter error in Kerberos ticket to JSON Web token conversion through ESTS AAD endpoint.' ),
( N'ledger_verification_completed', N'Ledger verification operation completed.' ),
( N'ledger_verification_started', N'Ledger verification operation started.' ),
( N'long_compilation_progress', N'Collect the compilation progress information for long-running compilations.' ),
( N'management_service_operation_failed', N'Management Service operation failed.' ),
( N'management_service_operation_started', N'Management service operation started.' ),
( N'management_service_operation_succeeded', N'Management service operation succeeded.' ),
( N'find_and_kill_tm_blocking_table_drop', N'Find and kill the background tuple mover task if it blocks the drop.' ),
( N'openrowset_bulk_file_resolvement', N'Occurs when updating resolved files within openrowset bulk statement.' ),
( N'openrowset_bulk_schema_inference', N'Occurs during schema inference in openrowset bulk statement.' ),
( N'openrowset_cardinality_query', N'Fires after executing internal sampled cardinality estimation query.' ),
( N'ledger_table_verification_completed', N'Ledger table verification operation completed.' ),
( N'ledger_table_verification_started', N'Ledger table verification operation started.' ),
( N'openrowset_stats_creation', N'Fires after computing openrowset stats.' ),
( N'openrowset_stats_loading', N'Fires after loading openrowset stats.' ),
( N'opt_replay_exception_info', N'Collect exception info about Optimization Replay''s failure.' ),
( N'parameter_sensitive_plan_optimization', N'This event is fired when a query uses Parameter Sensitive Plan (PSP) Optimization feature.' ),
( N'parameter_sensitive_plan_optimization_skipped_reason', N'Occurs when the parameter sensitive plan feature is skipped. Use this event to monitor the reason why parameter sensitive plan optimization is skipped.' ),
( N'parameter_sensitive_plan_testing', N'Fired when parameter sensitive plan is tested.' ),
( N'partition_elimination_mapping', N'Fires when pruned data source is added to the list of reduced sources.' ),
( N'partition_elimination_routine', N'Fires when partition elimination routine gets called.' ),
( N'polaris_background_task_exception', N'Unexpected exceptions during execution of Polaris background task.' ),
( N'polaris_billing_estimated_data_scanned', N'Billing report - Estimated data scanned during query compilation phase.' ),
( N'polaris_billing_exception', N'Unexpected exceptions during data_export or distributed_move operations.' ),
( N'polaris_budget_limit_exception', N'Unexpected exceptions during SQL On-Demand budget limit related operations.' ),
( N'polaris_configuration_background_task', N'Configuration state changes for background tasks.' ),
( N'polaris_configuration_budget_limit_change', N'Configuration changes for SQL On-Demand budget limit.' ),
( N'polaris_configuration_budget_limit_snapshot', N'Daily configuration snapshot for SQL On-Demand budget limit.' ),
( N'polaris_created_in_memory_resource_group', N'Fired when Polaris background tasks resource group is initialized.' ),
( N'polaris_current_state_of_data_processed', N'Reports status about internal query that is calculating current state of data processed in SQL On Demand.' ),
( N'query_optimizer_nullable_scalar_agg_iv_update', N'Occurs when scalar indexed view with nullable aggregates is being created or updated.' ),
( N'query_optimizer_optimize_insert', N'Occurs when the query optimizer checks an optimization of insert is possible.' ),
( N'query_post_execution_stats', N'Occurs after a SQL statement is executed. This event contains stats on query execution and uses lightweight profiling infrastructure but does not have showplan xml. This event is fired only when Query Store is enabled and Query Store is tracking the query.' ),
( N'query_store_hadron_transport_failures', N'When QDS cannot process a message correctly this XEvent is emitted with diagnostic information.' ),
( N'query_with_parameter_sensitivity', N'This event is fired when a query is discovered to have parameter sensitivity. This telemetry will help us in identifying queries that are parameter sensitive and how skewed the columns involved in the query are. This is for internal analysis only.' ),
( N'polaris_metrics_login_rh', N'Fires Resource Health signal after login to Polaris frontend is finished.' ),
( N'private_vdw_client_batch_submitted', N'Fires when query to SQL FE is submitted and log to Pii table.' ),
( N'private_vdw_sql_statement_compiled', N'Fires when a sql statement in SQL FE is compiled and log to Pii table.' ),
( N'private_vdw_sql_statement_starting', N'Fires when a sql statement is started in SQL FE and log to Pii table.' ),
( N'query_abort', N'Indicates that a cancel operation, client-interrupt request, or broken client connection was received, triggering abort.' ),
( N'query_antipattern', N'Occurs when a a query antipattern is present and can potentially affect performance.' ),
( N'resource_governor_classifier_changed', N'Occurs when Resource Governor classifier function is changed.' ),
( N'resource_governor_reconfigure_classifier_details', N'Shows classifier data before and after rg reconfigure.' ),
( N'resource_governor_resource_pool_definition_changed', N'Occurs when resource pool definition changes.' ),
( N'resource_governor_workload_group_definition_changed', N'Occurs when workload group definition changes.' ),
( N'openrowset_stats_stale_detection', N'Fires after algorithm for stale stats detection finishes.' ),
( N'openrowset_table_level_stats', N'Fires after computing openrowset or external table stats on table level.' ),
( N'polaris_failed_to_find_resource_group', N'Fired when Polaris background tasks resource group is not initialized.' ),
( N'security_cache_recreate_login_token', N'Recreate a login token and cache it(for existing sessions) after the security token caches have been invalidated.' ),
( N'security_cache_ring_buffer', N'Security Cache ring buffer telemetry.' ),
( N'security_context_token_cleanup', N'When a security context token is deleted.' ),
( N'sql_syms_publishing', N'Fires during metadata publishing to SyMS.' ),
( N'sql_syms_publishing_exception', N'Fires when metadata publishing to SyMS hits exception.' ),
( N'sql_syms_publishing_http_request', N'Fires on metadata publishing HTTP requests to SyMS.' ),
( N'polaris_metrics_connections', N'Fires after login to Polaris frontend is finished.' ),
( N'session_fedauth_failure', N'Occurs when a session is attempting to set a fed auth token in an unsupported scenario.' ),
( N'shallow_scan_in_view_enabled', N'Indicates that shallow metadata checks are enabled early during view binding, for earlier failure detection.' ),
( N'sp_cloud_update_sys_databases_post_termination_completed', N'Spec proc sp_cloud_update_sys_databases_post_termination completed (with or without error).' ),
( N'spexec_batch_compilation_serialization', N'This event will be emitted when the spexec batch compilation serialization occurs' ),
( N'synapse_link_db_enable', N'Synapse Link enable events' ),
( N'synapse_sql_pool_metrics_login', N'Fires after login to Synapse SQL Pool frontend completes.' ),
( N'suppress_errors', N'Alter statement execution' ),
( N'tsql_feature_usage_tracking', N'Track usage of t-sql features in queries for the database' ),
( N'user_token_cache_hit', N'Successfully retrieved a user token from the cache.' ),
( N'user_token_cache_miss', N'When unable to retrieve a user token from the cache.' ),
( N'user_token_cleanup', N'When a user token is deleted.' ),
( N'vdw_client_batch_cancelled', N'Fires when query to SQL FE is cancelled.' ),
( N'vdw_client_batch_completed', N'Fires when query to SQL FE is completed.' ),
( N'vdw_client_batch_submitted', N'Fires when query to SQL FE is submitted.' ),
( N'vdw_annotations', N'Collect annotations from queries.' ),
( N'vdw_distributed_query_metrics', N'Fired by the VDW backend to report collected metrics when going out of sp_executesql_metrics scope.' ),
( N'vdw_file_format_parser_version_usage', N'Fired by the VDW frontend during resolve operation of parser version for provided format.' ),
( N'vdw_file_level_sampling', N'Fired by the VDW backend instance for OPENROWSET(BULK) queries that use TABLESAMPLE clause.' ),
( N'vdw_sql_statement_compiled', N'Fires when a sql statement in SQL FE is compiled.' ),
( N'vdw_sql_statement_completed', N'Fires when a sql statement is completed in SQL FE.' ),
( N'vdw_sql_statement_fido_transaction', N'SQL FE statement and fido transaction trace.' ),
( N'vdw_sql_statement_starting', N'Fires when a sql statement is started in SQL FE.' ),
( N'vm_msi_access_token_retrieval', N'Request access token for Azure virutal machine MSI.' ),
( N'webtoken_generator_failure', N'Occurs when we encounter a failure during JWT creation with JSONWebTokenGenerator class.' ),
( N'xodbc_cache_get_federated_user_info_cache_bypass', N'Occurs when a federated user cache lookup request bypasses the cache and executes a DB query.' ),
( N'xodbc_cache_get_federated_user_info_failure', N'Occurs when a remote authentication request to logical master failed to query for federated user info.' ),
( N'xodbc_cache_update_federated_user_info_cache_entry', N'Occurs when a federated user, has a name that matches object ID, and the name is updated with the correct value during login.' ),
( N'vdw_logical_file_splits_memo_generation', N'Emits information related to logical file splits after memo generation.' ),
( N'vdw_cetas_drop_ext_table_metadata', N'Fires if the DML part of a CETAS fails in pre-Gen3 Polaris.' ),
( N'vdw_client_background_dopp_stream_operation', N'Fires when a operation on the background thread for VDW dopp streaming was requested.' ),
( N'vdw_client_background_write_dopp_stream_response', N'Fires when SQL FE writes dopp stream response to local cache dictionary.' ),
( N'data_export_profile', N'Reports aggregated stats about data exported to an external file. Distinct event per each file and each processing thread.' ),
( N'vdw_prepare_query_completion', N'Fired by the VDW SQL FE when preparing query completed notification submission.' ),
( N'vdw_query_completion_rpc', N'Fired by the VDW SQL FE to notify ES FE that the query is completed.' ),
( N'vdw_sp_drop_storage_location', N'Fired by the VDW frontend from stored procedure sp_drop_storage_location.' ),
( N'xstore_aad_token_failure', N'Occurs when we encounter a failure in XStoreAADTokenCache layer, when performing refresh to the AAD token' ),
( N'xstore_create_physical_file', N'Creating physical XStore file has been attempted with the options below.' ),
( N'xstore_create_physical_file_sensitive', N'Creating physical XStore file has been attempted with the options below. Contains sensitive data' ),
( N'xstore_io_throttling_storage_account_removed', N'XStore I/O throttling handler has removed storage account.' ),
( N'xtp_db_page_allocation_state_change', N'Indicates that the state of page allocations for the database is changed, from allowed to disallowed or vice versa.' ),
( N'xtp_open_existing_database', N'Indicates the XTP open existing database progress.' ),
( N'wildcard_expansion', N'Fired by the SQL frontend when wildcard expansion was requested.' ),
( N'worker_migration_stats', N'Shows the number of worker migrations for a particular task.' ),
( N'xact_outcome_list_cleanup_completed', N'XEvent used to indicate that outcome list cleanup (via specproc) has completed.' ),
( N'xact_outcome_list_cleanup_performed', N'XEvent used to indicate that outcome list cleanup was performed on a database.' ),
( N'xact_outcome_list_cleanup_starting', N'XEvent used to indicate that outcome list cleanup (via specproc) is starting.' ),
( N'xact_outcome_status', N'Periodically fired XEvent to indicate current count of xact outcomes in the outcome list.' ),
( N'xfile_storage_file_operation_metrics', N'Storage file operation metrics.' ),
( N'xfile_stream_reader_operation_metrics', N'Stream reader operation metrics.' ),
( N'xio_lease_action', N'Lease request to Windows Azure Storage.' ),
( N'xio_lease_action_sensitive', N'Lease request to Windows Azure Storage. Contains PII data.' ),
( N'xio_read_complete_sensitive', N'Read complete from Windows Azure Storage response. Sensitive data.' ),
( N'xio_request_reissue_finished_first', N'Event fired when request which was reissued finishes before original request.' ),
( N'xio_request_reissue_read_stats', N'Contains information about data read with reissuing of long requests.' ),
( N'xio_request_retry_finished_first', N'Request that was part of parallel retry due to long request duration time finished first.' ),
( N'xio_request_retry_finished_first_sensitive', N'Request that was part of parallel retry due to long request duration time finished first. Contains PII data.' ),
( N'xml_compression_telemetry', N'Xml Compression telemetry collected per query' ),
( N'volume_entity_stats', N'latency histogram for volume entity.' ),
( N'volume_traffic_policer_stats', N'Reports stats on conforming and non-conforming IOs in terms of IOPS and Bandwidth governances' ),
( N'wait_for_redo_lsn_to_catchup_pagestats', N'In every 5 minutes interval,stats data of RedoPageType and RedoLocation is emitted' ),
( N'wait_for_redo_lsn_to_catchup_stats', N'In every 5 minutes interval,stats data of waitforlsn is emitted' ),
( N'wb_checkpoint_failed_ios', N'Logs failed ios during WB checkpoint.' ),
( N'wb_checkpoint_metadata', N'Traces foreign log state for write behind checkpoint progress.' ),
( N'wb_checkpoint_progress', N'Monitors progress of write behind checkpoint.' ),
( N'wb_checkpoint_report_file_size', N'This xevent is fired when rbpex write behind checkpoint handle physical file growth.' ),
( N'wb_checkpoint_skip_file_growth', N'This xevent is fired when rbpex write behind checkpoint abort deferred physical file growth.' ),
( N'wb_recovery_progress', N'Write behind recovery stats.' ),
( N'wb_throttle_info', N'Monitors info determining write behind throttling.' ),
( N'vdw_submit_query_completion', N'Fired by the VDW SQL FE when query completed notification submission occures.' ),
( N'vdw_wildcard_expansion', N'Fired by the VDW frontend when wildcard expansion was requested.' ),
( N'vdw_wildcard_list_directory_stats', N'Fired by the VDW frontend when wildcard expansion was requested. Contains information about each list directory call in WCE.' ),
( N'version_cleaner_worker_stealing', N'Version cleaner worker stealing.' ),
( N'vldb_geodr_applied_throttling', N'' ),
( N'vldb_geodr_throttling_stat', N'' ),
( N'vdw_logical_file_splits', N'Emits information related to logical file splits.' ),
( N'vdw_backend_cancel_query_feedback', N'Fired by the VDW backend when query feedback submission is canceled.' ),
( N'vdw_backend_prepare_query_feedback', N'Fired by the VDW backend when preparing query feedback submission.' ),
( N'vdw_backend_query_feedback_rpc', N'Fired by the VDW backend to report query feedback status.' ),
( N'vdw_backend_submit_query_feedback', N'Fired by the VDW backend when query feedback submission occures.' ),
( N'vdw_cancel_query_completion', N'Fired by the VDW SQL FE when query completed notification submission is canceled.' ),
( N'vdw_client_cancel_dopp_request', N'Fires when request cancelation for VDW dopp streaming was requested.' ),
( N'vdw_client_prepare_dopp_request', N'Fires when service discovery for VDW dopp streaming api was requested.' ),
( N'vdw_client_submit_dopp_request', N'Fires when request submission for VDW dopp streaming was requested.' ),
( N'vdw_distributed_computation_error', N'Fires when returning error or warning reported by code related to VDW distributed computation.' ),
( N'vdw_distributed_query_cleanup_exception', N'Unexpected exception during cleanup of VDW distributed operator.' ),
( N'user_tx_page_cleanup_progress', N'Emit various data about user transaction page cleanup progress.' ),
( N'user_tx_page_cleanup_stats', N'Emit statistics related to user transaction page cleanup hash table.' ),
( N'synapse_link_addfilesnapshotendentry', N'Called after a data export file is added to snapshot_end manifest entry' ),
( N'synapse_link_buffering_row_data', N'Synapse Link Buffering Row Data' ),
( N'synapse_link_capture_throttling', N'Synapse Link Capture Cycles Throttling' ),
( N'synapse_sql_pool_metrics_query', N'Fires after Synapse SQL Pool query finishes.' ),
( N'tail_log_cache_buffer_refcounter_change', N'Occurs along with a tail log cache buffer''s reference counter being incremented or decremented.' ),
( N'tail_log_cache_miss', N'Occurs when a log consumer attempts to lookup a block from the tail log cache but fails to find it.' ),
( N'toad_cell_tuning_metrics', N'Toad cell tuning metrics event.' ),
( N'toad_delete_bitmap_tuning_metrics', N'Toad delete bitmap tuning metrics event.' ),
( N'toad_delta_force_tuning_metrics', N'Toad delta force tuning metrics event.' ),
( N'toad_discovery', N'Toad work discovery event.' ),
( N'toad_exception', N'Exception channel for the background toad tasks.' ),
( N'toad_memory_pressure_notification', N'Toad memory pressure notification event.' ),
( N'toad_memory_semaphore_request', N'Toad memory semaphore request event.' ),
( N'toad_occi_tuning_metrics', N'Toad OCCI tuning metrics event.' ),
( N'toad_star_cell_tuning_metrics', N'Toad star cell tuning metrics event.' ),
( N'toad_tuning_zone_circuit_breaker', N'Toad tuning zone circuit breaker event.' ),
( N'toad_work_execution', N'Toad work execution event.' ),
( N'synapse_link_end_data_snapshot', N'Called in LandingZoneParquetExporter at the end of successful data snapshot functionality' ),
( N'synapse_link_error', N'Error events from Synapse Link components' ),
( N'synapse_link_info', N'Synapse Link info' ),
( N'synapse_link_library', N'Synapse Link Call Back Events' ),
( N'synapse_link_perf', N'Synapse Link performance' ),
( N'synapse_link_scheduler', N'Synapse Link Scheduler Information' ),
( N'synapse_link_start_data_snapshot', N'Called in LandingZoneParquetExporter at the beginning of data snapshot functionality' ),
( N'synapse_link_totalsnapshotcount', N'Called when all files have been added a snapshot end entry' ),
( N'synapse_link_trace', N'Synapse Link trace' ),
( N'spills_to_tempdb', N'Spills to tempdb, which were caused by any query. Only fires off when spills exceeds (predefined threshold * MaxTempdbDbMaxSizeinMB)' ),
( N'set_partial_log_backup_checkpoint_lsn_to_null', N'Used for setting the partialLogBackupCkptLsn to NullLSN' ),
( N'polaris_metrics_data_processed', N'Fires after data is processed.' ),
( N'sr_tx_count', N'XEvent that indicates a Serializable Transaction info' ),
( N'srb_backup_sync_message', N'Backup Sync messages sent during backup on secondary replica.' ),
( N'srb_clear_diff_map_succeeded', N'Backup Info message sent from primary to secondary to signal that diff map was cleared and provide a new checkpoint LSN.' ),
( N'srb_commit_diff_backup', N'Backup Info message sent from secondary to primary to signal that diff backup finished and that lock should be released on primary.' ),
( N'srb_commit_full_backup', N'Backup Info message sent from secondary to primary to signal that full backup finished and to provide neccessary information.' ),
( N'srb_database_diff_backup_start_ack', N'Backup Info message sent from primary to secondary to acknowledge diff backup request.' ),
( N'srb_database_full_backup_start_ack', N'Backup Info message sent from primary to secondary to acknowledge full backup request.' ),
( N'srb_force_checkpoint_succeeded', N'Backup Info message sent from primary to secondary to signal that checkpoint was executed and provide a new checkpoint LSN.' ),
( N'srb_log_backup_info', N'Backup Info messages sent during log backup on secondary replica.' ),
( N'stale_user_tx_page_cleanup_element_removal', N'Telemetry regarding how many stale elements were removed from the user transaction page cleanup hash table by version cleaner.' ),
( N'startup_phase_telemetry', N'Startup phase telemetry details .' ),
( N'storage_engine_performance_counters', N'Performance counter data produced by StoragePerfCountersRecord function' ),
( N'summarized_oom_snapshot', N'Out-of-memory (OOM) summary snapshot' ),
( N'send_segment_io_data', N'send segment access information' ),
( N'send_segment_io_data_v2', N'# of IOs on a segment (simulated).' ),
( N'send_segment_io_data_v2_heartbeat', N'Whether segment IOs are being tracked (simulated).' ),
( N'polaris_internal_metrics_distributed_query_history_tables', N'Fires after write to distributed query history tables fail.' ),
( N'polaris_internal_tsql_query_status', N'Reports status about Polaris internal T-SQL query.' ),
( N'opt_replay_delete_ors_allocated_memory', N'Fired when the memory allocated for replay script (ORS) is successfully deleted.' ),
( N'restore_rollfoward_complete', N'RestoreRedoMachine::Rollforward function telemetry details.' ),
( N'resumable_index_auto_abort', N'Occurs when the resumable index has been paused for longer than the auto abort threshold.' ),
( N'rowgroup_consolidation_append_blob', N'Append columnstore data to existing rowgroup blob' ),
( N'rowgroup_consolidation_copy_blob', N'Copy the existing Roco file to another blob, update columnstore metadata and cache entries with new blob id' ),
( N'rowgroup_consolidation_create_and_write_rowgroup_blob', N'Flush a consolidated rowgroup blob' ),
( N'rowgroup_consolidation_flush_rowgroup_blob_fail', N'Attempted to flush a chunk of columnstore rowgroup data to block blob and failed.' ),
( N'query_ce_feedback_telemetry', N'Reports query feedback information' ),
( N'query_feedback_analysis', N'Reports query feedback analysis details' ),
( N'query_feedback_validation', N'Reports query feedback pre validation data' ),
( N'polaris_metrics_queries', N'Fires after distributed query result is returned.' ),
( N'polaris_metrics_query_rh', N'Fires Resource Health signal after distributed query on Polaris finishes.' ),
( N'polaris_rejected_rows_aggregations', N'Reports status of rejected rows aggregation processing' ),
( N'polaris_rejected_rows_exception', N'Unexpected exceptions during rejected rows processing.' ),
( N'polaris_rejected_rows_exception_details', N'Details of overwritten query response exception' ),
( N'polaris_unexpected_switch_value', N'Is fired when unexpected switch value is encountered.' ),
( N'polaris_write_distributed_query_history_exception', N'Unexpected exceptions during data ingestion into polaris history tables' ),
( N'predict_error', N'PREDICT error' ),
( N'predict_onnx_log', N'ONNX log message' ),
( N'rbpex_compute_zone_hotness', N'' ),
( N'rbpex_deferring_remote_io', N'RBPEX deferred remote I/O due to pending file growth.' ),
( N'rbpex_eviction_run_profile', N'' ),
( N'rbpex_force_copy_pages_failure', N'Event to force copy pages failure during RBPEX seeding.' ),
( N'rbpex_grow_fail_reporting_max_size', N'RBPEX grow has been failing continuously and now we are reporting max RBPEX file size as part of IDSU.' ),
( N'rbpex_incremental_grow', N'Tracks rbpex grow when utilization exceeds threshold.' ),
( N'rbpex_is_file_growth_supported', N'Occurs when RBPEX/WB checks if file growth can be deferred' ),
( N'rbpex_parallel_seeding_timing', N'Rbpex parallel seeding timing info.' ),
( N'rbpex_pause_exclusive_phase', N'Rbpex pause segment functionality test, exclusive phase wait.' ),
( N'rbpex_peer_seed', N'Records RBPEX peer seed activity.' ),
( N'rbpex_physical_grow', N'Rbpex physical growth succeeded' ),
( N'rbpex_physical_shrink', N'Rbpex Physical shrink not allowed to proceed' ),
( N'rbpex_seed_thread_start', N'Event to report start of seed thread.' ),
( N'rbpex_seeding_catchup_retry', N'Fired before attempting to retry segment catchup operation from blob during rbpex seeding.' ),
( N'rbpex_seeding_segment_copy_retry', N'Fired before attempting to retry segment copy operation from snapshot during rbpex seeding.' ),
( N'rbpex_seeding_snapshot_created', N'Fired when a snapshot is created for page server seeding.' ),
( N'rbpex_seg_seed_copy_page', N'Event to report dirty pages being copied during seeding.' ),
( N'rbpex_shrinkmgr_grow', N'Records RBPEX growth activity.' ),
( N'rbpex_shrinkmgr_shrink', N'Rbpex shrink info.' ),
( N'rbpex_shrinkmgr_shrink_assert_error', N'Rbpex shrink assertions errors' ),
( N'rbpex_shrinkmgr_shrink_started', N'' ),
( N'reclaim_dropped_column_space_begin', N'Occurs when reclaim space for dropped LOB columns has started.' ),
( N'reclaim_dropped_column_space_end', N'Occurs when reclaim space for dropped LOB columns has finished.' ),
( N'recovery_force_flush_checkpoint', N'Dirty pages will be written to advance the oldest page LSN and catch up with the target log distance. This event is only applicable to databases where indirect checkpoint is enabled.' ),
( N'recovery_indirect_checkpoint_end', N'Checkpoint has ended. This event is only applicable to databases where indirect checkpoint is enabled.' ),
( N'remove_remote_file_redo_operation_completed', N'RemoveFileFromRemoteReplicas Operation Completed' ),
( N'remove_remote_file_redo_operation_failed', N'RemoveFileFromRemoteReplicas Operation Failed' ),
( N'remove_remote_file_redo_operation_started', N'RemoveFileFromRemoteReplicas Operation Started' ),
( N'repl_error', N'This event will be fired from replication code when an error occurs.' ),
( N'repl_logscan_session', N'This event captures log scan operations telemetry through Replication and Change Data Capture (CDC) phases 1 through 7.Returns session transactions as they are processed.' ),
( N'repl_metadata_change', N'This event will be fired from replication code on changes related to replication metadata.' ),
( N'repldone_session', N'ReplDone Information' ),
( N'required_memory_grant_too_big', N'Keep the related data when the requested memory is greater than the available memory (right before throwing an exception)' ),
( N'polaris_error_classification_failed', N'Is fired when ErrorClassificationOverrideRules setting is invalid.' ),
( N'polaris_exception_query_not_billed', N'Unexpected exceptions during billing related system operations.' ),
( N'polaris_executed_requests_history', N'' ),
( N'polaris_executed_requests_history_cleanup', N'Reports status about retention cleanup on master.sys.polaris_executed_requests_history and master.sys.polaris_executed_requests_text tables.' ),
( N'polaris_executed_requests_retention_period', N'Reports retention period used for master.sys.polaris_executed_requests_history and master.sys.polaris_executed_requests_text tables.' ),
( N'polaris_billing_exception_managed_data', N'Unexpected billing exception.' ),
( N'polaris_billing_native_shuffle_data_moved', N'Billing report - Reports data moved by native shuffle.' ),
( N'polaris_billing_verification_distributed_queries_executed', N'Fires when VDW distributed computation was executed. Should be used only for billing verification.' ),
( N'polaris_billing_data_scanned', N'Billing report - data size read through external extractors. Distinct event per each file and each processing thread.' ),
( N'polaris_billing_data_scanned_csv', N'Billing report - data size read through native CSV reader. Distinct event per each file.' ),
( N'polaris_billing_data_written', N'Billing report - Reports data written.' ),
( N'polaris_billing_distributed_queries_executed', N'Fires when VDW distributed computation was executed.' ),
( N'pesto_rename_sbs_blob_fail', N'Failed to update the sbs blob id with new GUID during the Pesto consoliate rowgroup copy blob ' ),
( N'pfs_file_share_stats', N'PFS file share stats collected periodically from GetShareStats api' ),
( N'pfs_observed_transition_to_secondary', N'Emitted when observed DB replica role transition during evaluation period for PFS dynamic scaling' ),
( N'pfs_rest_action', N'PFS REST API call action.' ),
( N'pfs_scaling_signal', N'Output signal for PFS Dynamic Scaling' ),
( N'platform_callback', N'Fired by the VDW sqlserver instances when the platform layer (ServiceFabric) invokes different callbacks (like instance change role).' ),
( N'override_max_supported_db_version_to_1', N'Used for mock downgrade max supported db version to 1' ),
( N'page_compression_cache_init_complete', N'Occurs after page compression cache is initialized during decompression' ),
( N'page_covering_rbpex_repair', N'Tracks the repair of pages in covering RBPEX' ),
( N'page_encryption_prewrite_complete', N'Occurs after page has been compressed in-memory before being flushed' ),
( N'openrowset_stats_row_reading_failed', N'Fires when reading of openrowset stats/cardinality row from the openrowset stats table fails.' ),
( N'ledger_transaction_count', N'Ledger transaction' ),
( N'openrowset_stats_cleanup', N'Fires at the start and after stats table cleanup finishes.' ),
( N'openrowset_stats_cleanup_all', N'Fires at the start and after stats table truncation finishes.' ),
( N'foreign_log_apply_suspended', N'Indicates that the foreign log apply thread is suspended with a trace flag.' ),
( N'foreign_redo_hash', N'' ),
( N'foreign_redo_old_bsn_corruption', N'' ),
( N'foreign_redo_rbpex_page_dirtied', N'Fired when a page from covering RBPEX is to be dirtied during foreign redo.' ),
( N'maxdop_feedback_received', N'' ),
( N'memory_grant_feedback_percentile_grant', N'Occurs at intervals when percentile grant is enabled' ),
( N'memory_grant_feedback_persistence_invalid', N'Occurs when persisted memory grant feedback can not be used due to inconsistency with current plan.' ),
( N'memory_grant_feedback_persistence_update', N'Occurs when memory grant feedback is persisted to QDS. ' ),
( N'metadata_change', N'Tracking metadata change which may affect query performance.' ),
( N'modify_file_name', N'Occurs when the file manager started to modify a database file name.' ),
( N'modify_file_operation', N'Occurs when the file manager modified the property of a database file.' ),
( N'native_shuffle_nullability_mismatch', N'Reports a NULL value in a native shuffle QTable column declared with NOT NULL in the schema.' ),
( N'oiblob_cleanup_begin_batch', N'Occurs when cleanup for a single batch has started for online index build with LOBs.' ),
( N'oiblob_cleanup_end_batch', N'Occurs when cleanup for a single batch has finished for online index build with LOBs.' ),
( N'online_index_ddl_tx_info', N'Log record- and transaction-related info about the non-CTR ONLINE_INDEX_DDL transaction.' ),
( N'ledger_view_query_count', N'Ledger view query' ),
( N'lock_manager_init', N'Stats during init of lock manager' ),
( N'locking_qp_stats', N'Emit QP statistics related to locking.' ),
( N'locking_stats', N'Emit statistics related to locking.' ),
( N'log_block_header_failover_info', N'Print failover info stored in log block header during LC flush' ),
( N'log_lease_skip_same_vlf', N'Indicates that the request to the log leasing service for the same vlf is skipped' ),
( N'log_pool_cache_miss_aggregation', N'Aggregated outout of log pool miss.' ),
( N'log_production_stats_mdm', N'Aggregated statistics about log production, emitted periodically.' ),
( N'log_redo_stats', N'' ),
( N'large_non_adr_transactions', N'The number of records and/or bytes of log for a non-ADR transaction exceeds the current threshold.' ),
( N'ledger_digest_upload_failed', N'Uploading a digest of the database ledger failed.' ),
( N'ledger_digest_upload_failed_mdm', N'Emit a metric when a ledger digest fails to be uploaded.' ),
( N'ledger_digest_upload_success', N'Uploading a digest of the database ledger succeeded.' ),
( N'ledger_digest_upload_success_mdm', N'Emit a metric when a ledger digest is successfully uploaded.' ),
( N'ledger_generate_digest', N'Ledger digest generated' ),
( N'ledger_settings', N'Ledger settings' ),
( N'hyperscale_pushdown_aggregated_stats', N'Aggregated stats for a single execution of a single QP pushdown operator.' ),
( N'hyperscale_pushdown_completed', N'QP pushdown queue completed.' ),
( N'hyperscale_pushdown_memory_change', N'QP pushdown memory reservation change.' ),
( N'hyperscale_pushdown_request_completed', N'QP pushdown request completed.' ),
( N'hyperscale_pushdown_request_starting', N'QP pushdown request starting.' ),
( N'hyperscale_pushdown_resource_pool_failure', N'Failures related to obtaining resource pool for pushdown queries' ),
( N'hyperscale_pushdown_skipped', N'QP pushdown skipped at runtime.' ),
( N'hyperscale_pushdown_starting', N'QP pushdown queue created.' ),
( N'hyperscale_pushdown_stats', N'QP pushdown statistics that are periodically emitted.' ),
( N'iam_page_range_cache_stats', N'IAM Page range cache stats' ),
( N'increment_paused_write_ios_count', N'Increments the number of write IOs paused.' ),
( N'index_corruption_detected', N'Reports names,id of related database when index corruption is detected' ),
( N'index_stats_inconsistency_event', N'Indicate we did some repair logic for the index stats cache' ),
( N'fido_tm_transaction_abort', N'FIDO TM abort trace.' ),
( N'fido_tm_transaction_begin', N'FIDO TM begin trace.' ),
( N'fido_tm_transaction_commit', N'FIDO TM commit trace.' ),
( N'fido_transaction', N'FIDO transaction trace.' ),
( N'fido_transaction_message', N'FIDO TM log trace.' ),
( N'file_added_in_database', N'Occurs when a database file is added into the database segment.' ),
( N'global_query_extractor_begin', N'Global Query extractor execution start.' ),
( N'global_query_extractor_cancel', N'Global Query extractor execution canceled.' ),
( N'global_query_extractor_end', N'Global Query extractor execution completed successfully.' ),
( N'global_query_extractor_fail', N'Global Query extractor execution failed with error.' ),
( N'hadr_chimera_send_request_to_MS_long_retry', N'Alert for long retries when sending notification request to control ring' ),
( N'hadr_db_manager_qds_msg', N'QDS messages sent between replicas.' ),
( N'hadr_hybrid_subscription_auth_failure', N'Log ucs subscription authentication failure for hybrid link.' ),
( N'hadr_hybrid_subscription_auth_long_retry', N'Log ucs subscription authentication retry info for hybrid link.' ),
( N'hadr_hybrid_subscription_auth_success', N'Log ucs subscription authentication success for hybrid link.' ),
( N'hadr_transport_dump_extended_recovery_forks_message', N'Use this event to help trace HADR extended recovery forks messages.' ),
( N'hadr_undo_of_redo_pages_processing_stats', N'Pages processing stats' ),
( N'hadr_undo_of_redo_parallel_page_requesting_first_missing_page', N'First missing page id in parallel page request buffer.' ),
( N'hadr_undo_of_redo_parallel_page_requesting_notification', N'Requesting page in parallel for Undo of Redo enabled.' ),
( N'hardware_error_rbpex_invalidate_page', N'Tracks invalidating rbpex page after detecting a hardware error on the page.' ),
( N'heap_access_pattern', N'Emit statistics related to heap access patterns.' ),
( N'hotpagetracker_bucket_aggregation_ended', N'Indicates that aggregating hit counts into the snapshot bucket at given position in the bucket list ended.' ),
( N'hotpagetracker_bucket_aggregation_started', N'Indicates that aggregating hit counts into the snapshot bucket at given position in the bucket list started.' ),
( N'hotpagetracker_page_list_receive_failed', N'Indicates that the new primary compute has NOT received the list of hot pages it requested from a page server.' ),
( N'hotpagetracker_page_list_receive_succeeded', N'Indicates that the new primary compute has received the list of hot pages it requested from a page server.' ),
( N'hotpagetracker_pageseed_candidate', N'A page that the new primary compute will seed into its RBPEX for a given file.' ),
( N'hotpagetracker_pageseed_failed', N'Indicates that the new primary compute has failed to queue all the hot pages to seed onto its RBPEX for a given file.' ),
( N'hotpagetracker_pageseed_queued', N'Indicates that the new primary compute has queued all the hot pages to seed onto its RBPEX for a given file.' ),
( N'fido_rm_transaction_abort', N'FIDO RM abort trace.' ),
( N'fido_rm_transaction_begin', N'FIDO RM begin trace.' ),
( N'fido_rm_transaction_commit', N'FIDO RM commit trace.' ),
( N'fido_rowgroup_lineage', N'Fido xevent to establish rowgroup lineage.' ),
( N'fido_scanner_end_database', N'Fido scanner end database scan.' ),
( N'fido_scanner_percent_complete', N'Fido scanner percent completed.' ),
( N'fido_scanner_start_database', N'Fido scanner start database scan.' ),
( N'fido_scanner_trace_print', N'Fido scanner debug trace.' ),
( N'ffv_obtained_validation_bitmap', N'Foreign file validator obtained a copy of the validation bitmap as part of establishing a new snapshot pair.' ),
( N'fido_clone_update_filter_ctx_on_dir_change', N'FIDO clone trace during scan' ),
( N'fido_fcs_md_read_ahead_perf_metric', N'FIDO Fcs metadata read ahead perf metric.' ),
( N'fido_glm_rowset_cleanup', N'FIDO GLM ROwset cleanup' ),
( N'fido_glm_rowset_operation', N'FIDO GLM Rowset operation.' ),
( N'fido_glm_rowset_serialization_error', N'FIDO Metadata Rowset update error.' ),
( N'fido_lock_manager_message', N'FIDO LM log trace.' ),
( N'failure_injection_during_backup_device_restoring', N'Used for testing restore hang if an exception is thrown on one backup stream but other streams are marked as completed' ),
( N'extractor_scan_memory_grant', N'Summary of an Exteranl Extractor operation memory grant.' ),
( N'extractor_scan_summary', N'Summary of an Exteranl Extractor operation.' ),
( N'external_runtime_execution_stats', N'Publishes consolidated stats collected during external endpoint invocation' ),
( N'async_read_page_count_bucket', N'Emit page counts map for rbio async read requests.' ),
( N'external_policy_pulltask_finished', N'XEvent for policy pull finish' ),
( N'external_policy_pulltask_retries', N'XEvent for policy pull retries diagnostics' ),
( N'external_policy_pulltask_started', N'XEvent for policy pull start' ),
( N'deadlock_callstack', N'Print callstack of thread within deadlock graph.' ),
( N'deferred_au_deallocation_to_next_run', N'Dropping of allocation unti marked for deferred drop is delayed to the next run.' ),
( N'delta_migration_failure', N'Delta Migration Failure XEvents' ),
( N'delta_migration_information', N'Delta Migration Informational XEvents' ),
( N'delta_migration_task_end', N'Delta Migration Task End XEvents' ),
( N'delta_migration_task_start', N'Delta Migration Task Start XEvents' ),
( N'dop_feedback_eligible_query', N'Reports when a query plan becomes eligible for dop feedback' ),
( N'dop_feedback_provided', N'Reports DOP feedback provided data for a query' ),
( N'dop_feedback_reverted', N'This reports when a DOP feedback is reverted' ),
( N'dop_feedback_validation', N'Reports when the validation occurs for the query runtime stats against baseline or previous feedback stats' ),
( N'drop_file_committed', N'Occurs when drop file action is committed.' ),
( N'drop_file_prepared', N'Occurs when the file is prepared to be dropped.' ),
( N'drop_file_rollback', N'Occurs when drop file action is rolled back.' ),
( N'dw_backup_app_lock_end', N'DW Backup App Lock End XEvents' ),
( N'dw_backup_app_lock_start', N'DW Backup App Lock Begin XEvents' ),
( N'dw_large_text_store', N'DW large text store for fragmented text blobs.' ),
( N'database_file_growing', N'Occurs when any of the data or log files for a database is about to grow.' ),
( N'database_recovery_complete', N'Occurs when database recovery has completed.' ),
( N'database_xml_deadlock_report_mdm', N'Emit a metric when a deadlock report for a victim is produced.' ),
( N'create_file_tracing', N'Tracing during the different steps of FileCreation.' ),
( N'csv_column_statistics', N'Aggregate details of processing a column for one file.' ),
( N'csv_decompression_statistics', N'Decompression time and memory utilized if the input file is compressed.' ),
( N'csv_input_file', N'Details of a CSV input file processed by OpenRowset' ),
( N'csv_rejected_rows', N'Aggregate details for a error type of rejected rows.' ),
( N'csv_row_statistics', N'Aggregate details of processing rows for one file.' ),
( N'csv_shallow_parse', N'Aggregate details for shallow parsing logic used in calculating file splits.' ),
( N'cpu_vectorization_levels', N'Event containing details of CPU vectorization level(s).' ),
( N'autostats_update_async_low_priority_status', N'This XEvent is fired when auto asynchronous statistics is triggered in low priority mode.' ),
( N'autostats_update_blocking_readers', N'This XEvent is fired to reproduce a blocking scenario when an auto statistics update thread waits to acquire a Sch-M lock on stats metadata object which subsequently blocks readers (select queries on that table for instance). This XEvent is used primarily for unit testing.' ),
( N'add_file_in_master', N'Occurs when the file manager added file metadata in the master database segment.' ),
( N'add_file_rollback', N'Occurs when add file action is rolled back.' ),
( N'adr_sweep_for_skip_pages_finished', N'The ADR sweep for skipped pages in ADR finished.' ),
( N'adr_sweep_timed_out', N'The ADR sweep for skipped pages timed out.' ),
( N'all_files_created', N'Occurs when all database files has already been formatted on disk for an ADD FILE DDL statement.' ),
( N'allocation_page_update_stats', N'Allocation page (PFS/GAM/SGAM) statistics.' ),
( N'backup_between_data_and_log', N'Used for signaling the point in a full/diff backup after the data copy is finished but before the log copy has started.' ),
( N'blob_access_pattern', N'Blobs access pattern' ),
( N'blob_trace_backtrack', N'Search blob trace for the problem blob handle lifetime' ),
( N'btree_retraversal_count', N'In every 2 hours interval,stats data of BTree re-traversal count is emitted' ),
( N'buffer_pool_flush_cache_start', N'Fired when Buffer Pool starts flushing dirty buffers.' ),
( N'buffer_pool_flush_io_throttle', N'Fire when Buffer Pool throttles flushing dirty pages. This event is fired very frequently when IO throttling is occurring.' ),
( N'buffer_pool_flush_io_throttle_status', N'Fired when Buffer Pool is flushing dirty pages. This event reports the status of IO throttling.' ),
( N'buffer_pool_scan_start', N'Fired when Buffer Pool scan starts.' ),
( N'buffer_pool_scan_stats', N'Buffer Pool Scan Statistics.' ),
( N'buffer_pool_scan_task_complete', N'Fired when Buffer Pool scan parallel task completes.' ),
( N'buffer_pool_scan_task_error', N'Fired when Buffer Pool scan parallel task encounters an error.' ),
( N'buffer_pool_scan_task_start', N'Fired when Buffer Pool scan parallel task starts.' ),
( N'cdc_cleanup_job_status', N'Change data capture cleanup job status. Returns information every 5 minutes.' ),
( N'cdc_ddl_session', N'CDC DDL Handling Session Information' ),
( N'cdc_log_throttle', N'Occurs when primary log gets full because of CDC/Repl and needs to be throttled.' ),
( N'cdc_log_throttle_manager', N'CDC Log I/O throttling manager events (create, delete, error)' ),
( N'cdc_scheduler', N'CDC Scheduler Information' ),
( N'column_store_fast_string_equals', N'Info about fast string search' ),
( N'column_store_index_deltastore_add_column', N'A columnstore deltastore rowgroup was rewritten from adding a column.' ),
( N'column_store_index_deltastore_alter_column', N'A columnstore deltastore rowgroup was rewritten from altering a column.' ),
( N'column_store_qualified_rowgroup_stats', N'Info about row group elimination and qualification in columnstore scan.' ),
( N'columnstore_flush_as_deltastore_fido', N'Shows column store index build information when remaining rows in the current rowgroup have been flushed into deltastore.' ),
( N'columnstore_index_additional_memory_fraction', N'Shows column store index addtional memory fraction information during columnstore index build.' ),
( N'columnstore_index_adjust_required_memory', N'Shows column store memory information when the required memory is adjusted to zero.' ),
( N'columnstore_index_bucketization_cleanup_task_fail', N'Shows column store index build information when a bucketization failed to clean up a task related objects.' ),
( N'columnstore_index_bucketization_create_dataset', N'Shows column store index build information when a bucketization insertion created a dataset.' ),
( N'columnstore_index_bucketization_create_task', N'Shows column store index build information when a bucketization process is about to finish.' ),
( N'columnstore_index_bucketization_create_task_from_multiple_cells', N'Shows column store index build information when a bucketization process has created one or more tasks from multiple cells.' ),
( N'columnstore_index_bucketization_drop_worktable', N'Shows column store index build information when a bucketization dropped a worktable.' ),
( N'columnstore_index_bucketization_end_index_build', N'Shows column store index build information when a bucketization process is about to create a task.' ),
( N'columnstore_index_bucketization_enqueue_all_tables', N'Shows column store index build information when a bucketization process has enqueued all remaining worktables.' ),
( N'columnstore_index_bucketization_first_row_received', N'Shows column store index build information when a bucketization insertion thread received the first row.' ),
( N'columnstore_index_bucketization_get_or_create_worktable', N'Shows column store index build information when a bucketization insertion created a worktable.' ),
( N'columnstore_index_bucketization_init_index_build', N'Shows column store index build information when a bucketization process is initialized.' ),
( N'columnstore_index_bucketization_insert_fail', N'Shows column store index build information when a bucketization process has failed.' ),
( N'columnstore_index_bucketization_insert_into_columnstore_fail', N'Shows column store index build information when a bucketization insertion into a columnstore segment has failed.' ),
( N'columnstore_index_bucketization_insert_into_worktable_fail', N'Shows column store index build information when a bucketization insertion into a worktable has failed.' ),
( N'columnstore_index_bucketization_process_task', N'Shows column store index build information when a bucketization process task is finished.' ),
( N'columnstore_index_bucketization_process_task_about_to_flush_last_row', N'Shows column store index build information when a bucketization task flushed the last row into columnstore index builder.' ),
( N'columnstore_index_bucketization_process_task_fail', N'Shows column store index build information when a bucketization process task has failed.' ),
( N'columnstore_index_bucketization_process_task_start', N'Shows column store index build information when a bucketization process task is started.' ),
( N'columnstore_index_bucketization_reached_end_index_build', N'Shows column store index build information when a bucketization process is reached to the end of index build, but has not finished its work yet.' ),
( N'columnstore_index_bucketization_rows_received', N'Shows column store index build information when a bucketization insertion thread received rows.' ),
( N'columnstore_index_bulk_insert_acquire_memory_grant_attempt_timeout', N'Shows column store memory information when an attempt of the memory grant request of columnstore bulk insert times out.' ),
( N'columnstore_index_clear_bulk_insert_flag', N'Shows rowset information when the columnstore bulk insert flag is cleared.' ),
( N'columnstore_index_convert_bulk_insert_to_trickle_insert', N'Shows column store memory information when the memory grant request of columnstore bulk insert times out.' ),
( N'columnstore_object_manager_read_retry', N'Retry read from azure blobk blob on sbs read failure.' ),
( N'columnstore_tuple_mover_exclusion_lock_timeout', N'The tuple mover timed out trying to acquire a lock to compress a row group.' ),
( N'columnstore_tuple_mover_worker_stealing', N'Columnstore tuple mover worker stealing.' ),
( N'compute_readable_secondary_wait_for_redo_for_debugging', N'When a query gets a page from the future, it waits for redo to catchup. Emitted without predicates' ),
( N'compute_secondary_permanent_fault', N'' ),
( N'concurrent_gam_update_stats', N'Concurrent GAM Update stats.' ),
( N'dac_login_information', N'Occurs when an internal DAC session is established/disconnected with sqlserver' ),
( N'socket_dup_event', N'This event is for Socket Duplication steps at SQL or Xlog side.' )
SELECT
*
FROM #xe2022 AS x
WHERE x.name LIKE '%%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment