Soumen
Reputable Poster
Dear List,
We have been facing slowness issues with JDE since last few months. The issue is reported all across the system and is reported by all users regardless of any specific module. The slowness is also on batch jobs running.
So far we have observed when the slowness ocuurs it is ususally accompanied by high CPU spikes on the database side. We have a SQL Server 2016 database with SP2. The CPU spike usually happens later in week and progressively gets worse. When this happens our only option has been to reboot the SQL Server database which eventually allivates the issue and the system performance goes back to normal.
We have not noticed any errors in JDE log or any errors in the SQL Server logs as well. We have not made any changes to database like upgrade etc for months now. We do have monthly production deployments but so far we have not been able to isolate the issue to some specific obejcts and hence the code changes does not seem to play a role here.
We have also reached out to MicroSoft try to understand what component of SQL Server database could be cuasing this. So far we have not been able to identify anything concrete. We have done several Re-indexing of tables based on our analysis.
We have not taken any major ESU/ASU. The last tools upgrade was done in April 2021. We upgraded our WebLogic in Novemeber.
I can share our JDE ini and no kernel changes was done and have not faced any issues as such with Kernels getting overloaded.
Appreciate if someone can suggest some advice on how we can further narrow down the issue and find the root cause.
Thanks,
Soumen
We have been facing slowness issues with JDE since last few months. The issue is reported all across the system and is reported by all users regardless of any specific module. The slowness is also on batch jobs running.
So far we have observed when the slowness ocuurs it is ususally accompanied by high CPU spikes on the database side. We have a SQL Server 2016 database with SP2. The CPU spike usually happens later in week and progressively gets worse. When this happens our only option has been to reboot the SQL Server database which eventually allivates the issue and the system performance goes back to normal.
We have not noticed any errors in JDE log or any errors in the SQL Server logs as well. We have not made any changes to database like upgrade etc for months now. We do have monthly production deployments but so far we have not been able to isolate the issue to some specific obejcts and hence the code changes does not seem to play a role here.
We have also reached out to MicroSoft try to understand what component of SQL Server database could be cuasing this. So far we have not been able to identify anything concrete. We have done several Re-indexing of tables based on our analysis.
We have not taken any major ESU/ASU. The last tools upgrade was done in April 2021. We upgraded our WebLogic in Novemeber.
I can share our JDE ini and no kernel changes was done and have not faced any issues as such with Kernels getting overloaded.
Appreciate if someone can suggest some advice on how we can further narrow down the issue and find the root cause.
Thanks,
Soumen