Automic Workload Automation

How CPU and DB score are calculated?

20160927/020014.904 - 20151109/112043.010 - U0003533 UCUDB: Check of data source finished: No errors. Performance CPU/DB: '27106541'/'79'

20160927/020014.904 - 20151109/112043.010 - U0003544 UCUDB: Reference values tested with Windows 2003 on XEON 1500 MHz: CPU 813865, DB 470

The second value is produced by writing one sentence in a specific table, do a rollback, try to read it. After that it goes again, write, rollback, read,... Here we do this also for one second.

Can the statements for the DB performance check be made available so they can be run and measured outside of the application?

I also would like to have this statement.

I can remember that Michael_Lowry some time ago reaised the same request, but I don't remember if he ever did receive an answer....

Yes, I asked for the SQL statements used to measure performance. I cannot find the discussion now. I might have been in a comment on a documentation page. (Those discussions were saved, but they are not visible in the new system.) I never received an answer to my request.

Those discussions were saved, but they are not visible in the new system

This thread also reminded me that I still miss the nuances added by the flags. I can distinctly remember having flagged the OP as "lol" purely for the technical implementation of "adding 1+1+1+1 for a second". Not having that flag changes the entire meaning for me

Hi Michael,

it's the database sequence ‘insert + select + rollback’ in DIVDB table the WP is able to do in 1 second.

But this sequence is nothing a WP have to deal with on regular base, like creating an object, update workflow monitor, update activities and so on. So it will give a value but not 100% related to AE activities.

Peter