Home Forums Reporting Services Reporting Services SSRS Report runs okay in Visual Studio but times out on Report Manager RE: SSRS Report runs okay in Visual Studio but times out on Report Manager

  • February 22, 2018 at 12:34 pm

    #1980835

    jonathan.crawford - Wednesday, February 21, 2018 2:48 PM

    lastly, I've had the issue where it was cleared up by creating an internal variable within the stored proc behind the report, and passing in the input to the internal variable instead of the input variable. I have absolutely no idea why that helped, but it was night and day.

    This is a parameter sniffing related issue - and that can solve the performance problem.  It would also indicate to me that there are two (or more) plans for that procedure - one for logging into SSMS and a separate one coming from SSRS.

    You can also get separate execution plans by simply using a different login/user.  If the objects in the code are not schema qualified - and each user has a different default schema defined then a separate execution plan will be generated for each user schema that calls the procedure.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs