Serious performance issues

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
tiago.ramalho
Ensign (ENS)
Ensign (ENS)
Posts: 1
Joined: Tue Nov 21, 2017 2:30 am

Serious performance issues

Post by tiago.ramalho » Tue Nov 21, 2017 2:55 am

We have been implementing and maintaining an AC solution for the last 5 years (currently in version 7.0.7), lately, due to an increase of users and other factors we could not identity, the virtual server hasn’t been able to keep up with the load, and the site becomes completely unresponsive.
The diagnostic tool (Dynatrace) seems to indicate a thread lock in the Cache NHibernate class but there doesn’t seem to be a direct correlation between the number of users and the server overload. The pattern seems to be recurrent, if the CPU gets over a certain % the system starts to become increasingly instable, the used memory starts to go UP and when it gets up to 14Gb or so the server completely stops responding and an IIS Reset is necessary.
My question is pretty broad, are these symptoms known? Did any of the other projects experienced any of this behavior? What are the common causes for underperformance in AC?
Thank you in advanced for your answers

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: Serious performance issues

Post by Katie » Tue Nov 21, 2017 11:39 am

A common cause for issues like this could be related to maintenance of the database records. Do you have Activity Logging enabled, and if so, are the records being purged?

Joe Payne is an expert on AbleCommerce databases. He has some helpful info here - viewtopic.php?f=65&t=18900&start=0&hilit=performance

We also have an old FAQ which documents the maintenance and shows how you can check the records.

http://help.ablecommerce.com/index.htm# ... enance.htm

Hope this helps.
Thanks
Katie
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: Serious performance issues

Post by jmestep » Wed Nov 22, 2017 12:37 am

I'm curious as to the nHibernate Cache- AC 7.0.7 didn't use nHibernate. Have you added that to the site?
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: Serious performance issues

Post by Katie » Wed Nov 22, 2017 2:24 am

To check your version, go to the Help > About page.
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

Post Reply