Reporting on Reporting Services
You can gain a lot of information from SSRS directly from the SSRS databases. Here are some questions about which you may have wondered:
• How many reports are run daily?
• Which reports are run most often, and by whom?
• Which reports have queries that run for a long time, or perhaps return large amounts of information?
• Which reports are NEVER run?
Some of the reports discovered by this process may make good candidates for report subscriptions, caching, or snapshots as described in the “Optimizing SSRS Performance” section.
Start by examining the data located in the report execution log on the reporting services database. This data is exposed by the reporting server views, with more information about the three ...