We have SSRS 2016 environment in SharePoint 2016 integrated mode. I observed there are some subscriptions which are taking longer time than expected, though not generating report (may be due to timeout), is there any way we can increase timeout period for subscriptions (not report processing time), if yes
1. Should we increase timeout for whole environment or just for affected subscriptions?
2. As per my understanding, by design subscriptions are processed sequentially not parallel so we don't have any control on subscription processing, any suggestions here if we can control it programatically?
3. We already automated the SQL queries but there are some subscriptions pulling data for long period (6-7 years), what can be done in this case to make subscriptions run?
We have only couple of Datasets and no caching plan setup as of now.
Any comments or suggestions would be greatly appreciated.