Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

Using PowerPivot to Monitor Report Services

  • 7 August 2012
  • Author: MikeDavis
  • Number of views: 297
  • 0 Comments

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:

PowerPivot SSRS

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.

Print
Categories: Big Data, SQL Server
Rate this article:
No rating
MikeDavis

MikeDavisMikeDavis

Other posts by MikeDavis

Please login or register to post comments.