sys.dm_hadr_physical_seeding_stats (Transact-SQL)
Applies to: 
SQL Server
Azure SQL Managed Instance
On the primary replica, query sys.dm_hadr_physical_seeding_stats DMV to see the physical statistics for each seeding process that is currently running.
The following table defines the meaning of the various columns:
| Column name | Data type | Description |
|---|---|---|
| local_physical_seeding_id | uniqueidentifier | Unique identifier of this seeding operation on the local replica. |
| remote_physical_seeding_id | uniqueidentifier | Unique identifier of this seeding operation on the remote replica. |
| local_database_id | int | Database ID on the local replica. |
| local_database_name | nvarchar | Database Name on the local replica. |
| remote_machine_name | nvarchar | Remote replica machine name. |
| role_desc | nvarchar | Seeding role description. (available values: Source, Destination, Forwarder, ForwarderDestination) |
| internal_state_desc | nvarchar | Description of the local replica state. |
| transfer_rate_bytes_per_second | bigint | Current seeding transfer rate in bytes per second. |
| transferred_size_bytes | bigint | Total bytes already transferred. |
| database_size_bytes | bigint | Total size in bytes of the database being seeded. |
| start_time_utc | datetime | Start time of the seeding operation in UTC. |
| end_time_utc | datetime | End time of the seeding operation in UTC. |
| estimate_time_complete_utc | datetime | Estimation of the completion time for an in-process seeding operation, in UTC. |
| total_disk_io_wait_time_ms | bigint | Sum of the disk IO wait time encountered, in ms. |
| total_network_wait_time_ms | bigint | Sum of the network IO wait time encountered, in ms. |
| failure_code | int | Failure code for the seeding operation. |
| failure_message | nvarchar | Message corresponding to the failure code. |
| failure_time_utc | datetime | Time of failure, in UTC. |
| is_compression_enabled | bit | Indicates whether compression in enabled for the seeding operation. |
Security
Permissions
Requires VIEW SERVER STATE permission on the server.
Permissions for SQL Server 2022 and later
Requires VIEW SERVER PERFORMANCE STATE permission on the server.
See also
Automatic Page Repair (Availability Groups: Database Mirroring)
suspect_pages (Transact-SQL)
Manage the suspect_pages Table (SQL Server)