sys.dm_hadr_physical_seeding_stats (Transact-SQL)

Applies to: SQL Server

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.
transfered_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)