SSRS2008R2 report times out, but the underlying query executes in the Management Studio

Posted by Matthew Belk on Server Fault See other posts from Server Fault or by Matthew Belk
Published on 2011-11-16T20:19:07Z Indexed on 2011/11/17 9:56 UTC
Read the original article Hit count: 367

Filed under:

ssrs-2008-r2

A customer of mine recently moved servers and the new server has SQL2008R2. His old server was SQL2005. The new server has substantially better CPU, RAM, and disk performance than the old, but several reports time out while executing.

When I run the underlying query in the SQL Management Studio, the query executes in sub-second time.

The exact error message returned via the Report Manager UI is:

An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. (rsReportServerDatabaseError) Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

It must be noted that this database is not just analytical; it's also fairly transactional, although the transaction volume is not exceptionally high.

What can I do to improve the performance of the SSRS query engine? Are there settings in the data source I can adjust, or in the SSRS config files?

Related posts about ssrs-2008-r2

How to enable SSIS as data source type on SQL Server Reporing Services SSRS 2008 R2

as seen on SQL Server Central - Search for 'SQL Server Central'
when you create a data source in SSRS 2008 R2 (Nov CTP), you won't be able to get SSIS listed as a data source type. Therefore applications that are already using it as a data source or applications that require it as a data source get stuck. Let's learn how to enable and get SSIS listed back as… >>> More
SharePoint 2010 Hosting - ASPHostPortal :: Installing SSRS 2008 R2 on SharePoint 2010

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
What do you need first? Please download SQL Server® 2008 R2 November CTP Reporting Services Add-in for Microsoft SharePoint® Technologies 2010 and please follow this steps: 1. Install a SharePoint technology instance. (Already did this when installing PowerPivot with SharePoint) 2. Install SQL Server… >>> More
Force SSRS 2008 to use SSRS 2005 CSV rendering

as seen on Stack Overflow - Search for 'Stack Overflow'
We are upgrading our report server from SSRS 2005 to SSRS 2008 R2. I have an issue with CSV export rendering for SSRS 2008 where the SUM of columns are appearing on the right side of the detail values in 2008 instead of the left side like in 2005 as shown in the below blocks. 117 and 131 are the sums… >>> More
Automating an SSRS 2008 R2 Report Snapshots and run report with most recent data

as seen on Server Fault - Search for 'Server Fault'
I would like to automate a report snapshot, but there is only an option to take a snapshot in the Report History Tab. All the resources I've found suggest I need to go to processing options and select "Render this report from a snapshot". But I don't want to do that - when I go to a report, I want… >>> More
Can I execute an SSRS report from a windows batch file?

as seen on Server Fault - Search for 'Server Fault'
We are using SQLServer 2008R2 and would like to run and SSRS report from a windows batch file. We're loading data warehouse tables using a third party scheduler program and at the end our dataload we want to run a data quality report using SSRS. I can create report subscribtions to email the report… >>> More

Developer IT