Post reply

Stored procedure performance

  • November 21, 2011 at 8:10 am

    #1410739

    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

    #1410742

    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

    #1410767

    What version of SSRS are you using?

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply