We recently changed our entire environment
I would like to take all performance stats (daily, weekly, monthly, etc) and delete all of them to start a fresh baseline. How do I do that?
See this KB article for the process;
I followed the article and when I ran this command:
truncate table VPX_HIST_STAT1;
SQL said the table did not exist. Digging down in my vcenter server tables I found hundreds of tables like this:
VPX_HIST_STAT1_1
VPX_HIST_STAT1_10
VPX_HIST_STAT1_100
etc.
There should only be 4 tables that hold the actual stats. I am guessing this has something to do with our upgrade from vCenter 5.0 to 5.1 to 5.1a. Any ideas why I have all of these extra tables? Any idea how to get back to just 4 tables to hold the stats?
This may help ...