November 21, 2011 at 8:06 am
I have a report defined that executes a stored procedure(SP). When the report is run, the stored procedure runs for a while (>10 min) and doesn't return results. When I profile the SP and run this in SSMS, results are returned in 40-45 seconds.
I've thought of parameter sniffing, but don't think that's the problem because I've called the SP just the way it's passed through to SSMS.
I've created a nieuw SP and called the new SP, but same result.
Our situation:
ReportServer: SSRS 2008R2
SSMS: 2005
Any ideas?
November 21, 2011 at 8:10 am
You can do a 2nd test.
Run that sp from withing bids (data / query window).
You'll see if the results are getting returned correctly. Then you can do the same on the report server.
Once you know that is NOT the issue then you know that the rendering is the issue (too much code, groups, iifs, conditional formatting, etc).
1 option is to change the sp to return the least possible amount of data so that you have less rendering work.
November 21, 2011 at 8:11 am
If you want to tune the SP as well you can post the execution plan (actual) so we can look it over.
45 sec is on the slow end, even for reports.
November 21, 2011 at 8:33 am
What version of SSRS are you using?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply