Epicor 10.0.700.4 Performance

Epicor ERP 10
1

Hi There,

We are currently having sporadic slowdowns on our epicor 10.0.700.4 system. Our setup is as follows:

Host Server:
ProLiant DL380p Gen8
2 X Intel Xeon CPU E5-2650 v2 @ 2.60GHz
Memory: 256 GB Speed: 1866
Smart Array P420i Controller
SQL VHDX is stored on SSDS in Raid 1+0
Virtual Machine system VHDX on 15K SAS
Host operating system on 10K SAS
Server 2012 R2

Epicor Server ( Virtual )
1 Physical Intel Xeon CPU E5-2650 v2 @ 2.60GHz
Memory 117.2 GB (Complete bank of Memory for the above CPU on the host)
Database Drive is on Host SSD’S VHDX is formatted to 64K Sector Size
Server 2012 R2
SQL Server 2012 (Virtualized)

We have implemented all of the IIS tweaks recommended by Epicor but we appear to have seen no improvement in stability or speed.

Any ideas would be greatly appreciated

Many Thanks

Alex

2

Have you ran the Epicor PDT (Performance Diagnostic Tool) and checked your configuration?

3

Yes we have done all of that to great lengths and to no avail.

4

I recall having issues with a particular Ethernet chipset and Virtual Machines back when I was setting up some virtual servers. It required a setting change in the driver . Don’t know if this is the case for your problem or not….

bw

5

Thanks for that. Yeah we did have the same issue but we changed that too.

6

how’s your indexing, that all up to speed and where it should be?

7

We have a weekly maintenance plan the rebuilds and re-indexes out Database.

8

What about bios settings? I had a problem once with C-state, C1, and other power settings being misconfigured in bios. I used cpu-z and discovered my cpus were running at half speed. Once I adjusted those settings, my cpus ran better and I got over my performance bottleneck.

9

Oh yes we have done that too. Another question I would like to pose to all of you is are you using a virtual database server or a physical one?

10

You said the slow downs are sporadic are you looking into what is running in the background at that time? It might make sense to see what open transactions are out there in SQL land. you would be surprised what can bring the whole system to it’s knees. Your technical specs on the server seem on point. just a few questions there. Are you NUMA spanning, how many tempDbs do you have. What were the results of the PDT you said you ran it to no avail but did it come back 100% clean (I know 100% clean is not necessarily right depending on the setup but knowing what you did get back can help). When you hit a slow down is it certain screens (read between the lines data sets) if so and it lasts long enough run an SQL trace get slow queries and run execution plans on those. See what’s slowing them up.