VMware Cloud Community
mhartleib
Contributor
Contributor
‎08-31-2011 06:57 AM

vCenter statistics - gaps in performance graph

Hi,

we have vCenter 4.1 U1, ESXi 4.1 U1 and use Oracle on a dedicated VM as database.

Statistic levels are set to 2-1-1-1.

Realtime and daily stats are fine. But when switching to weekly stats, all average rollup types show gaps. Monthly and yearly stats even don't show any data for average rollups. Summation and Latest rollup types are not affected.

Any ideas?

Michael

Preview file
99 KB
0 Kudos
1 Reply
mhartleib
Contributor
Contributor
‎12-12-2011 08:29 AM

We were able to solve the issue 🙂

Just in case there are people with similar problems, here is what we did:

1) Truncated temptables and hist stats:

truncate table vpx_temptable0;
truncate table vpx_temptable1;
truncate table vpx_temptable2;

truncate table VPX_HIST_STAT1;
truncate table VPX_SAMPLE_TIME1;

truncate table VPX_HIST_STAT2;
truncate table VPX_SAMPLE_TIME2;

truncate table VPX_HIST_STAT3;
truncate table VPX_SAMPLE_TIME3;

truncate table VPX_HIST_STAT4;
truncate table VPX_SAMPLE_TIME4;

http://kb.vmware.com/selfservice/microsites/search.do?cmd=displayKC&externalId=1007453

2) re-created the index on the vpx_sample_time table:

drop index VPX_SAMPLE_TIME1_M1;
CREATE INDEX VPX_SAMPLE_TIME1_M1 ON VPX_SAMPLE_TIME1
  (    ROLLUP_COUNTER,    99  );
drop index VPX_SAMPLE_TIME2_M1;
CREATE INDEX VPX_SAMPLE_TIME2_M1 ON VPX_SAMPLE_TIME2
  (    ROLLUP_COUNTER,    99  );
drop index VPX_SAMPLE_TIME3_M1;
CREATE INDEX VPX_SAMPLE_TIME3_M1 ON VPX_SAMPLE_TIME3
  (    ROLLUP_COUNTER,    99  );
drop index VPX_SAMPLE_TIME4_M1;
CREATE INDEX VPX_SAMPLE_TIME4_M1 ON VPX_SAMPLE_TIME4
  (    ROLLUP_COUNTER,    99  );

http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=103275...

Michael

0 Kudos