January 13, 2011 at 8:05 pm
Hi guys,
Have an interesting problem here. My report executes a stored proceedure and contains two tables with within the list control. Dev environment has more data volume and renders the report in 15 seconds MAX. The test environment has lower data volume but takes ages to render the report.
Executing the SP in SSMS against test server takes flat 2 seconds to execute the stored proceedure. Was not sure where to check to resolve the issue.
PS. reporting services is installed on a different server to the database server.
Any suggestions would be welcome.
Thanks,
bala
January 14, 2011 at 8:23 am
Are Dev and Test the same hardware configuration, memory, CPU, disk IO paths etc? Do they have the same amount of activity, i.e. same users, same processes occurring? It would be unfair to compare the performance of a very under utilized Dev server with a test server that may be running many other processes...
Have you taken a trace of the queries to find out the actual execution plans? are they the same for both?
Have you taken a look at the execution log on both instances to see what is taking the time? Data retrieval, Processing or rendering?
-Luke.
January 14, 2011 at 8:30 am
One place I would start with this is to run the SP by itself in SSRS. You can do this by opening up the query designer in the dataset properties. This way, you will know whether it is running the SP itself or that SSRS rendering is slow.
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply