| title | sys.dm_hadr_physical_seeding_stats (Transact-SQL) | |||
|---|---|---|---|---|
| description | sys.dm_hadr_physical_seeding_stats (Transact-SQL) | |||
| author | rwestMSFT | |||
| ms.author | randolphwest | |||
| ms.date | 02/27/2023 | |||
| ms.service | sql | |||
| ms.subservice | system-objects | |||
| ms.topic | reference | |||
| f1_keywords |
|
|||
| helpviewer_keywords |
|
|||
| dev_langs |
|
[!INCLUDE 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. |
| 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. Based on the current transfer_rate_bytes_per_second and uncompressed remaining data size (when is_compression_enabled = 0). For Managed Instance link, data compression is used, so estimate_time_complete_utc is expected to be an overestimate. |
| 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. |
Requires VIEW SERVER STATE permission on the server.
Requires VIEW SERVER PERFORMANCE STATE permission on the server.
Automatic Page Repair (Availability Groups: Database Mirroring)
suspect_pages (Transact-SQL)
Manage the suspect_pages Table (SQL Server)