Monitor and troubleshoot data migration (Stretch Database)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2016)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

To monitor data migration in Stretch Database Monitor, select Tasks | Stretch | Monitor for a database in SQL Server Management Studio .

Check the status of data migration in the Stretch Database Monitor

Select Tasks | Stretch | Monitor for a database in SQL Server Management Studio to open Stretch Database Monitor and monitor data migration.

  • The top portion of the monitor displays general information about both the Stretch-enabled SQL Server database and the remote Azure database.

  • The bottom portion of the monitor displays the status of data migration for each Stretch-enabled table in the database.

    Stretch Database Monitor

Check the status of data migration in a dynamic management view

Open the dynamic management view sys.dm_db_rda_migration_status to see how many batches and rows of data have been migrated. For more info, see sys.dm_db_rda_migration_status (Transact-SQL).

Troubleshoot data migration

Rows from my Stretch-enabled table are not being migrated to Azure. What’s the problem?
There are several problems that can affect migration. Check the following things.

  • Check network connectivity for the SQL Server computer.

  • Check that the Azure firewall is not blocking your SQL Server from connecting to the remote endpoint.

  • Check the dynamic management view sys.dm_db_rda_migration_status for the status of the latest batch. If an error has occurred, check the error_number, error_state, and error_severity values for the batch.

    The Azure firewall is blocking connections from my local server.
    You may have to add a rule in the Azure firewall settings of the Azure server to let SQL Server communicate with the remote Azure server.

See Also

Manage and troubleshoot Stretch Database