I have been debugging an issue where users of a database are experiencing slow performance periodically, which was traced to some slow SQL queries for some reports (the 50 second read operation was locking records, stopping any updates from running until the read finished). In response, we enabled SSRS caching for the slow queries (it did not matter if the reports for these datasets are 30-60 minutes behind real time), and changed the refresh interval of the report to 15 minutes instead of 5.