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 ...
Get System Center 2012 Configuration Manager Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
