July 23, 2008 at 11:21 am
Hi. Was wondering if anyone has encountered this before. We're using SSRS/SQL 2005 for several reports. One in particular however seems to slow down in processing - over time. So, right after we deploy it, it runs quickly - in 10 seconds for example. Over a week or so, using the same parameter values, execution will slow down such that even if you let it run for several minutes, you don't get results. It just keeps cranking. So far, the fix seems to be to rename the report's stored procedure, re-build the report then re-deploy it. Then the cycle repeats.
Any thoughts?
Thanks,
Amy
July 23, 2008 at 12:11 pm
Did you eliminate the sored procedure as the culprit in this case. How are the stored procedure run times, on the first day compared to a week after, when you run the Stored proc in sql management studio
August 1, 2008 at 2:55 pm
thats right! sounds more like a procedure problem. try with recompile, just to be sure that a wrong (not optimal) plan is not being stored for subsequent executions
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply