Performance Issues

This article is a compilation of several areas to check based on customer tickets and confirmed resolutions affecting SAP Business One and/or Eralis Job performance in general.

• BIOS Settings

We have been seeing some poor performance in SAP Business One when running in a virtualized environment on new Dell PowerEdge and HP ProLiant host servers. We have determined that these performance issues have been due to a BIOS setting on the servers hosting the virtual machines. There is a power profile setting in the BIOS that defaults to a balanced mode on these servers. This setting should be updated to the maximum performance setting to allow the virtual machines to perform as expected.

As an example of the impact, we ran a SQL query in both modes on one of our test servers and when in balanced mode the query took 34 seconds to run. When changing the setting back to performance mode the query time was reduced to 12 seconds.

Please check the BIOS power profile settings on any Hyper-V and VMware host servers in your environment and ensure that it is set to Maximum Performance mode for HP servers or Performance for Dell servers (other servers may also have the same issue).

There is also a Windows power management setting that defaults to 'Balanced' and it is recommended that it be changed to 'Performance' on both the virtual host servers and the virtual machines. This setting does not have the same impact as the BIOS setting but it may also help improve the overall performance of SAP Business One and SQL Server in your environment.

The linked ARTICLE describes this in more detail.

This must be updated on all of your Host servers that are running the TS and SQL server.

If you run the Passmark software before and after the bios changes this can show you if this was the problem or not. You can download via this link:

https://www.passmark.com/products/performancetest/download.php

• MSSQL Compatibility

If your SQL compatibility is 2017, try changing to 2012 – we have seen noticeable improvement for subjob screen loading as well as attachment screen, time taken reduced from 10-15sec to 3-5sec.

• Antivirus installed on TS

Some antivirus software has been known to cause issues, try testing with this temporarily disabled.

• 4K Monitor resolution

A customer experiencing degraded system performance had several users with higher end “4K” display monitors that support resolutions of up to 3840x2160 pixels. When the display settings are set to the highest 3840x2160 setting it triggers something on the AWS host server that overtaxes the Desktop Windows Manager (DWM) service causing it to consume a high percentage of the CPU cycles on the AWS host server. The workaround in this case was to simply to lower the display resolution to 2560x1440 on the workstation and the CPU usage immediately dropped to normal levels.