Slow vCenter Server performance after increasing the performance data statistics collection level to more than 2

Products

• VMware vCenter Server

Issue/Introduction

Symptoms:
After increasing the vCenter Server performance data statistics collection level to more than 2, you experience these symptoms in vCenter Server:

• Performance is slow.
• vpxd crashes and runs out of memory.
• May see an event "Memory exceeds hard limit" in vpxd.log.
• The VMware VirtualCenter Server service takes longer to start.
• The vCenter Server database increases significantly in size.
• The database transaction log increases significantly in size.
• The performance data rollup jobs and stored procedures take a long time to run and may fail.
• Performance graphs display gaps.
• In the c:\programdata\vmware\infrastructure\virtualcenter server\vpxd.log file, you see this repeated entry:
  
  SQL execution took too long

Environment

VMware vCenter Server 6.7.x
VMware vCenter Server 4.0.x
VMware vCenter Server 5.5.x
VMware vCenter Server 5.0.x
VMware vCenter Server 6.5.x
VMware vCenter Server 5.1.x
VMware VirtualCenter 2.5.x
VMware VirtualCenter 2.0.x
VMware vCenter Server 6.0.x
VMware vCenter Server 4.1.x

Cause

When the statistic level is increased, a higher load is placed on vCenter Server and the amount of data which the vCenter Server rollup jobs need to process increases.

Resolution

Generally, only statistics levels 1 and 2 are used for performance monitoring and analysis. Basic performance data are gathered at these levels. If you want to see more detailed information, you can view the statistics in real-time, which enables you to see every available metric without modifying the collection level.

In certain cases, you might want to record the more detailed metrics over a longer period of time. In this case, you can set a higher level for the desired duration and restore the level to a lower number after collecting the required information.

VMware strongly recommends you to not run at higher statistical collection levels for prolonged periods of time. Running at higher statistical levels is recommended only for a very short term and for test environments. Also, ensure to engage the local database administrators for any changes from the default settings. Statistical collection levels should never be altered from default in a production environment.

 

To check the statistics levels:

1. Connect to vCenter Server using the vSphere Client.
2. Navigate to Administration > vCenter Server Settings > Statistics > Statistics Intervals.
3. Under Interval Duration, check Statistics Levels.

Additional Information

You can use the attached vCenter Server database size calculators to estimate the size of the vCenter Server database after it runs for a certain time period.

 

For information on the vCenter Server database size calculators, see:

• VMware vCenter Server 4.0 Database Sizing Calculator for Microsoft SQL Server
• VMware vCenter Server 4.x Database Sizing Calculator for Oracle

For more information, see:

• VirtualCenter Monitoring and Performance Statistics
• VMware vCenter Server Performance and Best

パフォーマンス データ統計収集レベルを 3 以上に増やした後に vCenter Server のパフォーマンスが遅くなる
简体中文：将性能数据统计信息收集级别提高到 2 以上后，vCenter Server 性能降低