goofaholix
MIS
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
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