Print View

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

Issue

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".

Resolution

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
http://kb.vmware.com/kb/6579181

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
http://kb.vmware.com/kb/1004382

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
http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx#EKE

SQL Server 2005 Features Comparison
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

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 stats_rollup_proc_mssql-vc2.5.zip as per http://kb.vmware.com/kb/1003732
http://kb.vmware.com/Platform/Publishing/attachments/1003732_fstats_rollup_proc_mssql-vc2.5.zip

References

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
http://kb.vmware.com/kb/1003052

Do not grant or revoke the System Administrator's role to satisfy database permission requirements when upgrading to VirtualCenter 2.5
http://kb.vmware.com/kb/1003346

Host And Other Configuration Data Missing After Upgrading to VirtualCenter 2.5
http://kb.vmware.com/kb/1003610

Statistics Rollup Stored Procedures—Optional Parameters and Diagnostics
http://kb.vmware.com/kb/3034858

Products

VMware VirtualCenter 2.5
VMware VirtualCenter 2.0

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

Print View

© 2005-2024 Jamie Morrison