Some Inline views may vary in execution time, which again may lead to scheduling challenges.
The following script will list Inline ordered by the execution time variance over the last 10 days.
NOTE: Remember to set the correct database name in [STACKNAME_XBI_MGMT_DEV]
SELECT max([TaskExecutionTime]) as maxExecTime
,min([TaskExecutionTime]) as minExecTime
,max([TaskExecutionTime]) - min([TaskExecutionTime]) as varExecTime
,count(*) as #runs
,[ProcessName]
,[GroupName]
,[DatabaseName]
FROM [STACKNAME_XBI_MGMT_DEV].[dbo].[PerformanceLog]
where ProcessCategory = 'Transformation'
and date between getdate()-10 and getdate()
group by [GroupName]
,[ProcessName]
,[DatabaseName]
order by varExecTime desc
Comments
0 comments
Please sign in to leave a comment.