[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1290
  • Last Modified:

vCenter Database rollup

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?
1 Solution
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
When you move a SQL server from one server to another, or upgrade from SQL Express to SQL Standard, you must also create the scripts that run these rollup jobs...

See this VMware KB on how to create them

Updating rollup jobs after the error: Performance data is currently not available for this entity (1004382)

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now