Performance Tips for SSRS Reports

Here are a few tips I’ve discovered whilst building SSRS reports to host in SharePoint. Some of these are report based tips and a few apply to SharePoint. I willadd to and update these as I discover more.

1. [Report based] Avoid using the Total Pages built in field as if you use this the rendering engine has to complete a full pre-render of the entire report primary dataset before it starts the final render. This can add a great deal of processing overhead and the report will take much long to finally display;

2. [Report based] Ensure results are paged. This should occur by default but if you choose to turn it off for your report there is a risk that you will encounter problems as the HTML rendering format that is used to initially render a report opens the report in your browser. If the report is not paginated, all of the data is included in a single page, which cannot be accommodated by most browsers.

3. [SharePoint] If the source data changes infrequently consider setting up dataset caching and make use of Shared Datasets to reduce the number of cached results stored on the server.

4. [SharePoint] Consider the usage scenario of the reports and where appropriate implement caching of the report. For example if the report is a monthly financial statistics summary you could cache the report once a month rather than have it dynamically update everytime someone views it.

Advertisements

1 Comment

Filed under Business Intelligence, SharePoint 2013

One response to “Performance Tips for SSRS Reports

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s