New post
Question
· Sep 15, 2016

Analizing Ensemble Business Processes Performance

#Business Process (BPL) #Ensemble

Hi All 

 

I have a process that I want to analyze and find bottle necks (e.g BO that had taken to long) something similar to the SQL query optimizer

 

Any suggestions?

 

Thanks 

Gadi

Discussion (2)0
Log in or sign up to continue
Eduard Lebedyuk · Sep 16, 2016

As every BP is also a SQL table, you can select active processes which are older than 1 day  with this query:

SELECT ID, %SessionId, %SuperSession, %TimeCreated, DATEDIFF('day',%TimeCreated, CURRENT_TIMESTAMP) AS DaysOld
FROM <business_process_table>
WHERE DATEDIFF('day', %TimeCreated, CURRENT_TIMESTAMP) > 1
      AND %TimeCompleted IS NULL

As BO messages also get logged, you can check Ens.MessageHeader table for message processing time.

1 0