vCenter Server Service consumes more memory on start up

Products

• VMware vCenter Server

Issue/Introduction

Symptoms:

• The vpxd service uses most of the available memory on vCenter when it started.
• Unable to login to vCenter.

Environment

VMware vCenter Server 6.0.x

Cause

This issue occurs when the VPX_FIELD_VAL table in the vCenter database contains too many entries.

Resolution

This issue is fixed in vCenter Server 6.0 Update 3.

Workaround:

To work around this issue, remove unused rows from VPX_FIELD_VAL table.

1. Create a snapshot or backup of the vCenter Server. Do not skip this step.
2. Stop vCenter server service.

Note: See Article How to stop, start, or restart vCenter Server 6.x services (2109881).

3. Run the following command in the vCenter database:

select cast(substring(mo_id from 6) as int) as field_val_task_id from vpx_field_val where mo_id like 'task-%'

4.  Run the following command to delete the unused data:

delete
from vpx_field_val
where cast(substring(mo_id from char_length('task-')) as int) in ( select cast(substring(mo_id from char_length('task-')) as int) as field_val_task_id from vpx_field_val where mo_id like 'task-%'
except
select task_id
from vpx_task
where complete_state not in ('success', 'error') or complete_time >= (now () - interval '1 day') );

5. Start vCenter server service.

Note: See Article How to stop, start, or restart vCenter Server 6.x services (2109881).