Stretch DB management and troubleshooting

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.

Monitoring Stretch Database

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, as shown in Figure 6.24:

Figure 6.24: 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, as shown in Figure 6.25:

Figure 6.25: Stretch Database Monitoring

You can also use the dynamic management...