NOTE: This is a continuation of this thread which I have been doing more research into. Yes, I know the response to this is going to be “Well, duh!”, but just in case I am wrong, I am going to put this question out there: The number of releases in a Sales Order is directly related to how long it t…

Do you rebuild your indexes on a schedule?

To be honest, I don’t know. I am still trying to get a grasp on the practices of this company. I know enough about SQL to be dangerous, however rebuilding indexes on 4000+ tables is not something I have looked into. From what I do know about indexing in SQL, it is done on a per-table basis and I ca…

This is a good thread: [image] SQL Maintenance & Miscellaneous Questions Epicor ERP 10 Hello, Newbie SQL DB Admin here…and I’m trying to schedule backups and maintenance jobs (specifically index rebuild) against our ERP10 database to get it ready for when we go Live…uh, e…

Looking through our system, it looks like IndexOptimize from https://ola.hallengren.com is running on a weekly schedule for all User Databases (which includes all of the Epicor Databases). This is what Step 1 in that SQL Job contains: EXECUTE [dbo].[IndexOptimize] @Databases = ‘USER_DATABASES’, …

Jason, if you get into this and you want to split the cost of consulting we’d be cool doing that with you cause we do make direct jobs to these 5000 releases… and I know I’m going to need to the same help you need to make the system work. Idk where to go honestly.

What is database compatibility level?

@Olga - I am at compatibility level “SQL Server 2016 (130)”. That holds true for all of the Epicor databases, while the Report Server databases, system databases, and other user databases are all at “SQL Server 2017 (140)” [image] The install guide for 10.2.400 state that the SQL Server requiremen…

This can explain PDT error you get.

@Olga - that’s a good point. I never thought of the compatibility level being the cause of that. I’ll look into that this weekend. EDIT: So I just updated the Compatibility Level, and I still get that error. I will be updating to a later CU on SQL Server this evening and we will see if that does an…

So I just finished spinning up another SQL Server and migrated a copy of my Demo database to it. I then reconfigured my Demo environment to point to the new SQL Server and redeployed it. I opened up the client and opened up Order Entry. It was my hope that a different server that had nearly 0 load …

SalesOrder.GetByID slowness (again/still)

Epicor ERP 10

Doug.C (Doug Crabtree) January 18, 2024, 5:35pm 4

This is a good thread:

Topic		Replies	Views
Can the system just not handle large volume? Kinetic ERP	146	2364	March 30, 2026
Sales Order with thousands of Releases Epicor ERP 10 e10 , salesorder , order-release	28	3182	December 18, 2023
System Performance Epicor ERP 10 performance	30	5889	December 4, 2020
10.2.300.2 Sales Order Copy performance Epicor ERP 10 epicor	18	1177	February 19, 2019
Large orders Epicor ERP 10 e10	13	1459	December 27, 2021

SalesOrder.GetByID slowness (again/still)

Related topics