SSIS DB Abfrage Laufzeit
SELECT TOP 10 [statistics_id]
,[execution_id]
,[executable_id]
,[execution_path]
,[start_time]
,[end_time]
,[execution_duration]
,[execution_duration]/60000 As Delta
,[execution_result]
,[execution_value]
FROM [SSISDB].[catalog].[executable_statistics]
where year(start_time) = 2023
— and execution_path like ‘%orderitem%’
and [execution_path] like ‘%ShopDB%’
and [execution_path] like ‘%df%’
and year (start_time) = 2023 and month (start_time) = 8 and day(start_time)=11
— =’Staging_ShopDBSC_G_AlleSC_T_2_parallel Load Order Itemstable orderItemsdf_orderItems’
order by execution_duration desc
SELECT
T_langsam.Delta,
T_schnell.Delta AS DeltaSchnell,
T_langsam.Delta-T_schnell.Delta AS LaengereZeit,
T_langsam.execution_path
FROM
(
SELECT
[execution_duration]/60000 As Delta,
*
FROM [SSISDB].[catalog].[executable_statistics] st
where year(start_time ) = 2025 and month (start_time) = 3 and day (start_time) = 31
and execution_path like ‘%\Z_DWH_Gesamt_Sales\%’
) AS T_langsam
LEFT JOIN
(
SELECT
[execution_duration]/60000 As Delta,
*
FROM [SSISDB].[catalog].[executable_statistics] st
where year(start_time ) = 2025 and month (start_time) = 1 and day (start_time) = 31
and execution_path like ‘%\Z_DWH_Gesamt_Sales\%’
) AS T_schnell
ON T_langsam.execution_path=T_schnell.execution_path
WHERE T_langsam.Delta >T_schnell.Delta+5