--- title: "Extended Events for Stretch Database" ms.date: "06/14/2016" ms.service: sql-server-stretch-database ms.reviewer: "" ms.topic: conceptual ms.assetid: 70485e74-2e25-4e7e-be6c-9dd1780a42e3 author: rothja ms.author: jroth ms.custom: seo-dt-2019 --- # Extended Events for Stretch Database [!INCLUDE[tsql-appliesto-ss2016-xxxx-xxxx-xxx-md-winonly](../../includes/tsql-appliesto-ss2016-xxxx-xxxx-xxx-md-winonly.md)] Stretch Database provides a set of extended events for troubleshooting. For more info, see [Extended Events](../../relational-databases/extended-events/extended-events.md). For info about how to start an extended events session for troubleshooting, see [Create an Extended Events Session](https://msdn.microsoft.com/library/34b1e95a-a80e-4aca-9201-abde47f2ca74) ## 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 premise 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 a ALTER DATABASE SET REMOTE_DATA_ARCHIVE OFF command stretch_database_enable_completed|Reports the completion of a 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 a number of 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 a number of 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 a number of 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 un-provisioning ## See Also [Manage and troubleshoot Stretch Database](../../sql-server/stretch-database/manage-and-troubleshoot-stretch-database.md)