nerdexam
Broadcom-VMware

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.

Section 7 – Administer and Analyze vSphere 6.5 Performance

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)
  • A
    63% (25)
  • D
    10% (4)
  • E
    28% (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.

APerformance statistics are turned off.Correct

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.

BThe Past Day rollup job is not present.Correct

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.

CThe stats_rollup_1_proc is not present.Correct

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.

DThe VMware Performance Charts Service is stopped.

Stopping the VMware Performance Charts Service would prevent charts from rendering for all time periods equally, not selectively affect only the Past Week view.

EThe JDBC URL is incorrect in the vcdb.properties file.

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

#performance statistics#stats rollup#SQL Server#performance charts

Community Discussion

No community discussion yet for this question.

Full 2V0-622 Practice