Optimize Cloud Director Performance by reducing the size of the audit_trail table

Products

• VMware Cloud Director

Issue/Introduction

• The Cloud Director UI is slow to load.
• Tasks will finish relatively quickly, but loading information is slow.
• When accessing Cloud Director UI notice pages are loading increasingly longer.
• Higher then expected CPU utilization is observed on a Cloud Director database cell.

Environment

VMware Cloud Director 10.6.x
VMware Cloud Director 10.5.1

Cause

Slow performance can be usually attributed to a large growth of the audit_trail table in the database.

The audit_trail table will capture activity ongoing within the environment and will capture additional information should Cloud Director be integrated with other Products such as Container Service Extension (CSE) or Aria Operations.

 

Resolution

To manage the audit events you will need to review your environment and do one or both of the below:

1. Reduce the current size of the audit_trail and clear some data.
2. Set Cloud Director to automatically remove activities after a period of time.

Reduce the current size of the audit_trail and clear some data.

To perform this step, please contact a technical support and note this Knowledge Article ID (320412) in the problem description. For more information, see Creating and managing Broadcom support cases.

Set Cloud Director to automatically remove activities after a period of time.

You can use the Cell-Management-Tool, present on all Cloud Director cells to configure the application and set the number of days you wish to retain events for.

The following command will update the Audit Trail configuration to keep 10 Days only.

/opt/vmware/vcloud-director/bin/cell-management-tool manage-config -n com.vmware.vcloud.audittrail.history.days -v 10