Get seeding stats

get-seeding-stats.sql

SELECT
	FLOOR(transferred_size_bytes * 1. / NULLIF(database_size_bytes, 0) * 100) AS Perc
,	transfer_rate_bytes_per_second / 1024 / 1024. AS MBSec
,	internal_state_desc
,	start_time_utc, estimate_time_complete_utc
,	FLOOR(transferred_size_bytes / 1024. / 1024. / 1024.) AS transferred_size_GB
,	FLOOR(database_size_bytes / 1024. / 1024. / 1024.) AS database_size_bytes_GB
,	*
FROM sys.dm_hadr_physical_seeding_stats