Shulou(Shulou.com)06/01 Report--

Check the progress of database synchronization

If the database is in the availability group configured for automatic seed settings, you can query the sys.dm_hadr_automatic_seeding system view to monitor the progress of seed settings. The following query returns a row for each database that is in each copy of the availability group configured for automatic seeding.

Execute on the master copy

SELECT start_time,ag.name,db.database_name,current_state,performed_seeding,failure_state,failure_state_descFROM sys.dm_hadr_automatic_seeding autosJOIN sys.availability_databases_cluster dbON autos.ag_db_id = db.group_database_idJOIN sys.availability_groups agON autos.ag_id = ag.group_id

The results are as follows:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.