Some users of the 4D Database software (by 4th Dimension) may experience excessive CPU utilization to the point that the server stops responding at about 78% CPU utilization (as measured by the server software). The utilization may increase over several days until this happens.
This behavior could be indicative of a runaway looped process or poor memory management. However, the problem is caused by a default setting in the server software.
The corrected settings for CPU Priority are shown below. Click the image for a larger view.
The default setting is to have all three of the sliders in the middle setting (which causes a problem).
Although sliders are used, these actually don’t slide. There are three possible settings: low, medium, high.
The chart below shows the CPU load difference when the CPU Priority is set to low compared to having the setting on medium priority. Click the image for a larger view.
The image below shows the constant CPU utilization when the setting is in the default middle position. Click the image for a larger view.