The information below can also be found in our Knowledge Base (
KB0010781).
Error Message: The U0003533 that appears in WP and CP log files has information in it that can be used to troubleshoot performance issues
Detailed Description and Symptoms
If a UC4 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 UC4 can run an insert/select statement against the database within 2 seconds. Below is an example of a system with good performance:
U0003533 UCUDB: Check of data source finished: No errors. Performance CPU/DB: '27028497'/'284'
20130206/115358.006 - U0003544 UCUDB: 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 27,028,497 times in 2 seconds and was able to run an insert or select statement 284 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.