U00003533 Performance Test

[Robert Richter]

Hello Community, 

 

the U00003533 Performance Check is made by the WPs, CPs and some Utilities every time the process is starting and additionally by the WPs in a periodic way, and you can see those messages in the logfiles. You can also use the ucdbconntest utility to get a more detailed view about the total time for the test and a detailed list with values about selects, inserts and so on.

 

What I'm interested in is, how the values look like in your environment?

In our environment we have values less than 4 seconds for the total time of the testing. 

Would you like to share your values too?

Do you have experiences about which value you register an increasing of tasks in the queues?

 

Here are two samples of the latest testresults:

timetotalMs,timeBindColMs,timeBindParMs,timeCloseMs,timeFetchMs,timeInsertMs,timeRollbackMs,timeSelectMs

2407,4,2,10,4,617,579,1149

3780,7,4,15,9,568,1992,1123

 

Regards

Robert

[Christoph Rekers at Tricise]

Hi Robert,

customer system (Windows Server 2022 with MSSQL 2022 on same machine, V24, system is currently idle/no activities)



Cheers

Christoph 

------------------------------
--------------------------------------------------------
Automic Consultant and Trainer since 2000
--------------------------------------------------------
now @tricise.com
------------------------------

[Robert Richter]

Thank you Christoph for your answer,

could you please add some info about the daily jobs or workload, which runs on the AE environment?

I hope some other users can give there infos too, to get a better picture about performance times and about the AE engine have troubles,
if the DB takes too long time to response.

Regards
Robert