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.
Tagged with: load time • slow performance
Filed under: sql server hosting
Like this post? Subscribe to my RSS feed and get loads more!
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?
Use the sql query analysis tool, it will tell you where to index your tables and other such performance improovment techiniques.