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.
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.**
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.