Close

SQL Connection Pool Issues - NOP 3.2

CRM STRATEGY
9 years ago
#5898 Quote
Avatar
  • 1
We have implemented your template for our clients and it has so far been an interesting journey with many issues that have caused us great costs to resolve and some issues regarding search still open with no end in sight.

Last week, we ran into a massive issue that caused the new production site to be crashing every 30 odd minutes.
It was related to SQL connection pool issues.

After considerable testing  and searching, we finally turned off your plugins and behold, the site stayed up.
We have had to increase the SQL connection pool size to 999 rather than the standard 100 to increase stability but your plugins are killing the site.

As we don’t have code access to the DLLs, we can’t tell you the problem but you have one.
Can you urgently look at the search and any data intensive plugins and look for issues that can cause a recursive use of sql connections blowing the pool past 100.

We have logged the problem on the NOP commerce forums under connection pools so you can see the debug details.

http://www.nopcommerce.com/boards/t/29838/connection-leaks-nopcommerce-32.aspx

Your urgent help is desired to solve this problem. We will provide whatever information that is required to resolve it.

Kind regards,

CRM STRATEGY Pty Ltd.
Brett Cruickshank, Managing Director.

My Contact Details :
Office  : 03 9803 5522
Mobile : 0419 631 375
Skype  : brett_cruickshank
Email   : [email protected]
Web     : www.crmstrategy.com.au

We are powered by Passion ! TM.
When you need more performance in sales, profit, efficiency, call us now !
For 18 years, we have used technology to create processes to help businesses get their results.
We use technologies such as CRM, eCommerce, Data Integration, Email, and Mobile Applications to support your business.
We are a total service company, from consultancy through to delivery, all in house.
We get the job done. Pure and simple. Call today to get better results.
Boyko
9 years ago
#5900 Quote
Avatar
  • Moderator
  • 1570
Hi Brett,

We sent you an email to request more information.
We will write here again when we found out what is the problem for the many connection you have to the SQL server, so that other users are aware of this.

Thanks
Regards,
Nop-Templates.com Team