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
Discussion (2)0
Comments
Hi
I would have a look at the testing service documentation here...
...this will talk you through setting up tests to look for process anomalies and bottlenecks.
Steve
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 NULLAs BO messages also get logged, you can check Ens.MessageHeader table for message processing time.