Zack
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.
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.
ASKER
Hi Huseyin,
My apologies 11-17 secs to 37-46 secs typo.
Thank you.
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
if it is not huuuge and simple
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
ASKER
Hi Nakul,
The reports haven't been changed recently and their no concurrent reports running when I was testing.
Thank you.
The reports haven't been changed recently and their no concurrent reports running when I was testing.
Thank you.
ASKER
Hi Nakul,
What do you mean by 'also force the plan to run in serial v/s parallel'?
Thank you.
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
OPTION (RECOMPILE)
to one of the queries and see if it makes any difference
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you very for the assistance I have a lot of reading and experimenting to do :)
share your findings here :)
I thought it is seconds, just live with it :)