SQL Server AlwaysOn Automatic initialization of AG (iv)

View Database Synchronization Progress

If the database is in an availability group configured for automatic seeding, you can query the sys.dm_hadr_automatic_seeding system view to monitor seeding progress. The following query returns one row for each database in each replica in the availability group that is configured for automatic seeding.

Executes on the primary replica

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:

SQL Server AlwaysOn Automatic initialization of AG (iv)