Post reply

Stored procedure performance

  • November 21, 2011 at 8:08 am

    #246637

    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

    #1410741

    Please don't cross-post, it fragments replies and wastes everyone's time.

    Forward all replies here => http://qa.sqlservercentral.com/Forums/Topic1209305-1063-1.aspx

  • November 21, 2011 at 8:12 am

    #1410744

    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