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?