Extended Events for Stretch Database
Applies to: 
SQL Server 2016 (13.x) and later - Windows only
Important
Stretch Database is deprecated in SQL Server 2022 (16.x) and Azure SQL Database. This feature will be removed in a future version of the Database Engine. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Stretch Database provides a set of extended events for troubleshooting.
For more info, see Extended Events. For info about how to start an extended events session for troubleshooting, see Create an Extended Events Session
List of extended events for Stretch Database
| Event name | Event description |
|---|---|
| remote_data_archive_db_ddl | Occurs when the database T-SQL ddl for stretching data is processed. |
| remote_data_archive_provision_operation | Occurs when a provisioning operation starts or ends. |
| remote_data_archive_query_rewrite | Occurs when RelOp_Get is replaced during query rewrite for Stretch. |
| remote_data_archive_table_ddl | Occurs when the table T-SQL ddl for stretching data is processed. |
| remote_data_archive_telemetry | Occurs whenever an on-premises system transmits a telemetry event to Azure DB. |
| remote_data_archive_telemetry_rejected | Occurs whenever an AzureDB Stretch telemetry event is rejected |
| repopulate_stretch_schema_task_queue_complete | Reports the completion of repopulating stretch schema task queue. |
| repopulate_stretch_schema_task_queue_start | Reports the start of repopulating stretch schema task queue. |
| stretch_codegen_errorlog | Reports the output from the code generator |
| stretch_codegen_start | Reports the start of stretch code generation |
| stretch_create_remote_table_start | Reports the start of remote table creation |
| stretch_database_disable_completed | Reports the completion of an ALTER DATABASE SET REMOTE_DATA_ARCHIVE OFF command |
| stretch_database_enable_completed | Reports the completion of an ALTER DATABASE SET REMOTE_DATA_ARCHIVE ON command |
| stretch_database_reauthorize_completed | Reports the completion of a sp_rda_reauthorize_db spec proc |
| stretch_index_reconciliation_codegen_completed | Reports the completion of code generation for stretch remote index operation |
| stretch_index_update_step_completed | Reports the duration of a stretched index update operation |
| stretch_migration_debug_trace | Debug trace of stretch migration actions. |
| stretch_migration_dequeue_migration | Event raised when a stretch migration task is dequeued for a database. |
| stretch_migration_queue_migration | Queue a packet for starting migration of the database and object. |
| stretch_migration_requeue_migration | Event raised when a stretch migration task packet is requeued. |
| stretch_migration_start_migration | Start migration of the database and object. |
| stretch_migration_start_unmigration | Start unmigration of the database and object. |
| stretch_remote_column_execution_completed | Reports the completion of remote execution for the generated code for a stretched column |
| stretch_remote_column_reconciliation_codegen_completed | Reports the completion of code generation for stretch remote column reconciliation |
| stretch_remote_index_execution_completed | Reports the completion of remote execution for the generated code for a stretched index |
| stretch_schema_queue_task | Reports when a packet is about to be queued for processing a schema task for the database and object. |
| stretch_schema_script_execution_completed | Reports the completion of stretch script execution during processing stretch schema task. |
| stretch_schema_script_execution_skipped | Reports the skipping of stretch script execution during processing stretch schema task. |
| stretch_schema_script_execution_start | Reports the start of stretch script execution during processing stretch schema task. |
| stretch_schema_task_failed | Reports the failure of a stretch schema function during the stretch schema task. |
| stretch_schema_task_skipped | Reports the stretch schema task is skipped during the stretch schema function. |
| stretch_schema_task_start | Reports the start of stretch schema function during the stretch schema task. |
| stretch_schema_task_succeeded | Reports the successful completion of stretch schema function during the stretch schema task. |
| stretch_sp_migration_get_batch_id | Call sp_stretch_get_batch_id |
| stretch_sync_metadata_start | Reports the start of metadata checks during the migration task. |
| stretch_table_codegen_completed | Reports the completion of code generation for a stretched table |
| stretch_table_complete_data_reconciliation | Complete data reconciliation of the database and object. |
| stretch_table_data_reconciliation_event | Reports the completion of the data reconciliation of a batch of rows |
| stretch_table_data_reconciliation_results_event | Reports an error or completion of a successful data reconciliation of several batches of rows |
| stretch_table_hinted_admin_delete_event | Reports the execution of a Stretch delete DML operation that uses an admin hint |
| stretch_table_hinted_admin_update_event | Reports the execution of a Stretch update DML operation that uses an admin hint |
| stretch_table_provisioning_step_completed | Reports the duration of a stretched table provisioning operation |
| stretch_table_query_error | Reports an error thrown during Stretch query rewrite |
| stretch_table_remote_creation_completed | Reports the completion of remote execution for the generated code for a stretched table |
| stretch_table_row_migration_event | Reports the completion of the migration of a batch of rows |
| stretch_table_row_migration_results_event | Reports an error or completion of a successful migration of several batches of rows |
| stretch_table_row_unmigration_event | Reports the completion of the unmigration of a batch of rows |
| stretch_table_row_unmigration_results_event | Reports an error or completion of a successful unmigration of several batches of rows |
| stretch_table_start_data_reconciliation | Start data reconciliation of the database and object. |
| stretch_table_unprovision_completed | Reports the completion removal of local resources for a table that was unstretched |
| stretch_table_validation_error | Reports the completion of validation for a table when the user enables stretch |
| stretch_unprovision_table_start | Reports the start of stretch table unprovisioning |
See also
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for