Monitor and troubleshoot data migration (Stretch Database)
THIS TOPIC APPLIES TO: SQL Server (starting with 2016)Azure SQL DatabaseAzure SQL Data Warehouse Parallel 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.
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.
For more info about the view, see sys.dm_db_rda_migration_status (Transact-SQL).
For more info about the content of a SQL Server error message, see sys.messages (Transact-SQL).
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.