All,
It has been pointed out to us, that we have a database performance issue based on the below AE log entry (all entries are similar).
20230314/085622.531 - 20230228/233418.438 - U00003533 UCUDB: Check of data source finished: No errors. Performance CPU/DB: '29047518'/'87 (1000/11.440038 s)'
Our production environment AE servers are Windows 2016 and the database is MS SQL 2019.
Our production environment has always been below 100. Our non-production is around 350 to 400.
Broadcom has been involved and pointed out that the DB has an issue with the IO as the rollback/commit is far too slow.
This is our connection string in the usrv.ini: sqlDriverConnect=ODBCVAR=NNNNNNRN,DSN=automic;UID=automicuser;PWD=101938AD27E8CD9B6;Mars_Connection=Yes
We are using mssql-jdbc-8.4.1.jre8.jar
Both AE and database servers are on a 172.26.x.x subnet and tracert is 3 hops to the server.
Per the DBA, the database server and AE servers operates within the norms of our network.
I am looking to see if anyone else had an issue where the database performance number this low and what steps was done to increase the number.