Zaki Ahmed
Well Known Member
We are having performance issue with sales order entry application. We have two enterprise servers (Server1 for Production and Server2 for Dev).
Issue is, when we enter/change a sales order in production, it takes upto 4 minutes to update the tables (F4201 and F4211). During that time, if user does a find on that same order or take a row exit of same order, it hangs up his machine for 4-5 minutes (the time it takes to update the tables). It seems like Server1 enterprise server for production takes a whole lot time to do table updates. But in dev, it works just fine.
We have recently applied the full pkg to production, so it can't be specs issue. We have recently updated Dev with production data, so it can't be data issue as well.
I am attaching the log files and jde.ini file for Server1 and Server2 servers. Please take a look at it and let me know if you find something that needs to be fixed.
EnterpriseOne E810
Sql Server
Windows
Issue is, when we enter/change a sales order in production, it takes upto 4 minutes to update the tables (F4201 and F4211). During that time, if user does a find on that same order or take a row exit of same order, it hangs up his machine for 4-5 minutes (the time it takes to update the tables). It seems like Server1 enterprise server for production takes a whole lot time to do table updates. But in dev, it works just fine.
We have recently applied the full pkg to production, so it can't be specs issue. We have recently updated Dev with production data, so it can't be data issue as well.
I am attaching the log files and jde.ini file for Server1 and Server2 servers. Please take a look at it and let me know if you find something that needs to be fixed.
EnterpriseOne E810
Sql Server
Windows