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