HendersonD
Hot Shot
Hot Shot

How to delete all performance stats?

We recently changed our entire environment

  • New switches (jumped to 10Gbps for servers and storage)
  • New hosts (replaced 5.5 year old hardware)
  • New storage (replaced 5.5 year old storage that was spinning disk with SSD storage)
  • New vSphere (made the jump from ESXi 4.1 to ESXi 5.1)

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?

0 Kudos
3 Replies
jrmunday
Commander
Commander

See this KB article for the process;

http://kb.vmware.com/selfservice/documentLinkInt.do?micrositeID=&popup=true&languageId=&externalID=1...

vExpert 2014 - 2018 | VCP6-DCV | http://www.jonmunday.net | @JonMunday77
0 Kudos
HendersonD
Hot Shot
Hot Shot

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?

0 Kudos
abirhasan
Enthusiast
Enthusiast

0 Kudos