SSRS 2014 just randomly slow response for a while

  • I have 6xSSRS 2014 servers running same set of reports. All reports point to the same SQL Server 2008 Database. All reports call SP in database server to get result back and render. Report are running fine in SSRS 2005 before move to SSRS 2014. When call the same report, sometime response very quick , sometime very slow. We notice that when report is slow response (loading) , %CPU of report server is 0% , it will 0% for a while and the spike up (and then report is being display). This happen all the time during working hours.

    Each report server got about 400-1,000 session during working hours.

    At first, we move from SSRS 2005 to SSRS 2014 SP1, we experience the service halt after certain amount of load (the same load on SSRS 2005), manually reset service is work around at that time. After update to SSRS 2014 SP1 CU2 , just not need to manual reset the service it will comeback after a while (CPU 0%) like the symptom described in first paragraph.

    Anybody experience this kind of problem, please help

    many thanks

    Ken

  • for example the %CPU of brown line just go down to near 0 about 1 min

  • I'd check the SSRS log for whatever server is experiencing the slow down and see what SSRS is doing at the time since it could be something like recycling. Other issues as well but I'd check that first.

    Sue

  • thanks Sue

    most of the errors i got from log file is following

    rshost!rshost!804!09/22/2016-11:56:28:: e ERROR: WriteCallback(): failed to write in write callback.

    rshost!rshost!804!09/22/2016-11:56:28:: e ERROR: Failed with win32 error 0x0079, pipeline=0x000000087B04F7E0.

    rshost!rshost!12f8!09/22/2016-11:56:28:: e ERROR: HttpPipelineCallback::SendResponse(): failed async writing response.

    rshost!rshost!12f8!09/22/2016-11:56:28:: e ERROR: Failed with win32 error 0x0079, pipeline=0x000000087B04F7E0.

    httpruntime!ReportServer_0-4!12f8!09/22/2016-11:56:28:: e ERROR: Failed in BaseWorkerRequest::SendHttpResponse(bool),

    httpruntime!ReportServer_0-4!2a8!09/22/2016-11:54:33:: e ERROR: Failed in BaseWorkerRequest::SendHttpResponse(bool), exception=System.Runtime.InteropServices.COMException (0x80070079): The semaphore timeout period has expired. (Exception from HRESULT: 0x80070079)

    at Microsoft.ReportingServices.HostingInterfaces.IRsHttpPipeline.SendResponse(Void* response, Boolean finalWrite, Boolean closeConn)

    at ReportingServicesHttpRuntime.BaseWorkerRequest.SendHttpResponse(Boolean finalFlush)

    library!ReportServer_0-4!2a8!09/22/2016-11:54:33:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: RsWorkerRequest::FlushResponse., Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_MSSQLSERVER_0-4-131189900751945773. ---> System.Runtime.InteropServices.COMException (0x80070079): The semaphore timeout period has expired. (Exception from HRESULT: 0x80070079)

    at ReportingServicesHttpRuntime.BaseWorkerRequest.SendHttpResponse(Boolean finalFlush)

    at ReportingServicesHttpRuntime.RsWorkerRequest.FlushResponse(Boolean finalFlush)

    and

    library!ReportServer_0-4!1508!09/22/2016-12:04:04:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.;

    I try configure more execution time out for latter error, but still no clue on first one.

    More information, when load on reportserver is not peak, it work fine

  • The first one I've seen before when the SSRS service account doesn't have full permissions to the RSTemp directory under ReportingServices directory. So you may want to check that.

    And then you do have a recycle going on so you may want to adjust the time for RecycleTime. It may just be hitting at times when the report server is busy, although memory pressure can kick it off as well.

    This article goes through how this works, where it's set, etc:

    https://msdn.microsoft.com/en-us/library/bb934330(v=sql.120).aspx

    I'd probably want to check with Perf Mon and see how the memory is on that server. It could be under powered, maybe not. But some of what you are seeing can be due to memory pressure.

    Sue

  • Hi Sue,

    I've monitored my SSRS and no sing of memory pressure, and SSRS service account has modified permissions to the RSTemp directory under ReportingServices directory. I forgot to mention that i implemented anonymous access as following http://www.swarndeep.com/2011/12/setting-up-anonymous-access-for.html.

    FYI my report can run but intermittently halt and found this errors most in the log file

    "Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.;

    "

    thanks,

    Ken

  • ken-1076966 (9/22/2016)


    for example the %CPU of brown line just go down to near 0 about 1 min

    What are all the other lines and what is their scale?

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Hi Jeff

    The bold lines are %Processor Time _Total of 6 SSRS 2014 servers with 1.0 scale

    The dot lines are Memory --> Available Mbytes of 6 SSRS 2014 servers with 0.001 scale

Viewing 8 posts - 1 through 7 (of 7 total)

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