Web analytics not logging the reports
Issue with the web analytics
reports. it is not logging the statistics any more after a period of time. The
running time for the Logging Extractor component should always be less than the
threshold value. The issue is due to the running time for the Logging Extractor
component exceeds the threshold value. Before applying the below resolution,
ensure that the issue is with the threshold only by checking the logs and rest.
Resolution: Add more staging databases for the Web
Analytics service to balance the load.
1.
Verify
that the user account that is performing this procedure is a member of the Farm
Administrators group.
2.
On
the Central Administration Home page, in the Application Management section,
click Manage service applications.
3.
On
the Manage Service Applications page, click the Web Analytics service for which
you want to add more staging databases.
4.
On
the ribbon, in the Operations group, click Properties.
5.
In
the Edit Web Analytics Service Application dialog box, click Next.
6. In the Edit Web Analytics Service Application Topology dialog box, click New, and then click Staging Database.
6. In the Edit Web Analytics Service Application Topology dialog box, click New, and then click Staging Database.
7. In the Add New Database dialog box, type the database server name and the staging database name(New DB name), and then click OK.