Hello All,

 

Recently working with a customer we needed to figure out how long it would take to transfer data from staging database to reporting database for the Web Analytics Service in SharePoint 2010, and this is what I found

 

You need to turn up diagnostic logging for Web Analytics Services -> Component Controller and Web Analytics Services -> Workflow Templates

  1. Allow Web Analytics to run it’s course over a 24 hour period of time
  2. Look for when the Web Analytics Trigger Workflows Timer Job, you can do this by searching the ULS logs for an entry with this info
    1. Process = OWSTIMER.exe
    2. Product = Web Analytics Services
    3. EventID = cm98
    4. Message = Trigger WebAnalytics workflow templates: Start
  3. Then for each Site you will find the following Event which represents the start of the process for that site
    1. Process = WebAnalyticsService.exe
    2. Product = Web Analytics Services
    3. EventID = c2fg
    4. Description = Executing all the service applications.
  4. Then for each Site you will find the following Event which represents the end of the process for that site
    1. Process = WebAnalyticsService.exe
    2. Product = Web Analytics Services
    3. EventID = c2ey
    4. Description = Executing the service application Web Analytics Service Application completed.

This could be a very large undertaking to drill into the data, so here is something you could do to improve your work

Based on the job description in Central admin you should have a general idea of when the timer job ‘Web Analytics Trigger Workflows’ based on that time run this command

Merge-SPLogFile –Path <C:\TimerJobStart.log> -StartTime “11/28/2012 11:24:00” –Area “Web Analytics Services” –EventID “cm98”

In your output log you will get a line like this

11/28/2012 11:25:16.92 OWSTIMER.EXE (WEASP03:0x0FF8)           0x062C  Web Analytics Services Workflow
Templates       cm98     Verbose               Trigger
WebAnalytics workflow templates: Start            ecc70793-f264-4811-8b8d-1ce480f66c2d

Then based on the time from that line run the following command

Merge-SPLogFile –Path <C:\Start.log> -StartTime “11/28/2012 11:25:16” –Area “Web Analytics Services” –EventID “c2fg”

Take the time from the first line and this is your start time

11/28/2012 12:21:39.77 WebAnalyticsService.exe (WEASP03:0x046C)         0x08F4  Web Analytics Services             Component Controller    c2fg       Verbose               Executing
all the service applications.       

Then take the time from the last line and run the following command

Merge-SPLogFile –Path <C:\End.log> -StartTime “11/28/2012 11:25:16” –Area “Web Analytics Services” –EventID “c2ey”

Then based on that file take the time from the last line and you have your end time

 11/28/2012 12:43:50.70 WebAnalyticsService.exe (WEASP03:0x046C)         0x1418  Web Analytics Services             Component Controller    c2ey       Verbose               Executing
the service application Web Analytics Service Application completed.

So in my case the process ran from 12:21 to 12:43 for a total of 22 minutes, I of course have a very small environments with very little traffic and I imagine that in your environment the process would be much longer.

Hope this helps you