4th Dimension 4D Database Excessive CPU Utilization

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.

20141001we-4th-dimension-database-preferences-cpu-utilization

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.

20141001we-4th-dimension-database-preferences-cpu-utilization-chart-before-after

The image below shows the constant CPU utilization when the setting is in the default middle position. Click the image for a larger view.

20141002th-4th-dimension-4d-database-cpu-excessive-utilization

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s