Header RSS Feed
 
If you only want to see the articles of a certain category, please click on the desired category below:
ALL Android Backup BSD Database Hacks Hardware Internet Linux Mail MySQL Monitoring Network Personal PHP Proxy Shell Solaris Unix Virtualization VMware Windows Wyse

When vSphere client doesn't show performance graphs anymore
Saturday - Nov 5th 2011 - by - (0 comments)

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.

Go to Homepage home
Linux Howtos how to's
Monitoring Plugins monitoring plugins
Links links

Valid HTML 4.01 Transitional
Valid CSS!
[Valid RSS]

6979 Days
until Death of Computers
Why?