Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

2008 Report Server preformance

Status
Not open for further replies.
Jul 19, 2003
132
NZ
We are in the process of migrating our SSRS 2005 reports onto a new SSRS 2008 server.

We are seeing execution times of the same reports on each server considerably slower on the new server.

A sample large report I've used for benchmarking by scheduling it to run hourly over a day typically runs in 4-5 minutes on the old server and in 20-25 minutes on the new server.

Wheras is I run the query itself on each server through management studio they both do it in about 3 minutes.

This suggests to me that the problem is prbably ion the configuration of the report server. There is no hardware or operating system difference between the two that could account for the differencem, if anything the new server should be faster.

I know in 2005 there where IIS tweaks that improved performance but assume these no longer apply in 2008 as IIS is not used.

Can anyone suggest articles on what settings etc I should be looking at to resolve this?

Thanks

Bruce



 
I never noticed any performance differences upgrading.

However, 4-5 minutes is an extremely long time to render a report. Unless this report is rendering a lot of rows, you could probably do well to optimize the queries.

If it is rendering a lot of rows--hundreds or thousands of pages--have you moved from running SSRS on the same server as the database to a new server? If this is the case, then you will have introduced network lag into the equation. I'm doubting this is the case though, since there would rarely be the need to generate a report that large.
 
This sample report was made large on purpose to benchmark performance between our servers.

Most of our reports run within 10 seconds or are scheduled, however these are also generally taking twice as long on the new server which is why I created the above report to test performance.

Bruce

 

Were the SQL database on the old SSRS server on the same windows server, is the new one now on a different server?

Has there been any changes to the physical locations etc, (Moving to new building, across a site etc)

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)
 
I have seen this raised in other forums where Microsoft SSRS Developers were present - they suggested that the issue would be likely be in hardware setup (all other things being equal) rather than anything specifically to do with SSRS 2008

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
Have you updated statistics/indexes on the new copy of the DB you report on? Perhaps as it is being built it's not being "maintained" yet.
 
The database on both servers is set to auto create and update statistics.

The table on each server doesn't have indexes, I found by testing that adding indexes didn't improve performance in fact it tended to reduce it.

The table I'm using for testing was copied from the new server to the old so I could be sure it was the same.

Bruce

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top