Performance problems and an explanation of U0003533

Document ID : KB000088675
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Performance problems and an explanation of U0003533
Resolution:
Detailed Description and Symptoms

If a Automic system has performance issues that might include, but are not limited to:

 

Many Time Critical Database Calls

Slow performance

High CPU usage of the WPs and CPs?

 

One key aspect to look at is the message below that appears in startup of the WPs and CPs within their log files:

 

U0003533 Check of data source finished: No errors. Performace CPU/DB: '&01'/'&02'

Solution

The message:

 

U0003533 Check of data source finished: No errors. Performace CPU/DB: '&01'/'&02'

 

holds information regarding CPU and database performance.  The first number is the amount of times that the CPU can add 1+1 within 2 seconds.  The second number is how often Automic can run an insert/select statement against the database within 2 seconds.  Below is an example of a system with good performance:

 

U0003533 Check of data source finished: No errors. Performance CPU/DB: '28253037'/'1030'
U0003544 Reference values tested with Windows 2003 on XEON 1500 MHz: CPU 813865, DB 470

 

This shows that the CPU was able to add 1+1 28,235,037 times in 2 seconds and was able to run an insert or select statement 1030 times against the database within 2 seconds.  The benchmark for all QA and testing is referenced in the U0003544 message where the CPU was able to add 1+1 813,865 times and was able to run an insert or select statement against the database 470 times in 2 seconds.  Anything below these either of these numbers may be a sign that there will be performance problems, especially during times of high loads.