Hi @Ivan Barumov,
out of curiosity, did you upgrade to v24 on the same hardware ? If so, are you able to compare the "performance numbers" in the WP logs before and after the upgrade?
For reference, here are the "performance numbers" for my v24.4.1 HF1 Sandbox env.:
20250806/154534.884 - U00003533 UCUDB: Check of data source finished: No errors. Performance CPU/DB: '25286853'/'1130 (1000/0.884786 s)'
20250806/154534.884 - U00003544 UCUDB: Reference values tested with Linux x64 on XEON 3600 MHz: CPU 525716336, DB 3505
20250806/154535.205 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'OPEN' time: '3:077.823.400'
Best regards
Keld.
-------------------------------------------
Original Message:
Sent: Aug 06, 2025 08:53 AM
From: Ivan Barumov
Subject: AWI v24.4 load and performance
We upgrade our systems to v24.4 from v21 last month but since then AWI performance issues are quite frequent.
just for perspective and info we are running red hat 8.10 java 17 and tomcat 9 load balanced servers and multiple AWI instances.
Before the upgrade we ran Test stage for months with same settings and configs but did not observe any performance degradation (best guess is not sufficient stress).
As soon we brought the first customer stage to v24 we needed to increase XMX value for the RAM tomcat uses double as well more to the AE process.
That helped for less then a day and we needed to increase again and again until we start hitting open file limits . Increased limits as well but did not helped much. Only thing that helps for the moment is restart of tomcat but if you leave it more than a day issues start to appear again.
What we observed is open file held by the tomcat process does not go down /perhaps it does but extremely slowly/ every time you check the count will be higher. Ram usage is a lot higher than before we stopped increasing it at x4 compared prior to the upgrade and its running on the max side. CPU utilization increases as well depending on how long process is running day old 1 core less than 50 % 2+ days multiple core 5+ full usage.
Its not normal utilization of the AWI to be so demanding and different than before. What are your experiences with v24 AWI ?
Did you notice need of more recourses? how about the frequency of the tomcat restart you need to take ?
and that goes without saying any helpful solutions to be shared ?
-------------------------------------------