VMware
 

Knowledge Base

Search the Knowledge Base:
Products:
Search In:
 

Missing Performance Data in VirtualCenter 2.5

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\T-SQL:
  • job_schedule1_mssql.sql
  • job_schedule2_mssql.sql
  • job_schedule3_mssql.sql
OR if you are using Oracle in %ProgramFiles%\VMware\Infrastructure\VirtualCenter Server\dbupgrade\Upgrade-v3-to-v4\PL-SQL:
  • job_schedule1_oracle.sql
  • job_schedule2_oracle.sql
  • job_schedule3_oracle.sql 

Your database administrator can execute these scripts to recreate the schedules if needed.

Feedback

Rating: 1 - Lowest 2 3 4 5 - Highest (0 Ratings)   

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.
What can we do to improve this information? (2000 or fewer characters)
Submit
Rating: 1 - Lowest 2 3 4 5 - Highest (0 Ratings)   
Actions
  • KB Article: 1003570
  • Updated: Aug 26, 2009
  • Products:
    VMware VirtualCenter
  • Product Versions:
    VMware VirtualCenter 2.5.x