2V0-621 · Question #114
An administrator is unable to see performance statistics for only the Past Week performance data. The vCenter Server is using a Microsoft SQL Server Database. What are three likely causes…
The correct answer is A. Performance statistics are turned off. B. The Past Day rollup job is not present. C. The stats_rollup_1_proc is not present. Missing Past Week performance data in vCenter with a SQL Server backend typically points to disabled statistics collection, a missing rollup job, or a missing rollup stored procedure, since Week data depends on the Day-level rollup pipeline.
Question
An administrator is unable to see performance statistics for only the Past Week performance data. The vCenter Server is using a Microsoft SQL Server Database. What are three likely causes contributing to this issue? (Choose three.)
Options
- APerformance statistics are turned off.
- BThe Past Day rollup job is not present.
- CThe stats_rollup_1_proc is not present.
- DThe VMware Performance Charts Service is stopped.
- EThe JDBC URL is incorrect in the vcdb.properties file.
How the community answered
(34 responses)- A59% (20)
- D26% (9)
- E15% (5)
Why each option
Missing Past Week performance data in vCenter with a SQL Server backend typically points to disabled statistics collection, a missing rollup job, or a missing rollup stored procedure, since Week data depends on the Day-level rollup pipeline.
If performance statistics collection is globally disabled in vCenter, no data is gathered or stored at any interval level, which would cause Past Week graphs to be empty.
Past Week data is generated by rolling up Past Day data; if the Past Day rollup job is absent from SQL Server Agent, the aggregation that produces weekly statistics never runs.
stats_rollup_1_proc is the SQL stored procedure responsible for executing the first-level rollup; if it is missing or corrupt, the rollup pipeline breaks and no weekly data is produced.
The VMware Performance Charts Service being stopped would affect the display of all performance charts across all time intervals, not exclusively Past Week data.
An incorrect JDBC URL in vcdb.properties would prevent vCenter from connecting to the database entirely, causing much broader failures than only missing Past Week statistics.
Concept tested: vCenter performance statistics rollup pipeline troubleshooting
Source: https://docs.vmware.com/en/VMware-vSphere/6.5/com.vmware.vsphere.monitoring.doc/GUID-E1B99B16-E9D7-4B2E-8B8F-7F2E6F18A0FD.html
Topics
Community Discussion
No community discussion yet for this question.