To monitor stretch-enabled databases and data migration, you can use the Stretch Database Monitor feature, the sys.remote_data_archive_databases and sys.remote_data_archive_tables catalog views, and the sys.dm_db_rda_migration_status dynamic management view.
Stretch DB management and troubleshooting
Monitoring Stretch Databases
To monitor Stretch-enabled databases and data migration, use the Stretch Database Monitor feature. It is part of SQL Server Management Studio and you open it when you select your database and then choose Tasks/Stretch/Monitor:
Open Stretch Database Monitor in SSMS
The top portion of the monitor displays general information about both the stretch-enabled SQL Server database and the remote Azure database...