Some performance metrics are missing from the graphs in the Monitor tab of the VAMI

Products

• VMware vCenter Server

Issue/Introduction

After upgrading to vCenter Server Appliance 8.0.3, collection of some performance data is disabled.
As a result, CPU and database metrics are missing in the VAMI (vCenter Server Management Interface) monitoring, and some graphs do not display correctly after the upgrade.

The following symptoms can be observed in the Monitoring tab of the vCenter Server Management Interface:

• In the CPU & Memory tab, some metrics show gaps
  
  
  
• For Database values, some metrics show gaps.
  

Environment

vCenter Server Appliance 8.0.3

Cause

After the upgrade, some performance metrics (such as cpuUsage, totalSpace, and health) are disabled and are no longer collected. As a result, these metrics are missing from the VAMI graphs.

Resolution

1. Check which performance metrics are enabled on a healthy vCenter or on the vCenter prior to the upgrade, and then enable those metrics on the affected vCenter.
   
   

   List enabled metrics
   sqlite3 /storage/db/vmware-observability/stellar.db "SELECT name,source,status from metrics where status=1;"
   Example output:
   State|process|1
   read_bytes|disk|1
   write_bytes|disk|1
   
   List disabled metrics
   sqlite3 /storage/db/vmware-observability/stellar.db "SELECT name,source,status from metrics where status!=1;"
   Example output:
   cpuUsage|stat|0
   totalSpace|filesystem|0
   health|observer|0

   This example indicates that the metric cpuUsage with source stat is disabled.
   
   
2. Use the following SQL commands as a reference to enable the required metrics.
   Based on the information for disabled metrics identified in step 1, replace the metric name and source.
   
   

   sqlite3 /storage/db/vmware-observability/stellar.db "UPDATE metrics SET status=1 WHERE name IN ('cpuUsage') AND source='stat';"
   sqlite3 /storage/db/vmware-observability/stellar.db "UPDATE metrics SET status=1 WHERE name IN ('totalSpace') AND source='filesystem';"
   sqlite3 /storage/db/vmware-observability/stellar.db "UPDATE metrics SET status=1 WHERE name IN ('health') AND source='observer';"

3. Restart the observability service:
   
   

   service-control --restart observability