SQL Centre of Excellence

Analysing Report Server Logs

by Bob Duffy 4. March 2015 08:54

Attached is the example Power Pivot Model I used to analyse Report Server Logs complete with 3D pie chart to shock the DataViz world ;-)

I want to get time to extend this to include a lot of the “version 3” data which includes per Dataset metrics on query and processing time.

Feel free to use this as a starting point for analysing Report Server performance or usage.

image

You’ll need to update the connection in the Power Picot window to point to your ReportServer database.

 

ReportServerLogs.xlsxReportServerLogs.xlsx

ReportServerLogs.xlsxReportServerLogs.xlsx

Page List

Page List