Print View

VirtualCenter reports "Performance data is currently not available for this entity"


When selecting the Performance tab in VirtualCentre and selecting any period of longer than a day under Change Chart Options the graph is empty with the message "Performance data is currently not available for this entity".


Possible Resolutions:

1) VirtualCenter 1.X to 2.0 SQL Upgrade
A VirtualCenter 2.0 Server (using an MS SQL Server database) that has been upgraded from VirtualCenter 1.x may not display performance data in the VI Client. This problem does not affect fresh installations of VirtualCenter 2.0, nor any upgrade or fresh installation that uses an Oracle database.

Performance Data Is Not Displayed in VI Client Connected to VirtualCenter 2.0 Server after an Upgrade

2) Time Synchronisation between VirtualCenter and ESX hosts
If time synchronisation is not consistent between the VirtualCenter Server and the ESX hosts this message may be seen.

If time has been changed on an ESX host the following command may need to be run to start showing performance data straight away:

service mgmt-vmware restart

3) SQLSERVERAGENT Service not running on MS SQL Server
If the SQLSERVERAGENT is not running the following jobs are not run to generate stats:

- Past Day stats rollup
- Past Week stats rollup
- Past Month stats rollup

Start the SQLSERVERAGENT service and check the status of these jobs in SQL Enterprise Manager:

- <server> | Management | SQL Server Agent | Jobs

It will typically take an hour or two to generate these stats once the service is started.

If the jobs are missing from SQL Server Agent | Jobs in SQL Management Studio they can be recreated:

Repairing VirtualCenter 2.5 Server SQL Agent "Stats Rollup" Jobs

4) SQL Server 2005 Express Edition
This SQL vesion does not have a SQL Server Agent, so the stats rollup jobs will not be run.

Feature Comparison of MSDE and SQL Server 2005 Express

SQL Server 2005 Features Comparison

5) VirtualCenter Management Server Configuration
The level of statistics recorded is set in VirtualCenter:

- Select Administration | VirtualCenter Management Server Configuration | Statistics
- Ensure the Interval Durations are checked

6) Repair VirtualCenter
From the VitrualCenter server:

- Select Start | Control Panel | Add/Remove Programs
- Select VMware VitrualCenter Server
- Click Change
- Click Next on the VMware VirtualCenter Server dialogue
- Select the Repair radio button and click Next
- Click Next to use an existing database server
- Enter the database credentials and click Next
- Click No to the reinitialize the VirtualCenter repository dialogue
- Click OK to SQL Server Agent warning
- Select the use existing license server and click Next
- Click Next to accept license server and version
- Click Next to accept ports
- Click Next to accept Tomcat ports
- Click Install

7) Performance statistics rollup failure due to arithmetic overflow errors
VirtualCenter Server 2.5 uses the SQL Server Agent to periodically execute procedures that roll up collected performance statistic data. In some instances, data processed may exceed the datatype allocated and an arithmetic overflow error is seen in the SQL Server Agent job history.

The error message appears similar to the following:

Arithmetic overflow error converting expression to data type int. [SQLSTATE 22003] (Error 8115) The statement has been terminated.
[SQLSTATE 01000] (Error 3621). The step failed.

Apply as per


Ensure database permissions are correct before upgrading VirtualCenter 2.0 to 2.5:

"If the sysadmin role is added to the VirtualCenter login to satisfy database permissions for the upgrade to VirtualCenter 2.5, the installer may install a parallel database making your original hosts, resources pools, clusters, and permissions unavailable."

Administrative Credentials Are Required for Oracle and SQL Server Databases When Installing or Upgrading VirtualCenter

Do not grant or revoke the System Administrator's role to satisfy database permission requirements when upgrading to VirtualCenter 2.5

Host And Other Configuration Data Missing After Upgrading to VirtualCenter 2.5

Statistics Rollup Stored Procedures—Optional Parameters and Diagnostics


VMware VirtualCenter 2.5
VMware VirtualCenter 2.0

Created: 7th March 2008
Updated: 24th July 2008

Print View

© 2005-2024 Jamie Morrison