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!
            
            

                

                    

                        

                            

                                

                                    
                            
                            

                                

                                                                            
Author
                                        

                                        
                                            Stewart Schatz                                        
                                    
                                                                            
Career: Principal CNC Consultant for Syntax Systems Limited specializing Oracle JD Edwards EnterpriseOne and the technology that supports it.
Side Hustle: Owner/Operator of E1Tips.com
Location: Lancaster, PA USA 
What I like to do: Invest in Family, Explore Technology, Lead Teams, Share Knowledge/Experience, Hunt, Hike, etc.
                                                                                                                

                                            
                                                stewart@9rains.com                                            
                                        
                                                                                                                

                                            
                                                http://stewartschatz.com                                            
                                        
                                                                                                        
                                

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
                            
                        
                    
                
            
                    

            

                
                

                    
                        
                    

                        Happy                    
                    

                        
                                                    0
                                            
                

                

                    
                        
                    

                        Sad                    
                    

                                                                            0
                                            
                

                

                    
                        
                    

                        Excited                    
                    

                                                                            0
                                            
                

                

                    
                        
                    

                        Sleepy                    
                    

                        
                                                    0
                                            
                

                

                    
                        
                    
Angry
                    

                                                                            0
                        
                    
                

                

                    
                        
                    
Surprise
                    

                                                                            0