Missing Performance Data in VirtualCenter 2.5
KB Article1003570
Updated Mar. 12, 2009
Products
VMware VirtualCenter
Details
When using Microsoft SQL Server 2000 or SQL Server 2005, Standard or Enterprise edition, performance data may not be displayed as expected in VirtualCenter 2.5 if the SQL Server Agent service is not running.
Solution
Ensure SQL Server Agent service is running on your SQL Server. You must have SQL Server Agent running for performance data to display as expected.
 
VirtualCenter 2.5 uses SQL Server Agent to run the following SQL Agent jobs to manage historical data:
  • Day stats_rollup1_proc & purge_stat1_proc
  • Week stats_rollup2_proc & purge_stat2_proc
  • Month stats_rollup3_proc & purge_stat3_proc
These can be set by opening the enterprise manager software and checking the left pane under sql agent> jobs. This is were the stored procedures rollup_stats_1 and 2 and 3 is stored.

DB administrator sets these stored procedures so they appear under the "sql agents > jobs" by dba admin.  If necessary they can be downloaded from the VirtualCenter agent manually and executed. Doing so makes the missing charts to appear when the performance stats are brought up.
 
Note: This article does not apply to installations using Microsoft SQL Server 2005 Express.
 
Note: The SQL Server Agent is not available in Microsoft SQL Server 2005 Express. Historic data is managed by the VirtualCenter Server service.  

Additional Information

The schedule for these jobs are defined in three SQL scripts on the VirtualCenter Server, under %ProgramFiles%\VMware\Infrastructure\VirtualCenter Server\dbupgrade\Upgrade-v3-to-v4\:
  • job_schedule1_mssql.sql
  • job_schedule2_mssql.sql
  • job_schedule3_mssql.sql
OR if you are using Oracle in:
  • job_schedule1_oracle.sql
  • job_schedule1_oracle.sql
  • job_schedule1_oracle.sql 

Your Database administrator can execute these scripts to re-create the schedules if needed.


Product Versions
VMware VirtualCenter 2.5.x
Last Modified Date: 03-12-2009ID: 1003570
Copyright © 2008 VMware, Inc. All rights reserved.