vSphere: Performance data is currently not available for this entity
At one of my customers, we upgraded the vCenter SQL database from SQL Express 2005 to SQL 2005 Standard Edition.
Nothing spectacular you should say, but after that VirtualCenter v2.5 U4 was not showing all performance statistics for my VM’s anymore. It was possible to see live stats for e.g. CPU and memory usage, but changing the chart options to ‘weekly’ or ‘monthly’ resulted in a ‘Performance data is currently not available for this entity’.
In SQL server there are three stat-rollup-jobs (which are the ones creating the perf stats in VCenter) which were not automatically created during the upgrade. These had to be added manually following this KB article from VMware.
After running the SQL statements, these jobs in SQL server Agent were added again:
Now you can wait a couple of hours until the scheduled jobs will start, or run them manually from SQL Server Management Studio…