Hi,
After the upgrade when looking at vCenter Service Status it shows
Performance statistics rollup from Past Day to Past Week is not occuring in the database
Performance statistics rollup from Past Week to Past Month is not occuring in the database
Performance statistics rollup from Past Month to Past Year is not occuring in the database
We are running SQL 2005 Express on a Windows 2008 64bit server.
Any idea how I can resolve this ?
thanks,
John
Deja vu... check this one: http://kb.vmware.com/kb/1013820
Marcelo Soares
VMWare Certified Professional 310/410
Virtualization Tech Master
Globant Argentina
Consider awarding points for "helpful" and/or "correct" answers.
Hi Marcelo,
Thanks for the link but that does not resolve my issue. I get the error when I go to Home and click on vCenter Service Status using the vSphere client
thanks,
John
Hi..Check do u have the following DBO on the SQL server
stats_rollup2_proc && exec purge_stat2_proc
stats_rollup3_proc && exec purge_stat3_proc
stats_rollup1_proc && exec purge_stat1_proc
If you find that try adding to the Jobs running on it.Each job should have 2 dbo's mapped to get the graph.
1.)Past Week stats rollupVirtualCenter - EXECUTE stats_rollup2_proc && exec purge_stat2_proc
This job is to roll up past week stats and should run every 2 hours
2.)Past Month stats rollupVirtualCenter - EXECUTE stats_rollup3_proc && exec purge_stat3_proc
This job is to roll up Past Month stats and should run every day
3.)Past Day stats rollupVirtualCenter - EXECUTE stats_rollup1_proc && exec purge_stat1_proc
This job is to roll up 5 min stats and should run every 30 mins
If you find this useful,award me Helpful or Correct answer
Hi,
As mentioned, we are running SQL Express and as such those jobs as I understand it are for the full version of SQL.
I may as well just reinstall VC with a new database. Looks like the upgrade has some issues.
thanks,
John
Hi,
As an update to this thread. I reinstalled vCenter with a new database rather than using the old one and it now works fine.
cheers,
John