Analizing Ensemble Business Processes Performance

Question

Question

Paster-Bachar Gadi · Sep 15, 2016

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

Steve Wilson · Sep 16, 2016

Hi

I would have a look at the testing service documentation here...

http://docs.intersystems.com/ens20152/csp/docbook/DocBook.UI.Page.cls?KEY=EGDV_testing#EGDV_testing_service

...this will talk you through setting up tests to look for process anomalies and bottlenecks.

Steve

0 0

score 1 · Answer 1 · 2016-09-16T05:18:02-04:00

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.