Question
Paster-Bachar Gadi · Sep 15, 2016

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 278
Discussion (2)1
Log in or sign up to continue

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.