I need to fix a very slow performing SQL Server Reporting Services report server.?

Question

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.

Answer 1

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?

Answer 2

hi omu, fairly some cases all counsel wander off in information so enable's get all of your device methods lower back so reboot your device once you spot your living house windows emblem initiate tapping f8 this may convey you to a danger-free mode web page scrol right down to very last good configuration at the same time as my device acted properly (develop) once you get lower back to destop hit initiate>courses>upload-ons>device methods scrol right down to device restoration snf there you'll see a calender hit the first lit kind on your left your device will restoration then reboot. once you get lower back hit initiate>settings>administration panel hit internet concepts icon there delete your history and your cookies. then go out once you're lower back at your laptop flow lower back to device methods and defragment this can be a compulsory step so be sure it completes this step. good success wish i became effective to you

Answer 3

Use the sql query analysis tool, it will tell you where to index your tables and other such performance improovment techiniques.