Are the stat rollup procedures present in the VC database under Programmability --> Stored Procedures?
Are the SQL agent jobs call Past Day rollup/etc present under SQL Server Agent --> Jobs?
When did they last run and when are they due next to run? Do they have any errors in their history? (Right click the job and click history)
Is the SQL agent service running? Check services.
Restart your hostd processes on the esx hosts as well. service mgmt-vmware restart, service vmware-vpxa restart
You were right, I did not even realize that these jobs should exist. I am not sure why they were not created automatically in SQL but this thread gives the exact procedure on how to add them if they are not there:
I will monitor it over the next few days and hopefully historical data will now start accumulating.
kjb007 - Do you think I still need to restart some processes to make this work? I am going to show my ignorance here, I am not sure how to get to the command line on my two ESX servers in order to invoke these commands.
If the rollup jobs are not running, then it's a database thing. If they were running, and you weren't seeing updates, then I would say it may be a process thing. Get the jobs done first, and then if they are still not working, come back to the console, and restart the service.
To get to the command line, on your ESX console hit Alt+F1, and you'll see a login prompt. Login with root and your password, and you'll see a prompt. Then, you can run console commands as you'll see requested fairly often here.
Make sure you leave points for correct and/or helpful posts when you mark your question answered.
Message was edited by: kjb007