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 ...
Get SQL Server 2016 Developer's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
