How RE2 Tech took a 45-second order lookup down to under two seconds for a mid-market wholesale distributor running Epicor Prophet 21.
Read the Full StoryTalk to UsA wholesale distributor in the Upper Midwest was living with a distribution ERP that had gotten slower every year. Order entry screens took 45 seconds to load. Inventory queries timed out. Reports that used to take a minute took fifteen. Sales reps were writing orders on paper because the system was too slow to trust. The client had already thrown hardware at the problem three times and gotten no real relief.
We opened a SQL Profiler session against the production database and captured a full trace over several hours. Within a day we had identified the top twenty worst-performing queries, most of which were coming from stored procedures with outdated execution plans and missing indexes on heavily used tables. The database had not been properly maintained in years. Index fragmentation was extreme. Statistics were stale. Plan cache was thrashing.
Over the next two weeks we rebuilt the worst indexes, updated statistics, added a small number of missing indexes based on query patterns, rewrote four stored procedures that had gotten tangled over years of small edits, and set up proper ongoing maintenance jobs. No hardware changes. No software vendor tickets. No architecture changes.
Order entry screens now load in under two seconds. Inventory queries come back instantly. Reports that were timing out finish in under a minute. Sales reps trust the system again. The client moved to our Pro retainer after this project because they wanted to keep this level of attention on the database going forward.
Most MSPs would have told this client their ERP was just old and they should budget for a replacement or more hardware. We read the actual data and fixed the actual problem. That is the kind of depth most mid-market shops cannot get from an ordinary MSP.
Call a RE2 Tech engineer today and get a specific proposal inside of 72 hours. No pressure, no long pitch.
612-494-3557helpdesk@re2tech.com