Working on installing 10.1.500 to a new 2012 R2 server with SQL 2016 for testing. Our 10.0 install was done by Epicor and then fine tuned by Nathan. Is there any documentation to make sure I get SQL setup correctly? Or am I better off hiring the install again?
If you don’t know how to do it I recommend you hire it out since there are a lot of nuance to getting it right. There isn’t any documentation other than what’s available in EpicWeb.
https://epicweb.epicor.com/doc/Docs/Epicor10_techrefPerformanceTuning_101500.pdf
1 Like
The Performance and Diagnostic Tool > Config Check should also be run on a regular basis as that is the official Epicor best practices analyzer. We check a number of SQL related items, like tempdb file count, specific SQL startup parameters that we know will benefit our customer’s usage patterns, etc. Ruleset SQL003 is specific to SQL server settings.
3 Likes
I did the install using the New Install, then went through the performance testing. Small hiccups, but got it going. 10.1.500.14 with sql 2014 install.
There are some power settings and memory settings that were corrected because my SQL Query Test failed from the Config Check.
1 Like
Thanks for the input guys.