Reporting Service Statistics

Question:
How do I obtain statistics for the utilization of SSRS reports?

Solution:

With a little research I found a great sample application on codeplex that provides statistics for SSRS.  The Server Management Sample Reports are available for both SQL Server 2005 & 2008.

The following solution provides answers to the following questions.  What are the top 10 most executed reports? What reports have the longest average execution time?  Who is accessing the reports?

SSRS Analytics

To implement this solution all you have to is download the sample solution and follow the installation guide.  If you have any questions post them here and I will do my best to help you out.

Leave a Reply

Your email address will not be published. Required fields are marked *

For security, use of Google's reCAPTCHA service is required which is subject to the Google Privacy Policy and Terms of Use.

This site uses Akismet to reduce spam. Learn how your comment data is processed.