question

umamaheshravipudi-5220 avatar image
0 Votes"
umamaheshravipudi-5220 asked Joyzhao-MSFT commented

SSRS report is taking more time when the user is opening the report from UK

Facing wired issue with one existing SSRS report.

I am Working from India, have created one SSRS report & it is working fine for me.
Same report is accessing by users from London & Germany, It is taking 4 min to get the result.

I have done all the optimization in the query to render reports faster.
Could anyone help me to get this fix.

sql-server-generalsql-server-reporting-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @umamaheshravipudi-5220 ,
If the answer is helpful, please click "Accept Answer" and upvote it. Thanks for understanding.
Best Regards,
Joy

0 Votes 0 ·
Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered

Hi @umamaheshravipudi-5220 ,
I think the main culprit for slower loading due to region is network speed, which may be related to vpn and does not seem to be a report performance issue.
Best Regards,
Joy


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

Yes, I share Jayzhao's analysis that this is related to the network. I don't know much about SSRS, but this has all flavours of a chatty application, that connects to the server to run many quick short queries when it should have connected once to run a longer query to get all data. When you work locally, you don't see the penalty, but faraway users do

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.