On reports maintenance and monitoring
http://www.sqlmag.com/article/reporting2/sql-server-reporting-services-questions-answered
Basic idea is to utilize the execution log table inside report server. However , the data in this table will be removed automatically after 60 days. Therefore, you need to run a package from MSFT to move those log data into a separate database and start to report from there.
No comments:
Post a Comment