SSRS Performance degradation












2














I have a fairly busy SSRS Instance and the redering performance is consistently degrading to the point where we have set the recyle time config to 60 as work around and im still getting significant reduction in rendering performance within the hour. once the 60 minutes passes the performance goes back to an acceptable level and begins to degrade once more.



I have played with the memory settings within the config but it doesnt seem to have made a difference. The server is dedicated to SSRS and there doesnt seem to be any memory pressure. at this second theres 32gb of memory and 28gb free with SSRS using around a gig.



Looking in the log we have a lot of the following error



httpruntime!ReportServer_0-193!2b84!05/17/2018-15:14:52:: e ERROR: Failed to 
create worker request: pipeline=0x56C27945E0, exception=Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_INST130_0-193-131710375157483972. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeException: An error occurred in the HTTP Runtime object for application domain ReportServer_INST130_0-193-131710375157483972. Most likely, the HTTP request contains an unsupported verb or invalid syntax.
rshost!rshost!2b84!05/17/2018-15:14:52:: e ERROR: HttpPipelineCallback::SendResponse(): failed writing response.
rshost!rshost!2b84!05/17/2018-15:14:52:: e ERROR: Failed with win32 error 0x10DD, pipeline=0x00000056C27945E0.
httpruntime!ReportServer_0-193!2b84!05/17/2018-15:14:52:: i INFO: RsHttpRuntime::ProcessRequest(): calling EndOfRequest() from exception handler of worker request constructor. Runtime=ReportServer_INST130_0-193-131710375157483972. Pipeline=0x56C27945E0.
rshost!rshost!2b84!05/17/2018-15:14:52:: e ERROR: Failed to process request 0x800710dd, pipeline=0x00000056C27945E0.
library!ReportServer_0-193!2218!05/17/2018-15:14:53:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeException: Unsupported HTTP verb 3., Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeException: An error occurred in the HTTP Runtime object for application domain ReportServer_INST130_0-193-131710375157483972. Most likely, the HTTP request contains an unsupported verb or invalid syntax.;
library!ReportServer_0-193!2218!05/17/2018-15:14:53:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: Failed to fill worker request, Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_INST130_0-193-131710375157483972. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeException: An error occurred in the HTTP Runtime object for application domain ReportServer_INST130_0-193-131710375157483972. Most likely, the HTTP request contains an unsupported verb or invalid syntax.
at ReportingServicesHttpRuntime.BaseWorkerRequest.FillWorkerRequest()


I have been looking into this on and off for a while and im coming up blank.










share|improve this question



























    2














    I have a fairly busy SSRS Instance and the redering performance is consistently degrading to the point where we have set the recyle time config to 60 as work around and im still getting significant reduction in rendering performance within the hour. once the 60 minutes passes the performance goes back to an acceptable level and begins to degrade once more.



    I have played with the memory settings within the config but it doesnt seem to have made a difference. The server is dedicated to SSRS and there doesnt seem to be any memory pressure. at this second theres 32gb of memory and 28gb free with SSRS using around a gig.



    Looking in the log we have a lot of the following error



    httpruntime!ReportServer_0-193!2b84!05/17/2018-15:14:52:: e ERROR: Failed to 
    create worker request: pipeline=0x56C27945E0, exception=Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_INST130_0-193-131710375157483972. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeException: An error occurred in the HTTP Runtime object for application domain ReportServer_INST130_0-193-131710375157483972. Most likely, the HTTP request contains an unsupported verb or invalid syntax.
    rshost!rshost!2b84!05/17/2018-15:14:52:: e ERROR: HttpPipelineCallback::SendResponse(): failed writing response.
    rshost!rshost!2b84!05/17/2018-15:14:52:: e ERROR: Failed with win32 error 0x10DD, pipeline=0x00000056C27945E0.
    httpruntime!ReportServer_0-193!2b84!05/17/2018-15:14:52:: i INFO: RsHttpRuntime::ProcessRequest(): calling EndOfRequest() from exception handler of worker request constructor. Runtime=ReportServer_INST130_0-193-131710375157483972. Pipeline=0x56C27945E0.
    rshost!rshost!2b84!05/17/2018-15:14:52:: e ERROR: Failed to process request 0x800710dd, pipeline=0x00000056C27945E0.
    library!ReportServer_0-193!2218!05/17/2018-15:14:53:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeException: Unsupported HTTP verb 3., Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeException: An error occurred in the HTTP Runtime object for application domain ReportServer_INST130_0-193-131710375157483972. Most likely, the HTTP request contains an unsupported verb or invalid syntax.;
    library!ReportServer_0-193!2218!05/17/2018-15:14:53:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: Failed to fill worker request, Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_INST130_0-193-131710375157483972. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeException: An error occurred in the HTTP Runtime object for application domain ReportServer_INST130_0-193-131710375157483972. Most likely, the HTTP request contains an unsupported verb or invalid syntax.
    at ReportingServicesHttpRuntime.BaseWorkerRequest.FillWorkerRequest()


    I have been looking into this on and off for a while and im coming up blank.










    share|improve this question

























      2












      2








      2







      I have a fairly busy SSRS Instance and the redering performance is consistently degrading to the point where we have set the recyle time config to 60 as work around and im still getting significant reduction in rendering performance within the hour. once the 60 minutes passes the performance goes back to an acceptable level and begins to degrade once more.



      I have played with the memory settings within the config but it doesnt seem to have made a difference. The server is dedicated to SSRS and there doesnt seem to be any memory pressure. at this second theres 32gb of memory and 28gb free with SSRS using around a gig.



      Looking in the log we have a lot of the following error



      httpruntime!ReportServer_0-193!2b84!05/17/2018-15:14:52:: e ERROR: Failed to 
      create worker request: pipeline=0x56C27945E0, exception=Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_INST130_0-193-131710375157483972. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeException: An error occurred in the HTTP Runtime object for application domain ReportServer_INST130_0-193-131710375157483972. Most likely, the HTTP request contains an unsupported verb or invalid syntax.
      rshost!rshost!2b84!05/17/2018-15:14:52:: e ERROR: HttpPipelineCallback::SendResponse(): failed writing response.
      rshost!rshost!2b84!05/17/2018-15:14:52:: e ERROR: Failed with win32 error 0x10DD, pipeline=0x00000056C27945E0.
      httpruntime!ReportServer_0-193!2b84!05/17/2018-15:14:52:: i INFO: RsHttpRuntime::ProcessRequest(): calling EndOfRequest() from exception handler of worker request constructor. Runtime=ReportServer_INST130_0-193-131710375157483972. Pipeline=0x56C27945E0.
      rshost!rshost!2b84!05/17/2018-15:14:52:: e ERROR: Failed to process request 0x800710dd, pipeline=0x00000056C27945E0.
      library!ReportServer_0-193!2218!05/17/2018-15:14:53:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeException: Unsupported HTTP verb 3., Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeException: An error occurred in the HTTP Runtime object for application domain ReportServer_INST130_0-193-131710375157483972. Most likely, the HTTP request contains an unsupported verb or invalid syntax.;
      library!ReportServer_0-193!2218!05/17/2018-15:14:53:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: Failed to fill worker request, Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_INST130_0-193-131710375157483972. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeException: An error occurred in the HTTP Runtime object for application domain ReportServer_INST130_0-193-131710375157483972. Most likely, the HTTP request contains an unsupported verb or invalid syntax.
      at ReportingServicesHttpRuntime.BaseWorkerRequest.FillWorkerRequest()


      I have been looking into this on and off for a while and im coming up blank.










      share|improve this question













      I have a fairly busy SSRS Instance and the redering performance is consistently degrading to the point where we have set the recyle time config to 60 as work around and im still getting significant reduction in rendering performance within the hour. once the 60 minutes passes the performance goes back to an acceptable level and begins to degrade once more.



      I have played with the memory settings within the config but it doesnt seem to have made a difference. The server is dedicated to SSRS and there doesnt seem to be any memory pressure. at this second theres 32gb of memory and 28gb free with SSRS using around a gig.



      Looking in the log we have a lot of the following error



      httpruntime!ReportServer_0-193!2b84!05/17/2018-15:14:52:: e ERROR: Failed to 
      create worker request: pipeline=0x56C27945E0, exception=Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_INST130_0-193-131710375157483972. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeException: An error occurred in the HTTP Runtime object for application domain ReportServer_INST130_0-193-131710375157483972. Most likely, the HTTP request contains an unsupported verb or invalid syntax.
      rshost!rshost!2b84!05/17/2018-15:14:52:: e ERROR: HttpPipelineCallback::SendResponse(): failed writing response.
      rshost!rshost!2b84!05/17/2018-15:14:52:: e ERROR: Failed with win32 error 0x10DD, pipeline=0x00000056C27945E0.
      httpruntime!ReportServer_0-193!2b84!05/17/2018-15:14:52:: i INFO: RsHttpRuntime::ProcessRequest(): calling EndOfRequest() from exception handler of worker request constructor. Runtime=ReportServer_INST130_0-193-131710375157483972. Pipeline=0x56C27945E0.
      rshost!rshost!2b84!05/17/2018-15:14:52:: e ERROR: Failed to process request 0x800710dd, pipeline=0x00000056C27945E0.
      library!ReportServer_0-193!2218!05/17/2018-15:14:53:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeException: Unsupported HTTP verb 3., Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeException: An error occurred in the HTTP Runtime object for application domain ReportServer_INST130_0-193-131710375157483972. Most likely, the HTTP request contains an unsupported verb or invalid syntax.;
      library!ReportServer_0-193!2218!05/17/2018-15:14:53:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: Failed to fill worker request, Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_INST130_0-193-131710375157483972. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeException: An error occurred in the HTTP Runtime object for application domain ReportServer_INST130_0-193-131710375157483972. Most likely, the HTTP request contains an unsupported verb or invalid syntax.
      at ReportingServicesHttpRuntime.BaseWorkerRequest.FillWorkerRequest()


      I have been looking into this on and off for a while and im coming up blank.







      sql-server reporting-services ssrs-2016






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked May 17 '18 at 15:31









      ZedZim

      337




      337
























          1 Answer
          1






          active

          oldest

          votes


















          0














          Try turning on the Report Server HTTP Log.



          You can then cross reference when the error occurs in the trace log, with the request that was logged in the HTTP log.
          Note that the timestamps in the trace log use local time, while the timestamps in the HTTP log use GMT.



          I have the same issue as you and found that unsupported verb was OPTIONS, which looks like it is being sent by a Microsoft Office application:




          11/21/2018 22:04:17 xx.xx.xx.xx DOMAINuser xx.xx.xx.xx 20480 ssrsServer OPTIONS /Reports/Pages/ 405 2589 0 1.1 Microsoft Office Protocol Discovery - - -




          I have not yet been able to determine how I can stop this error.






          share|improve this answer





















            Your Answer






            StackExchange.ifUsing("editor", function () {
            StackExchange.using("externalEditor", function () {
            StackExchange.using("snippets", function () {
            StackExchange.snippets.init();
            });
            });
            }, "code-snippets");

            StackExchange.ready(function() {
            var channelOptions = {
            tags: "".split(" "),
            id: "1"
            };
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function() {
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled) {
            StackExchange.using("snippets", function() {
            createEditor();
            });
            }
            else {
            createEditor();
            }
            });

            function createEditor() {
            StackExchange.prepareEditor({
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader: {
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            },
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            });


            }
            });














            draft saved

            draft discarded


















            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f50395324%2fssrs-performance-degradation%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            0














            Try turning on the Report Server HTTP Log.



            You can then cross reference when the error occurs in the trace log, with the request that was logged in the HTTP log.
            Note that the timestamps in the trace log use local time, while the timestamps in the HTTP log use GMT.



            I have the same issue as you and found that unsupported verb was OPTIONS, which looks like it is being sent by a Microsoft Office application:




            11/21/2018 22:04:17 xx.xx.xx.xx DOMAINuser xx.xx.xx.xx 20480 ssrsServer OPTIONS /Reports/Pages/ 405 2589 0 1.1 Microsoft Office Protocol Discovery - - -




            I have not yet been able to determine how I can stop this error.






            share|improve this answer


























              0














              Try turning on the Report Server HTTP Log.



              You can then cross reference when the error occurs in the trace log, with the request that was logged in the HTTP log.
              Note that the timestamps in the trace log use local time, while the timestamps in the HTTP log use GMT.



              I have the same issue as you and found that unsupported verb was OPTIONS, which looks like it is being sent by a Microsoft Office application:




              11/21/2018 22:04:17 xx.xx.xx.xx DOMAINuser xx.xx.xx.xx 20480 ssrsServer OPTIONS /Reports/Pages/ 405 2589 0 1.1 Microsoft Office Protocol Discovery - - -




              I have not yet been able to determine how I can stop this error.






              share|improve this answer
























                0












                0








                0






                Try turning on the Report Server HTTP Log.



                You can then cross reference when the error occurs in the trace log, with the request that was logged in the HTTP log.
                Note that the timestamps in the trace log use local time, while the timestamps in the HTTP log use GMT.



                I have the same issue as you and found that unsupported verb was OPTIONS, which looks like it is being sent by a Microsoft Office application:




                11/21/2018 22:04:17 xx.xx.xx.xx DOMAINuser xx.xx.xx.xx 20480 ssrsServer OPTIONS /Reports/Pages/ 405 2589 0 1.1 Microsoft Office Protocol Discovery - - -




                I have not yet been able to determine how I can stop this error.






                share|improve this answer












                Try turning on the Report Server HTTP Log.



                You can then cross reference when the error occurs in the trace log, with the request that was logged in the HTTP log.
                Note that the timestamps in the trace log use local time, while the timestamps in the HTTP log use GMT.



                I have the same issue as you and found that unsupported verb was OPTIONS, which looks like it is being sent by a Microsoft Office application:




                11/21/2018 22:04:17 xx.xx.xx.xx DOMAINuser xx.xx.xx.xx 20480 ssrsServer OPTIONS /Reports/Pages/ 405 2589 0 1.1 Microsoft Office Protocol Discovery - - -




                I have not yet been able to determine how I can stop this error.







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Nov 22 '18 at 21:37









                TimS

                1,3491324




                1,3491324






























                    draft saved

                    draft discarded




















































                    Thanks for contributing an answer to Stack Overflow!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid



                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.


                    To learn more, see our tips on writing great answers.





                    Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


                    Please pay close attention to the following guidance:


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid



                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.


                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function () {
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f50395324%2fssrs-performance-degradation%23new-answer', 'question_page');
                    }
                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    Different font size/position of beamer's navigation symbols template's content depending on regular/plain...

                    Berounka

                    I want to find a topological embedding $f : X rightarrow Y$ and $g: Y rightarrow X$, yet $X$ is not...