Tag Archive: Epicor 10

4 Easy Steps to Speed Up Epicor 10

September 15, 2015 2:11 pm | Published by | Leave your thoughts

Do you have Epicor 10 installed and configured, but are experiencing slow speeds? Follow these four easy steps to help Epicor 10 run faster in any environment. 1. Optimize for Ad Hoc Workloads – This option is used to improve the efficiency of the plan cache for workloads that contain many single use ad hoc batches. Setting this to 1 will improve performance. To set these in SQL, follow these steps: Launch SQL Management Studio Right click on the DB you want to optimize and select ‘New Query’ Type the following and execute:   2. Parameterization Forced – Setting this... View Article