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.
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, while the status of data migration for each stretch-enabled table in the database is shown in the bottom part of the screen:
Stretch Database Monitoring
You can also use the dynamic management view sys.dm_db_rda_migration_status
to check the status of migrated data (how...