Analizing Ensemble Business Processes Performance

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


 

  • 0
  • 0
  • 178
  • 0
  • 2

Answers

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.