VMware

Overview

VMware vCenter provides a centralized platform for managing VMware vSphere environments.

VMware vCenter collects and stores statistics from ESX servers in a Microsoft SQL Server database (VIM_VCDB) which Axibase Collector queries every 20 minutes to offload incremental statistics from the VPX_HIST_STAT1 table into the Axibase Time Series Database for long-term retention and operations analytics.

Requirements

  • VMware vCenter 5.x+

Installation Steps

Import VMware JDBC job

Configure VMware Database Connection

  • Open the Data Sources > Databases page and select the sql-vmware database.
  • Provide connection parameters to the target VIM_VCDB database as displayed below:

  • Execute the following test query to check the connection:
SELECT 1

Query result must be Query OK.

Verify Job Configuration

  • Open the VMware job.
  • Set Data Source to sql-vmware.

  • Choose a target ATSD server if your Collector instance is connected to multiple ATSD servers.
  • Save the Job.
  • Open each configuration, click Test, and review the output. See Data Queries below.

Schedule the Job

  • Open the JDBC Job page and click Run for the VMware job.
  • Make sure that the job status is COMPLETED and Items Read and Sent commands are greater than 0.

  • If there are no errors, set the job status to Enabled and save the job.

Verify Metrics in ATSD

  • Log in to ATSD.
  • Click the Metrics tab and filter metrics by the prefix vmware.*.

Viewing Data in ATSD

Metrics

Properties

Entity Groups

  • VMware VMs
  • VMware Hosts
  • VMware Clusters

Live Portals

Data Queries

Data queries that offload recent metrics and properties.