Performance issues in Commerce Manager 7.5 Version

Vote:
 

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:

  • Are there any updates to the related stored procedures that we could make to improve performance
  • Are there any updates to EPI commerce manager dlls that can be made to improve performance
  • Our shipmentlist uses the method OrderContext.Current.FindPurchaseOrders to find orders – are there any special cases / parameters to avoid or alternate methods we should use for fetching the orders
  • Our orderlist uses the Commerce.Orders.DataSources.OrderDataource object to find orders – are there any special cases / parameters to avoid or alternate methods we should use for fetching the orders

 

Awaiting for your reply

#183082
Edited, Oct 04, 2017 15:53
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.