Report Snapshots in SSRS 2008 R2

Introduction

Specifying Credential

1. Report snapshots are stored in ReportServer database and hence you need to plan for additional storage requirements for this database. Though you can minimize it by limiting the maximum number of snapshots to be maintained at a time in the report history.

2. All the data sources used in the report must have credentials saved with it or with no credentials.

3. All the query parameters of the report must have default values defined for it.

4. Schedule report snapshot to be created during off peak hours.

5. A report served / rendered from report snapshot represents the data when the snapshot was created and might not be up to date.

6. Report snapshots are created for two main purposes, first to reduce the load or processing time on the database server during peak hours by creating report snapshots during off peak hours and second, to create report history (to see/analyze how data has changed over time) either by weekly, monthly, etc.

Conclusion

In this article I talked about how SSRS improves the performance of report rendering by utilizing the report snapshot, how to configure a report snapshot and how to define report execution properties to render the report from the report execution snapshot.

Resources

Setting Report Processing Properties
Report and Snapshot Size Limits

See all articles by Arshad Ali

Arshad Ali
Arshad Ali
Arshad Ali works with Microsoft India R&D Pvt Ltd. He has 8+ years of experience, mostly on Microsoft Technologies. Most recently, as a SQL Developer and BI Developer he has been working on a Data Warehousing project. Arshad is an MCSD, MCITP: Business Intelligence, MCITP: Database Developer 2008 and MCITP: Database Administrator 2008 certified and has presented at several technical events including SQL-School. On an educational front, he has an MCA (Master in Computer Applications) and MBA-IT. Disclaimer : I work for Microsoft and help people and businesses make better use of technology to realize their full potential. The opinions mentioned herein are solely mine and do not reflect those of my current employer or previous employers.

Latest Articles