The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
Search the VMware Knowledge Base (KB)
View by Article ID
Missing performance statistics in performance graphs (9960761)
Details
This article provides the information to troubleshoot issues when the performance graphs in VirtualCenter displays unexpected gaps in data even after configuring the statistics performance intervals to VMware recommended values.
If the performance graphs for all the VirtualCenter hosts display gaps and the gap sizes are about the same for all the hosts, it is very likely that the problem is related to database performance or communication between the database and VirtualCenter Server. We recommend you do the following:
Rebuild the database indexes to eliminate the fragmentation:
Open SQL Management Studio.
Click Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
Expand Databases, expand the database that contains the table with the specified index, and then expand Tables.
Expand the table to which the index belongs and then expand Indexes.
Right-click the index and click Rebuild.
Click OK to rebuild all indexes on the table.
Ensure that the system the database server is running on is not overloaded, busy, and does not have insufficient memory. Overloaded or busy systems can affect the database performance.
Ensure that the CPU usage for the system the database server is running on is not always at a high level. CPU usage at a constant high level indicates the database server is overloaded or that there is some problem with the system.
Use the database that is appropriate to your environment. If you are using Microsoft Access for the VirtualCenter database and you have several hosts and virtual machines, consider migrating your database to a more robust platform, such as the supported Microsoft SQL or Oracle databases. This will improve database performance.
Ensure the network traffic between the VirtualCenter server and the VirtualCenter database server is not overloaded. Overly busy network traffic causes data transfer delays between the two servers.
If the performance graphs show gaps only on specific hosts, it is likely that there are problems with these particular hosts or communication between hosts and VirtualCenter server. Occasionally, ccagent can be busy or blocked during a time when it is supposed to retrieve statistical data, preventing it from collecting the data on time. Check the following items to ensure ccagent is performing correctly.
Verify NIS+ does not have any performance problems. Slow NIS causes delays in retrieving user and group information, which results in delays for other ccagent operations.
Verify there are no I/O problems, which might block the ccagent.
