| description | Monitor and troubleshoot data migration (Stretch Database) | ||
|---|---|---|---|
| title | Monitor and troubleshoot data migration | ||
| ms.date | 06/14/2016 | ||
| ms.service | sql-server-stretch-database | ||
| ms.reviewer | |||
| ms.topic | conceptual | ||
| helpviewer_keywords |
|
||
| ms.assetid | 06950858-8c02-4ec6-9c59-42b787316a2d | ||
| author | rothja | ||
| ms.author | jroth | ||
| ms.custom | seo-dt-2019 |
[!INCLUDE sqlserver2016-windows-only]
To monitor data migration in Stretch Database Monitor, select Tasks | Stretch | Monitor for a database in SQL Server Management Studio .
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.
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).
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.