EnterpriseOne UBE Runtime Performance Audit

Yesterday, I saw a post by Shannon Moir called “Nice UBE / Batch Performance Summary“. It was great! It provided some the information needed to really evaluate the runtimes of your UBEs.

Shannon is a wiz at SQL on an Oracle database. Unfortunately for me, we don’t use Oracle databases. So, I converted Shannon’s SQL so that I can use it on SQL Server.

SELECT JCPID as UBE, 
	JCVERS as [Version], 
	ltrim(rtrim(simd)) + ': ' + ltrim(rtrim(vrjd)) as UBE_Name, 
	count(1) as [Count],
	Avg(datediff(s,jcstdtim,jcetdtim)) AS Avg_Time,
	min(datediff(s,jcstdtim,jcetdtim)) AS Min_Time, 
	max(datediff(s,jcstdtim,jcetdtim)) AS Max_Time
from svm910.f986114,ol910.f9860, [JDE_PD910].pd910.f983051
where ltrim(rtrim(jcpid)) = ltrim(rtrim(siobnm)) 
	and ltrim(rtrim(jcvers)) = ltrim(rtrim(vrvers)) 
	and ltrim(rtrim(jcpid)) = ltrim(rtrim(vrpid))
	and JCETDTIM > '01-01-2015'
	and JCETDTIM 

Thanks again, Shannon!

Leave a Reply