Link to home
Start Free TrialLog in
Avatar of Zack
ZackFlag for Australia

asked on

SQL Server Reports (SSRS 2014) - Reports Timing Out

Hi EE,

All of the sudden multiple reports on our SSRS instance have begun timing out I have checked the underlying database no, or index/stats issues and IO performance (read/write) is between 11-16ms to great but not enough to cause problems. However, when running the SSRS reports that were having problems, I noticed the temp DB (On a separate Drive) read/write stats jumped from 37-46ms.

How would I begin troubleshooting this, any assistance is appreciated?

Thank you.
Avatar of HainKurt
HainKurt
Flag of Canada image

11-16ms to 37-46ms!!!
I thought it is seconds, just live with it :)
Avatar of Zack

ASKER

Hi Huseyin,

My apologies 11-17 secs to 37-46 secs typo.

Thank you.
dunno what the issue is but you may share the query so we can look at it to optimize it...
if it is not huuuge and simple
SOLUTION
Avatar of Nakul Vachhrajani
Nakul Vachhrajani
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Zack

ASKER

Hi Husseyin,

Unfortunately, it's way too big 2.5 pages. I am going to look in the execution logs for SSRS and see what I can come up with.

Do you know anything, in particular, I should keep an 'eye' for in the execution logs?

Thank you.
Avatar of Zack

ASKER

Hi Nakul,

The reports haven't been changed recently and their no concurrent reports running when I was testing.

Thank you.
Avatar of Zack

ASKER

Hi Nakul,

What do you mean by 'also force the plan to run in serial v/s parallel'?

Thank you.
can you add

OPTION (RECOMPILE)

to one of the queries and see if it makes any difference
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Zack

ASKER

Thank you very for the assistance I have a lot of reading and experimenting to do :)
share your findings here :)