Monitor Stretch Database Activity

Microsoft SQL Server has provided couple of DMV’s to Monitor Stretch Database ,Stretch Objects and Data Movement to Azure SQL Server database

sys.remote_data_archive_databases
sys.sysservers
sys.remote_data_archive_tables
sys.dm_db_rda_migration_status

I have a video on how to use these DMV’s and what information do they have

Leave a Reply

Your email address will not be published. Required fields are marked *