Description of problem: ---------------------- I've noticed gaps in data collected from a C&U gap collection. The DB has data points for even hours only. vmdb_production=# select timestamp from metric_rollups where resource_name = 'nachandr-x' and timestamp > '2016-06-02' and timestamp < '2016-06-03' and capture_interval_name = 'hourly'\x\g\x Expanded display is on. -[ RECORD 1 ]------------------ timestamp | 2016-06-02 02:00:00 -[ RECORD 2 ]------------------ timestamp | 2016-06-02 04:00:00 -[ RECORD 3 ]------------------ timestamp | 2016-06-02 06:00:00 -[ RECORD 4 ]------------------ timestamp | 2016-06-02 08:00:00 -[ RECORD 5 ]------------------ timestamp | 2016-06-02 10:00:00 -[ RECORD 6 ]------------------ timestamp | 2016-06-02 12:00:00 -[ RECORD 7 ]------------------ timestamp | 2016-06-02 14:00:00 -[ RECORD 8 ]------------------ timestamp | 2016-06-02 16:00:00 -[ RECORD 9 ]------------------ timestamp | 2016-06-02 18:00:00 -[ RECORD 10 ]----------------- timestamp | 2016-06-02 20:00:00 -[ RECORD 11 ]----------------- timestamp | 2016-06-02 22:00:00 Version-Release number of selected component (if applicable): ------------------------- 5.6.0.10 How reproducible: ----------------- Always Steps to Reproduce: ------------------- 1.Manage a vSphere provider. 2.Initiate gap collection for a week or so. Actual results: --------------- gaps in C&U gap data collected Expected results: ----------------- No gaps in C&U gap data collected Additional info: ---------------- I see this issue with both vSphere 5.5 and vSphere 6.0
Nandini, do you know if that VM was on during those times? I remember some bug where we would see every-other-hour rollups in the logs for VMs that were power off during the time of the rollups. I'm not sure we ever tracked it down.
Created attachment 1171427 [details] screenshot of perf graphs from vCenter
According to VMware documentation https://pubs.vmware.com/vsphere-60/index.jsp?topic=%2Fcom.vmware.wssdk.apiref.doc%2Fvim.HistoricalInterval.html They no longer allow change to perf interval. From what I have found, the interval of gap collection is default to 2 hours. I'm closing this bug. If there's need to change this behavior, please create a RFE.