Performance Differences between Server and Client

Epicor ERP 10
1

Wondering what type of performance folks are getting when comparing their ERP10 performance on a client workstation vs. directly on the server. I recently switched roles and inherited and Epicor instance that is having some system performance issues and I’m trying to weed through and figure out exactly what is causing them (I know some of it is poorly designed customizations, but that doesn’t explain the full extent).

One of the specific complaints is the time that it takes to add order lines. To diagnose what is going on, I did a paste insert of 10 order lines (same part numbers, customers, etc. every time) in various scenarios. Here are my results (I did each test a number of times and averaged the result):

  • Client Workstation with all customizations enabled: 44.40 seconds

  • Client Workstation with UI customization disabled: 43.08 seconds

  • Client Workstation with BPMs disabled: 36.64 seconds

  • Client Workstation using fresh Demo Database: 29.38 seconds

  • App Server with all customizations enabled: 25.63 seconds

  • App Server with UI customization disabled: 23.74 seconds

  • App Server with BPMs disabled: 19.24 seconds

  • App Server using fresh Demo Database: 9.73 seconds

Based on the above, there is obviously some need to re-work some customizations (especially BPMs), but the biggest win would be figuring out if there is a way to get the clients to perform closer to the speed directly on the App Server. I know that the App Server is always going to perform faster because of a lack of Network latency, etc., but the current difference seems excessive.

I do have trace logs and have run them through PDT - Client Trace Analysis, if there’s anything specific in there that would be helpful to help with diagnosis.

Network Diagnostics from client workstation:

image
image1043×338 19.8 KB

Any input on what others are experiencing with similar tests would be great!

Thanks,

Jay

2

Client trace analysis for Adding 10 Sales Order lines via Client Workstation with all customizations enabled

image
image1007×303 15.2 KB

3

Client trace analysis for Adding 10 Sales Order lines via Server with all customizations enabled:

image
image1007×357 17.1 KB

4

Welcome Jay!

My first recommendation is checking out the Performance Tuning Guide on EpicWeb

E10 Documentation

Look under your base version, e.g. 10.2.700 then expand the Technical Reference section and your find something like: Epicor10_techrefPerformanceTuning_102###

5

As @Mark_Wonsil suggested take a look at the PT guide and confirm your client hardware specs. Memory does play big part. I’d have users with performance issues and when you visit their desk they have a gazzillion tabs open in Chrome and multiple other windows open, which doesn’t help.

Although it does look like you are taking a pretty scientific approach to determining the differences. On that note I’m going to take the assumption your test lab client has nothing else running on it apart from Epicor at the time of testing.

One thought is check out your AV, which I think is mentioned in the guide as well.

There will be network overhead, and things like using pass through Ethernet connections on IP phones can impact. The network test in the PDT gives you what the expected should be for the two types of request. I can’t remembere what they are, but I think it is mentioned at the top of the test output page (mentions something about WAN avg and LAN avg).

Do you have any errors or warnings when you run the server config test?