2V0-622 · 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 contributing
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 points to problems with statistics collection being disabled or the SQL Server rollup job and stored procedure being absent.
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
(40 responses)- A63% (25)
- D10% (4)
- E28% (11)
Why each option
Missing Past Week performance data in vCenter points to problems with statistics collection being disabled or the SQL Server rollup job and stored procedure being absent.
If performance statistics collection is globally disabled, no raw data is gathered at any interval, which means no rollup data for any time range - including Past Week - can be produced.
The Past Day rollup job aggregates 5-minute samples into hourly data; without this job the input data that feeds the Past Week rollup is never created, making Past Week charts empty.
The stats_rollup_1_proc stored procedure in the SQL Server database is the mechanism that executes the rollup aggregation; if this procedure is missing or corrupt, rollup processing silently fails and no historical data beyond the raw interval is retained.
Stopping the VMware Performance Charts Service would prevent charts from rendering for all time periods equally, not selectively affect only the Past Week view.
An incorrect JDBC URL in vcdb.properties would cause a complete database connectivity failure that blocks all statistics collection and display, not a targeted loss of only one time-range rollup.
Concept tested: vCenter Server performance statistics rollup troubleshooting SQL
Source: https://docs.vmware.com/en/VMware-vSphere/6.5/com.vmware.vsphere.monitoring.doc/GUID-25800DE4-68E5-41CC-82D9-8811E27609AB.html
Topics
Community Discussion
No community discussion yet for this question.