I am running the PDT on our new 10.2.200.5 server that is currently a test environment. On the SQL Query Test, I am getting between 4400 ms and 5000 ms. I have cleared all other fails except that the manager/manager account exists and the recovery model is set to Simple. It is a vmWare virtual server and there are no other virtual machines running on this host. C-States are disabled.
The host is several years old and is running Xeon E5630 @ 2.53.GHz. Would this be the most likely problem?
We are preparing to replace our 3 hosts and the initial configuration has Xeon Silver 4110 8 core 2.1GHz processors. There are lots more options and I am wondering if one of the hosts could be amplified to get the best performance for Epicor. Any recommendations?