sys.pdw_loader_backup_run_details (Transact-sql) sys.pdw_loader_backup_run_details (Transact-SQL)
适用于：Applies to: 
Azure Synapse AnalyticsAzure Synapse AnalyticsAzure Synapse AnalyticsAzure Synapse Analytics并行数据仓库Parallel Data Warehouse并行数据仓库Parallel Data WarehouseAzure Synapse AnalyticsAzure Synapse AnalyticsAzure Synapse AnalyticsAzure Synapse Analytics并行数据仓库Parallel Data Warehouse并行数据仓库Parallel Data Warehouse
包含更详细的信息，而不仅仅是 sys.pdw_loader_backup_runs (transact-sql)中的信息，以及中有关正在进行和已完成的备份 Azure Synapse AnalyticsAzure Synapse Analytics 、还原和加载操作的持续和完成的备份和还原操作 并行数据仓库Parallel Data Warehouse 。Contains further detailed information, beyond the information in sys.pdw_loader_backup_runs (Transact-SQL), about ongoing and completed backup and restore operations in Azure Synapse AnalyticsAzure Synapse Analytics and about ongoing and completed backup, restore, and load operations in 并行数据仓库Parallel Data Warehouse. 信息在两次系统重启之间仍会保留。The information persists across system restarts.
| 列名Column Name | 数据类型Data Type | 说明Description | 范围Range |
|---|---|---|---|
| run_idrun_id | intint | 特定备份或还原运行的唯一标识符。Unique identifier for a specific backup or restore run. run_id 和 pdw_node_id 构成此视图的键。run_id and pdw_node_id form the key for this view. |
|
| pdw_node_idpdw_node_id | intint | 此记录包含其详细信息的设备节点的唯一标识符。Unique identifier of an appliance node for which this record holds details. run_id 和 pdw_node_id 构成此视图的键。run_id and pdw_node_id form the key for this view. |
请参阅 sys.dm_pdw_nodes (transact-sql)中的 node_id。See node_id in sys.dm_pdw_nodes (Transact-SQL). |
| statusstatus | nvarchar (16)nvarchar(16) | 运行的当前状态。The current status of the run. | "已取消"、"已完成"、"失败"、"排队"、"正在运行"'CANCELLED', 'COMPLETED', 'FAILED', 'QUEUED', 'RUNNING' |
| start_timestart_time | datetimedatetime | 在此特定节点上开始操作的时间。Time at which the operation started on this particular node. | |
| end_timeend_time | datetimedatetime | 操作在此特定节点上的结束时间（如果有）。Time at which the operation ended on this particular node, if any. | |
| total_elapsed_timetotal_elapsed_time | intint | 此特定节点上的操作运行的总时间。Total time the operation has been running on this particular node. | 如果 total_elapsed_time 超过24.8 天（以毫秒为单位） (整数的最大值) ，则会导致具体化失败，因为溢出。If total_elapsed_time exceeds the maximum value for an integer (24.8 days in milliseconds), it will cause materialization failure due to overflow. 最大值（以毫秒为单位）等效于24.8 天。The maximum value in milliseconds is equivalent to 24.8 days. |
| 进度progress | intint | 操作的进度，以百分比表示。Progress of the operation expressed as a percentage. | 0 到 1000 to 100 |
另请参阅See Also
Azure Synapse Analytics 和并行数据仓库目录视图Azure Synapse Analytics and Parallel Data Warehouse Catalog Views