vCenter Database rollup
Posted on 2014-08-22
We are running vCenter 5.1. We recently upgraded our vCenter SQL version to standard edition because it normally comes with SQL express which has a limit of 10GB database size, and 50 VMs. We are expanding our VMs, and thus had to upgrade to standard edition.
Since the upgrade, we now have a warning in vCenter Service Status:
Performance statistics rollup from Past Day to Past Week is not occurring in the database.
Performance statistics rollup from Past Week to Past Month is not occurring in the database.
Performance statistics rollup from Past Month to Past Year is not occurring in the database.
Additionally, I cannot see any historical statistics on performance. According to VMware, this started happening when we upgraded to SQL standard edition.
What is the fix for this?