When the SharePoint Web Analytics Service Application takes longer than five hours to process the Health Monitor will report the “Web Analytics: Monitors the health of the Report Consolidator component” for review.
It offers the following explanation:
The running time for the Report Consolidator component should always be less than 12 hours.
With the following suggested remedy:
Consider adding more reporting databases for the service application to balance the load. For more information about thise rule, see http://go.microsoft.com/fwlink/?LinkID=142704.
The provided link instructs on how to reduce the amount of records processed, not how to add additional databases to balance out the load.
To add additional databases:
Open the SharePoint Management Shell (PowerShell) on the SharePoint server (run as administrator).
Use the Get-SPWebAnalyticsServiceApplication cmdlet to identify the current database server and name (use the name of your service application):
Get-SPWebAnalyticsServiceApplication -identity "Web Analytics Service Application"
Use the Set-SPWebAnalyticsServiceApplication cmdlet to set the staging databases to include a new one. Be sure to include the existing one and the new one specified will be created when running the cmdlet.
Set-SPWebAnalyticsServiceApplication -identity "Web Analytics Service Application" -ListOfStagingDatabases "<StagingDatabases><StagingDatabase ServerName='DBServer' DatabaseName='ExistingDatabase' /><StagingDatabase ServerName='DBServer' DatabaseName='NewDatabase' /></StagingDatabases>"
The additional database has been added and the “Reanalyze Now” button on the Health Monitor item can be used to remove the message from the Health Monitor.
