Hello Oskars,

So after running big export or report, SERVER goes to 100% CPU usage, yes?

For imports, that is so, because data is being written to database, and to protect it while being changed, this is how it works.

Maintenance - same, also depends which maintenances.

8.4, 8.5 :
Non-updating maintenances are on a separate thread than the main one, reports are on a separate thread too.


As hardware looks more than enough.


Answering to your question:
Is it possible to remake some function to other cores, so they do not disturb others Users?
Some maintenances and reports where moved away from main thread.

And are there recommendations for server optimization options?


You can try to set up properly System>>settingS>>optional features>> Performance tab, and select multithread.

Set accordingly to processor cores you have on SERP server machine. EG. if you have 8 cores in server, where the ERP server is installed, than set up accordingly:
Report slots - 4
Internet request threads - 2
HTTP - 2

Alternatively, you could try to use 32162000 MassiveCache- the speed of exporting/importing will increase, and In many cases speed of reporting and processing records will improve as well.

Regards,

Hansaworld support