sys.pdw_loader_run_stages & Amp;#40;transact-SQL)sys.pdw_loader_run_stages (Transact-SQL)

適用於: 否SQL Server 否Azure SQL Database 否Azure Synapse Analytics (SQL DW) 是平行處理資料倉儲 APPLIES TO: noSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) yesParallel Data Warehouse

包含在進行中和已完成的載入作業的相關資訊平行處理資料倉儲Parallel Data WarehouseContains information about ongoing and completed load operations in 平行處理資料倉儲Parallel Data Warehouse. 此資訊在系統重新啟動之後會持續存留。The information persists across system restarts.

資料行名稱Column Name 資料類型Data Type 描述Description 範圍Range
run_idrun_id intint 執行載入器的唯一識別碼。Unique identifier of a loader run.
stage (階段)stage nvarchar(30)nvarchar(30) 執行目前的階段。The current stage for the run. 'CREATE_STAGING'、 'DMS_LOAD'、 'LOAD_INSERT'、 'LOAD_CLEANUP''CREATE_STAGING', 'DMS_LOAD', 'LOAD_INSERT', 'LOAD_CLEANUP'
request_idrequest_id nvarchar(32)nvarchar(32) 執行這個階段的要求識別碼。ID of the request running this stage.
statusstatus nvarchar(16)nvarchar(16) 此階段的狀態。Status of this phase.
start_timestart_time datetimedatetime 階段開始時間。Time at which the stage was started.
end_timeend_time datetimedatetime 階段結束時間,如果有的話。Time at which the stage ended, if any. 如果未啟動,或進行中為 NULL。NULL if not started or in progress.
total_elapsed_timetotal_elapsed_time intint 執行這個階段所花費的 (或所花費的到目前為止) 的總時間。Total time this stage spent (or spent so far) running. 如果 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.

另請參閱See Also

SQL 資料倉儲和平行處理資料倉儲目錄檢視SQL Data Warehouse and Parallel Data Warehouse Catalog Views