Using PowerPivot to Monitor Reporting Services

PowerPivot is a powerful new tool from Microsoft that has been improved even more in the 2012 release, which you can download for free here. In this blog I will give you a PowerPivot workbook that I created to connect to the Reporting Services logs and pull data. This gives you the ability to see the performance of your report server very easily.

Report Example:

image

Keep in mind that all the data in PowerPivot is pulled into memory so if you have a large reporting environment you may have to limit the data with a where clause on the query in the work book. The instructions are in the workbook.

Download the workbook here and let me know what you think.

This was created with PowerPivot 2012 and connected to SSRS2008 R2 log.

About these ads
This entry was posted in powerpivot, Syndication and tagged , , . Bookmark the permalink.

2 Responses to Using PowerPivot to Monitor Reporting Services

  1. Raga says:

    Mike, I am receiving error below. Can you please help with this?
    The size of a data value in table ‘ExecutionLog2_xxxxx’ column ‘Parameters’ was too large to fit in that column.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s