Web Analytics: Monitors the health of the Report Consolidator component (SharePoint Foundation 2010)


Applies to: SharePoint Foundation 2010

Rule Name:   Web Analytics: Monitors the health of the Report Consolidator component

Summary:   Typically, the Report Consolidator component should not take more than two hours to run. This rule is triggered if it takes longer than five hours.

Cause:   The Report Consolidator component takes longer than five hours to run.

Resolution:   Enable data trimming by using Windows PowerShell

  1. You can enable data trimming using the Set-WebAnalyticsServiceApplication cmdlet. When data trimming is enabled, the number of rows of data in the tables in the reporting database is trimmed to 20,000 rows per day per component (site, site collection, Web application, etc.). This decreases the time that the Reporting Component takes to run.

  2. Verify that you meet the following minimum requirements: See Add-SPShellAdmin.

  3. On the Start menu, click All Programs.

  4. Click Microsoft SharePoint 2010 Products.

  5. Click SharePoint 2010 Management Shell.

  6. At the Windows PowerShell command prompt, type the following command:

    Set-SPWebAnalyticsServiceApplication [-Identity <GUID>]-EnableDataTrimming


    • <GUID> is GUID identifier of the Web Analytics service application. If you only have one Web Analytics service application, you do not need to specify the GUID.

For more information, see Set-SPWebAnalyticsServiceApplication.


We recommend that you use Windows PowerShell when performing command-line administrative tasks. The Stsadm command-line tool has been deprecated, but is included to support compatibility with previous product versions.