Finding Inline views with large variance in execution time.

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