When vSphere client doesn't show performance graphs anymore

Written by - 0 comments

Published on - Listed in VMware Virtualization

I recently experienced problem in VMware vSphere client where the performance graphics/statistics graphs were not shown anymore.

The overview didn't show anything, except of an error 'General report generation exception'. In the advanced tab only the real-time statistics could be seen, everything else (Past Day, Week, etc.) just showed the error 'Performance data is currently not available for this entity.'.
Take a look at the screenshots:

vSphere Overview graphs not shown vsphere Advanced Graphs not shown

There are several workarounds which can be found in the VMware Knowledge Base, but depending on the source of the problem, several of them can be skipped and more than one of them need to be applied. In my case I had to apply several. Let's start with it:

1) According to VMware KB 1004382, this problem occurs, when the SQL jobs are not correctly configured or if they run with errors. The SQL jobs have to be deleted and recreated by following the steps in the KB entry.

2) The SQL jobs and Procedures should be verified by following VMware KB 1029824

3) Another approach is to reset the statistic options in the vCenter settings. In vSphere client click on AdministrationvCenter Server Settingsā€¦ In the new window, click on Statistics on the left navigation side. Select the different intervals and change the Statistics Level to another number:

vsphere change performance graphs settings

After applying these 3 steps, the SQL jobs started to run at their scheduled time and the advanced performance graphs were shown again. However the Overview graphics were still not shown and still showed the error mentioned above.
To resolve this issue I had to dig deeper: The table views in the MSSQL database need to be recreated (not only the jobs as we did in step 1, but the whole tables). You will lose historical performance data by doing this (but as you can't see them anyway you don't mind). We add a forth step:

4) Follow VMware KB 1015606. After applying the steps of this KB entry, the missing overview graphs could be resolved and are showing again.

Add a comment

Show form to leave a comment

Comments (newest first)

No comments yet.