hi folks
epicor V 10.2.4 sql 2016
we are just doing some investigating into our epicor sql database, and what i have noticed is that epicor continuously builds up sql transactions that do not close but sleep waiting for the next transaction.
in the past 3 days we have over 500 such transactions
has anyone else seen similar activity? did you get to the bottom of why this happens?
thanks
mal
Are you seeing specific issues because of it? Seems pretty normal to me yes. The application server holds transactions open for speed and will re-use them
The command sp_who2 active will give you a (slightly) better insight into whats doing stuff
i cant say the issues are directly linked, but we have to reboot app servers etc every week as epicor keeps getting slower, processes such as MRP start to take much longer
as soon as we reboot speed goes back to normal!
this may just be a red herring i guess!
Well that road can lead down many paths and probably being best reviewed with Epicor or a SQL specialist but in the first instance check that you are regularly running index rebuild maintenance tasks at least weekly
In the old days of Epicor 9 the system would naturally get slower as time went on. Not really had that in Epicor10. Its more like speed issues in specific places or specific times especially when you have external reporting using the data
we rebuild/reorganize our indexes nightly
but things like MRP can go from 30 mins to 60 mins over a period of time - this is ran out of hours generally so other tasks are not effecting it, but it is an issue if we have to rerun during the day
over 600 transactions today sleeping
i really don’t think this is normal, it seems to increment by 100 a day so if we don't reboot our server we would soon have 1000’s of transactions, the memory required alone for this, would start causing issues
so based on Epicor support, it definitely isn't normal, the suggested resolution to restart app servers nightly is not great though as we run on shifts. but they can give no indication on why the application is holding so many open!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.