Disable Maintenance Routines
Posted: Tue Apr 28, 2020 1:28 pm
I know there's been several threads about this but I couldn't find one that works.
What's happening is that I'm getting errors due to long waits on my SQL Server whenever AbleCommerce wants to perform a maintenance routine like delete anonymous users, baskets, etc and it's causing my SQL Server to boggle down.
All I want to do is disable all the AbleCommerce maintenance routines as I don't need them since I'm already manually cleaning up my tables directly on the SQL Server once a week.
This is the version I'm running:
AbleCommerce for ASP.NET
VERSION: 7.0.86.6169
Release Label: GoldR6
DATABASE: NHibernate.Dialect.MsSql2005Dialect
Thanks
What's happening is that I'm getting errors due to long waits on my SQL Server whenever AbleCommerce wants to perform a maintenance routine like delete anonymous users, baskets, etc and it's causing my SQL Server to boggle down.
All I want to do is disable all the AbleCommerce maintenance routines as I don't need them since I'm already manually cleaning up my tables directly on the SQL Server once a week.
This is the version I'm running:
AbleCommerce for ASP.NET
VERSION: 7.0.86.6169
Release Label: GoldR6
DATABASE: NHibernate.Dialect.MsSql2005Dialect
Thanks