Hello Community,
We have been getting some pretty long wait times on jobs in particular Payment File creation. 1h until it starts and another 30min until its complete.
I have already changed settings (concurrency to 2 and priority to high) on the EP scripts according to a SuiteAnswers article. It seems to have improved a bit, but not substantial. So I checked the application performance app and found that the processor utilization is quite high and I think Queue wait times are also high.
Looking at all the map/reduce and scheduled scripts, it seems that many daily ones can run for hours and leave the others in the pending to start for that time - if too many run at the same time.
Conclusion:
I could look at scheduling scripts at different times, but the high processor utilization leads me to belief that it won't really help much according to this definition of processor utilization:
"This number shows how much of the total processing time within the time range was used to complete jobs."
--> I need another processor if I want to run more scripts at the same time. Maybe reserve a queue for high priority and long taking ones. Is my conclusion correct? What are your experiences?
Here are some details.
Ave Wait time: ~30min --> time until job is complete from start to finish once it starts
Ave. Queue time: ~33min --> time until job is complete that use queues (electronic bank)
Ave. Processor time: ~36min --> time until job is complete that does not use queues
Processor Concurrency is always 2.
Processor Util seems 85% upwars on average.