Hello everyone, our Epicor is installed on our own server. It was running smoothly at first, but lately, as we have been using it more frequently, we have been experiencing severe lagging. Could it be due to a periodic cache cleanup on the server, but the cleanup interval is too long? Have any of you experienced a similar lagging issue?
What kind of SQL maintenance are you running on your box?
1 Like
We have had a few issues on speed from time to time on 10.2 and have done the following.
- Minimizie BPM’s and Data Directives. Check things that are not needed are disabled.
- Recycled our application pool every morning around 5.00 am automatically.
- We have SQL indexing set up to re-index fortnightly.
- Checked our IP speed to make sure this was not the issue.
- Check for long running’s processes on SQL and terminated or trouble shoot’d them.
- Looked for large reports running. We didn’t have any.
- Any schedule jobs ran at the appropriated tim via the Sys agent.
Point 2 and 5 above made the most difference.
SQl Server
Could you please provide more details on the specific steps required to set up the automatic recycling of the application pool at approximately 5.00 am every morning, as mentioned in the second point?
Sure.
Go into IIS and select your Application Pool. On the pic below ours is EpicorLive10. In the right had pane select Recycling.
The next panel should pop up. Select the ‘Specific times’. I have entered two times; 5.00am and 5.20 am. Go through ‘Next’ and make sure ‘Scheduled time’ and ‘On Demand’ are ticked. This works for me.
That’s it.
I hope this helps.
1 Like
Thank you very much for your help. We tried the method suggested, but it didn’t seem to have a significant effect. However, we later restarted the server and closed some unnecessary System proxy service, and it seemed to have improved a lot.
Thanks.
Another point I forgot to mention, was the virus protection on our SQL server was taking a lot of CPU time about 35% on and off. We fixed this. Have you looked at the CPU load on your SQL and APP server?
Thank you for your suggestion. We have checked and found that the CPU and memory utilization rates are not high. We have closed some of the unused accounts, which has improved the performance to some extent, but there is still some lagging.
Ok, step back a bit.
Do you have server logging turned on for Epicor? If not, do so.
Then, note the times it seems laggy, in detail, so you can go back and reference the (Epicor )ServerLog,
and the System/App Event log(s) for the Server/VM itself, as well as the database Server.
IIS Logs too.
See if you see any issues during those time periods. Also check if you have any maintenance type tasks during those periods.
Previously, we thought that disabling the proxy might help, but it turns out that clearing the client cache on the user side actually improved the performance significantly. While it may still take some time to open the window after each client restart, the data loading process is much faster.
We are using classic forms and have set the form caching option in the form settings, which has also helped to speed up the opening of forms. However, some forms still take about 10 seconds to open after each restart. It would be perfect if we could make the first opening of the form faster as well.
Thank you very much for your reply, but we have no knowledge of the logs, and there are so many of them that we cannot find any useful information. It may be faster to directly try various optimization plans to solve the problem.
how many days has your server been up for. We notice ours starts having performance issue around 20days up time. We then do a server restart after hours and all is good in the world again.
Yesterday morning, we restarted the server, but the effect was not obvious. Instead, there was some improvement after clearing the cache on the client side. However, in the afternoon, the system started to experience lagging again.