We are experiencing longer than should be, although intermittent, response times from Reporting Services server when requesting reports via HTTP. Here's what we've done to try and locate the issue.
We used the FireFox Net panel to locate the request that appears to be the culpret - it is the '...Pages/Report.aspx?ItemPath=...' request. This request sometimes returns in 2 seconds and sometimes it takes 20+ seconds
We have checked the Reporting Services ExecutionLogStorage table to see the actual report querying, processing and rendering times for the report and since the report has been up, the total time reported by Reporting Services is less than 3 seconds total (even less than 1 second most of the time)
We're almost positive that there isn't a network issue - we're able to ping the server (although on a different subnet) while the report is taking it's 20+ seconds to return and the network has excellent ping results
We've run a packet sniffer during the http request of the report - the browser sends a few messages to the server, the server responds.&n
View Complete Post