November 21, 2011 at 8:08 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:11 am
Please don't cross-post, it fragments replies and wastes everyone's time.
Forward all replies here => http://www.sqlservercentral.com/Forums/Topic1209305-1063-1.aspx
November 21, 2011 at 8:12 am
sorry, had first posted the message under dev SSRS 2005.;-)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply