August 19, 2010 at 6:45 am
hello,
i have 2 machines with Sql Server 2008:
1 with reporting services (OS: windows 2008 R2) and the other 1 is being used for DWH (OS: windows 2003)
the 2008 machine is a new one and before i will transfer all of our report i'm checking it.
i found out that we have a serious problem , i'm running a simple report that run from the report manager, this report used to run on the old machine in 2-3 sec, now from the new machine it takes it around 50 sec to return.
I've did some checks with sql server profiler, it seems that the report server send the query to the DB only after 45-46 sec and once it there the db return the query result in 1 sec and then the report display the result.
I've also checked the server performance (processor, IO , memory) everything seems to look o.k.
can anyone advice regarding this phenomena?
thanks,
Dave.
April 14, 2011 at 7:27 am
Hey
I am getting same problem.. I am using 2008 R2. report is runnning fine in SSSRS. When I same report on Report Manager Its taking some time .. after that it sending parameter values to DB and one more thing is Report Manager giving me empty report where SSRS giving report with data.
Please let me know what did u do, when u face the same problem.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply