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?
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.
0 Responses
Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.