question

lokeshlehkara avatar image
lokeshlehkara asked

SSRS low Network Utilization

Hi, We have reports on Cloud as well as On Premise server. When I access the report through URL http://CloudServer/Reports it takes around 1 minute to initiate the report rendering. However, when I execute the report through our on premise server it take hardly 2, 3 seconds to start the report rendering. I have checked all the required RS configuration. Everything is fine. Although I have one probable reason. When I execute the report at on Premise Server the Network Activity (under resource monitor) shows Total (B/Sec) = 10,000 (Or More). For Cloud Server, Network Activity for Reporting Service is maximum of 5000. For some reason, our Cloud Server is not utilizing the Network in best way. Does anyone have any idea what is going wrong here? Any suggestion regarding Network or any other stuff.
ssrs-2012network
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

lokeshlehkara avatar image
lokeshlehkara answered
OH BOY!. Found the reason for this. At Cloud, SQL SERVER has "MAX DEGREE OF PARALLELISM = 1". This was restricting SQL to use only one core. Set it to 0 now. All good now. Argghhhhh... How I missed this at starting. Well! **THANK YOU KEN for your help.**
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Good find.
0 Likes 0 ·
KenJ avatar image
KenJ answered
Your on premises server doesn't have to push the data over the internet - or are you actually running the on premises report from somewhere else on the internet? If I ping an on premises server here on the LAN, the average round trip time is < 1 millisecond. If I ping a server in "the cloud" the round trip time averages 20ms. That, right there, could push report rendering on the client from 3 seconds to 60 seconds. Another factor could be CloudServer's ability to render the report on the server side. If that machine is not sized similarly to your on premises server, it won't be able to push the report as quickly.
3 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Hi Ken, First of all thanks for your response. I am accessing the report through internet from a complete different system. When I Ping the servers from my machine they both give me almost similar RTT. (Cloud Server is little late but not that much). Regarding your point "CloudServer's ability to render the report on the server side". Will this cause any delay for browser at my machine to load report? Is there any other set of tests which can help me identify the issue. I am not a network guy so whatever you suggest please provide me the details of it.
0 Likes 0 ·
If the server is slow in generating the report, then your machine will experience that slowness when rendering the report locally for you. Here are a few troubleshooting questions: Can you remote into the CloudServer and generate the report locally? Is that faster? Can you run a bandwidth test, like speedtest.net, from the CloudServer and from the on prem server? Any difference in performance with that? Does the provider that hosts the CloudServer have any known bandwidth limitations that your on prem server doesn't have? For example, maybe you only pay for 1mbps for the CloudServer buy have 10mbps for the on prem server. Can you monitor CPU, RAM and Disk during report generation? Any signs of stress on CloudServer during report generation? Where is the data source for the reports on CloudServer? Maybe there is slowness on the back end while it's gathering data for the report.
0 Likes 0 ·
I executed the report from CloudServer and same issue there as well. I tried checking the network speed but was not able to do so. Some security constraints while I try open any such site. Any another way to do so? There is no such limitations for bandwidth. I have confirmed this from higher authorities. Also, Reports are working fine at our CLOUD TEST Server. I did but did not found any stress or high memory consumption. But there is one specific issue I saw. When I select 'Analyze Wait Chain' under Network Activity It gave me this message. "one or more thread of ReportingServicesService.exe are waiting to finish network IO". This thing does not happen at CLOUD TEST or premise server. It is on same server. So this should not be an issue. Also, Problem which I see is not while loading the data. It is actually when browser is working on URL. (IE shows "WAITING for CLOUD SERVER" and keep on loading. Once page is loaded, it does not take much time to render the report.) Pheww... Let me know what next!!!!
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.