This is Arjun Katkojwala from CGI. We have Integrated Episerver 7.5 as part of our Applications 3 years back.
We have Integrated Episerver 7.5 as part of our Applications. We are using Commerce Manager as our backend Application and have integrated around 5 front-end Applications (many running two instances on load balanced servers) using the same commerce manager database for managing all the orders.
We’ve seen a great increase in traffic in the last year and have been experiencing a lot of SQL timeout issues. We’ve noticed that when users are using commerce manager that a large number of locks are being created on the database and suspect this is causing all other applications to run into SQL timeouts as well. We especially see these issues when users are using the Commerce manager --> Order Management Modules. We’ve done some analysis and have noticed that during peak times we have approximately 40 users using commerce manager simultaneously – at the same time we are often getting sql timeouts in all of our applications. We also get many complaints about slow the performance of commerce manager.
In SQL server logs we see a lot of deadlocks being caused by the stored procedure [ecf_Search_PurchaseOrder] coming from Commerce Manager
What we want to know:
Awaiting for your reply