Search:
Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in SQL Server Reporting Services (SSRS)

Interview Question :: I need to fix a very slow performing SQL Server Reporting Services report server

I am experiencing extremely slow performance on my company's reporting server with only one report. There are currently about 30 reports hosted on the server, the vast majority of which will load within a few seconds after having being selected; however, one report on average takes about 5
minutes to load. Previously, when first added to the server several months ago, the report performed just fine, but in recent weeks the load time has signifcantly degraded.

Answers to "I need to fix a very slow performing SQL Server Reporting Services report server"

RE: I need to fix a very slow performing SQL Server Reporting Services report server?
Have a look at the data that your report is selecting from your server. It could be that it's doing a massive join which performed OK with only 10 rows, but now it's dealing with 100 rows has grown exponentially. I'm assuming you're not running this report at a different time of day where the load on the server is different from the other reports running, and that there are no contention issues - have you checked locks? I'd say it must be a programming issue with the report -have you checked CPU usage on the box, is there enough ram to generate the report or is the server swapping? Have a look at the data though, and the number of rows returned - if possible separate the SQL from the report and run that via a console, does it still take as long?
Vote for this answer ::

RE: I need to fix a very slow performing SQL Server Reporting Services report server?
Use the sql query analysis tool, it will tell you where to index your tables and other such performance improovment techiniques.
Vote for this answer ::

Notify me whenever an answer is posted for this question Update Alert Setting

Top Tags

- Sharepoint Developer Interview Questions - Java Interview Questions - J2EE Interview Questions - ASP.NET Interview Questions - MOSS 2007 Interview Questions - WPF Interview Questions - Microsoft CRM Interview Questions - Technical Interview Questions for Programmers

Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in SQL Server Reporting Services (SSRS)

Interview Question :: I need to fix a very slow performing SQL Server Reporting Services report server

Top Tags