You may be already experimented this issue with System Center Orchestrator 2012 RC, the statistics available in the web console are never updated and always stay at zero. The two print screens below represent the problem that I had in my lab environment :
This problem is due to a SQL Store procedure that doesn’t start and doesn’t update the statistics in the web console.
To solve that, the very first step is to ensure that the SQL Broker in enable on your SQL Server. Go to you SQL Server and run the following Query :
select is_broker_enabled from sys.databases where name= ‘Orchestrator’
If it is not (you get a return value of 0) then you need to enable it by doing the following:
alter database Orchestrator set enable_broker WITH ROLLBACK IMMEDIATE
Now, we’ll check the last execution time of the procedure that is taking care of the statistic update. Execute the follow query :
FROM [Orchestrator].[Microsoft.SystemCenter.Orchestrator.Maintenance].[MaintenanceTasks] [m]
We could see that the LastExcutionTime of the Statistics store procedure is MARCH 15, or this normally procedure has to run every 10 minutes (600 seconds). It’s clear that something is going wrong there.
To start manually this procedure, we have to run the follow query :
EXEC [Microsoft.SystemCenter.Orchestrator.Maintenance].[EnqueueRecurrentTask] @taskName = ‘Statistics’
After a few seconds, we must find some data in the following table :
Running manually the procedure must solve the issue in the majority of the case, but if you still have any statistic data after running all the SQL queries above, it’s certainly due to your SQL Server that is not working properly.
In fact, it was my case, still no updated statistics. if like me, you are running your lab SQL server in a VM on your laptop, VM that you never shutdown /reboot, but always use the PAUSE feature. This could cause some problem with the SQL Store procedures.
How to solve that ? Simply reboot your SQL Server. After the reboot, my statistic updated automatically.
I hope this help you
Thanks to Travis Wright and Chris Sanders for their help on this topic.