Mitch_Denis_38

Performance Problems and an explanation of U0003533

Discussion created by Mitch_Denis_38 on Feb 8, 2013
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.

Outcomes