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
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 WorkflowTemplates cm98 Verbose TriggerWebAnalytics 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 Executingall 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 Executingthe 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