SSRS Performance degradation
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
add a comment |
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
add a comment |
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
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
sql-server reporting-services ssrs-2016
asked May 17 '18 at 15:31
ZedZim
337
337
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
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.
add a comment |
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
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
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.
add a comment |
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.
add a comment |
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.
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.
answered Nov 22 '18 at 21:37
TimS
1,3491324
1,3491324
add a comment |
add a comment |
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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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