sys.pdw_loader_backup_run_details (Transact-sql) sys.pdw_loader_backup_run_details (Transact-SQL)

适用于:Applies to: 是Azure Synapse AnalyticsAzure Synapse AnalyticsyesAzure Synapse AnalyticsAzure Synapse Analytics 是并行数据仓库Parallel Data Warehouseyes并行数据仓库Parallel Data Warehouse适用于:Applies to: 是Azure Synapse AnalyticsAzure Synapse AnalyticsyesAzure Synapse AnalyticsAzure Synapse Analytics 是并行数据仓库Parallel Data Warehouseyes并行数据仓库Parallel Data Warehouse

包含更详细的信息,而不仅仅是 sys.pdw_loader_backup_runs (transact-sql)中的信息,以及中有关正在进行和已完成的备份 Azure Synapse AnalyticsAzure Synapse Analytics 、还原和加载操作的持续和完成的备份和还原操作 并行数据仓库Parallel Data WarehouseContains 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